Precisely Connect vs SSIS comparison

Precisely and Microsoft are both solutions in the Data Integration category. Precisely is ranked #40 with an average rating of 8.0, while Microsoft is ranked #3 with an average rating of 7.8. Precisely holds a 0.3% mindshare in DI, compared to Microsoft’s 7.7% mindshare. Additionally, 100% of Precisely users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

Precisely Connect

Read 1 Precisely Connect review

298 Views
200 Comparison Views

100% willing to recommend

SSIS

Read 74 SSIS reviews

11,026 Views
7,140 Comparison Views

79% willing to recommend

Precisely Connect

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Precisely Connect and SSIS based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration.

To learn more, read our detailed Data Integration Report (Updated: June 2025).

Buyer's Guide

Data Integration

June 2025

Download the complete report

Helped 856,873 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Precisely Connect

Ranking in Data Integration

40th

Average Rating

8.0

Reviews Sentiment

6.3

Number of Reviews

Ranking in other categories

No ranking in other categories

SSIS

Ranking in Data Integration

3rd

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of June 2025, in the Data Integration category, the mindshare of Precisely Connect is 0.3%, up from 0.2% compared to the previous year. The mindshare of SSIS is 7.7%, down from 7.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

reviewer2667306

Data Engineer at a consultancy with 1-10 employees

AI compliance integration elevates data quality and decision-making

I usually implement Precisely and Collibra tools for clients to enhance data quality. My main use case involves working with the data catalog of Precisely to integrate data management processes and ensure data governance Precisely has the AI Act already implemented into the data catalog, which…

Read full review

Sean Achim

Managing Director at Knights Innovation Support Centre

Building impactful organizational KPIs with ease and precision

Stability is rated at 10. One other important aspect I appreciate is that SSAS is included in the base installation of SQL Server. Obviously, it requires installation, but it is readily available, which is a major strength. It's all about setting it up, configuring it, and then using it. If there are additional costs associated with it or separating it as a second product, that would be a disadvantage. The area of improvement is really in education. Microsoft is trying to push everything as a Power BI solution or trying to get people to solve the problems which are solved with SSAS in another space in Power BI, or in Power Pivot, is not enough. There's not enough marketing, conversation, and support around that space. As a result, we end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model. That leads people to consider alternate solutions because SAP and others argue that their whole thing is in memory, and they disseminate misleading information. Additionally, what would be very helpful is local user group developments, so getting people around the table and teaching them how to use it. That is the biggest problem; it's not the technology itself. The challenge lies in Microsoft withdrawing a lot of the qualifications and watering down its emphasis, leading to a perception that this is supposed to be an elite product.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Using Precisely improves data quality, which can lead to a 30% increase in revenue and boost net income by 20% to 25% if implemented correctly."

"Precisely has the AI Act already implemented into the data catalog, which allows the integration of the European Artificial Intelligence Act into our processes."

"Overall, it's a good product."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"SSIS' best feature is SFTP connectivity."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

"SSIS integrates well with SQL servers and Microsoft products."

"The setup is easy to use and understand."

More SSIS pros

Cons

"Precisely works with a tool called Analyze, which has a steep learning curve due to its use of Jython, a combination of Java and Python. This could be improved to make the tool more user-friendly."

"It would be nice if you could run SSIS on other environments besides Windows."

"Video training would be a helpful addition."

"I would like to see better technical documentation because many times information is missing."

"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."

"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."

"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."

More SSIS cons

Pricing and Cost Advice

Information not available

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"All of my clients have this product included as part of their Microsoft license."

"SSIS is a cheaper option compared to the cost of other ETL tools."

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"SSIS is fairly well-priced - I would rate it at four out of five."

More SSIS pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

856,873 professionals have used our research since 2012.

Comparison Review

it_user90069

BI Expert at a healthcare company with 1,001-5,000 employees

Feb 20, 2014

Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities

Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…

Read full review

Top Industries

By visitors reading reviews

Insurance Company

21%

Financial Services Firm

14%

Government

11%

Manufacturing Company

Financial Services Firm

19%

Computer Software Company

12%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What is your experience regarding pricing and costs for Precisely Connect?

Precisely has a high entry price, which is why it is not suitable for small to mid-sized organizations.

See all answers

What needs improvement with Precisely Connect?

Precisely works with a tool called Analyze, which has a steep learning curve due to its use of Jython, a combination of Java and Python. This could be improved to make the tool more user-friendly.

See all answers

What is your primary use case for Precisely Connect?

See all answers

Which is better - SSIS or Informatica PowerCenter?

SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...

See all answers

What do you like most about SSIS?

The product's deployment phase is easy.

See all answers

What is your experience regarding pricing and costs for SSIS?

Utilizing SSIS involves no extra charges beyond the SQL Server license. It's an economical choice for my clients.

See all answers

Comparisons

Qlik Replicate vs Precisely Connect

Compared 70% of the time

Informatica PowerCenter vs Precisely Connect

Compared 30% of the time

More Precisely Connect Competitors

Informatica PowerCenter vs SSIS

Compared 17% of the time

Talend Open Studio vs SSIS

Compared 11% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 7% of the time

IBM InfoSphere DataStage vs SSIS

Compared 7% of the time

dbt vs SSIS

Compared 6% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Data Integration

June 2025

Download Precisely Connect product report

Buyer's Guide

SSIS

May 2025

Download SSIS product report

Also Known As

DMExpress, Syncsort DMX, Syncsort Connect ETL

SQL Server Integration Services

Overview

Transforming and delivering application data for analytics with speed, efficiency and a flexible “design once, deploy anywhere” approach

Precisely

SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.

Microsoft

Sample Customers

Hermes, Kantar Worldpanel, Kojima Press Industry Co. Ltd., OTC Markets Group, Experian, Co-operative Group, State of Tennessee Department of Human Services, Centers for Medicare & Medicaid Services, Silverton, comScore

1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo

Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration. Updated: June 2025.

DOWNLOAD NOW

856,873 professionals have used our research since 2012.

See our list of best Data Integration vendors.

We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.