CData Connect Cloud vs SSIS comparison

CData Software and Microsoft are both solutions in the Cloud Data Integration category. Additionally, 100% of CData Software users are willing to recommend the solution, compared to 79% of Microsoft users who would recommend it.

CData Connect Cloud

Read 1 CData Connect Cloud review

123 Views
23 Comparison Views

100% willing to recommend

SSIS

Read 74 SSIS reviews

11,026 Views
7,140 Comparison Views

79% willing to recommend

CData Connect Cloud

SSIS

Comparison Buyer's Guide

Download the report

Executive Summary

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

Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration.

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

Buyer's Guide

Cloud Data Integration

May 2025

Download the complete report

Helped 855,080 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

CData Connect Cloud

Average Rating

8.0

Reviews Sentiment

5.8

Number of Reviews

Ranking in other categories

Data Virtualization (7th), Cloud Data Integration (28th)

SSIS

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Integration (3rd)

Featured Reviews

Zain Amjed

Business Intelligence Manager at a real estate/law firm with 5,001-10,000 employees

Accurate data and reliable

CData Connect is used to extract data from our own Facebook ads campaigns The most valuable feature of CData Connect is the accuracy of the data. The amount of data that can be extracted at one point in time should be improved. I have been using CData Connect for approximately three months.…

Read full review

Albert Lacerda

Managing Partner at Dynamis Informatica

Efficient data processing and seamless cloud integration have been achieved through powerful data pipelines

One of the best aspects of SSIS ( /products/ssis-reviews ) is that it is built into Microsoft SQL Server ( /products/sql-server-reviews ), so there are no additional costs involved. Despite the complexity when dealing with advanced transformations, it is straightforward for simple data movements, and the performance is excellent. I can process 1.2 million lines of data in a few minutes, even when running over a VPN connection.

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

"The most valuable feature of CData Connect is the accuracy of the data."

"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

"The initial setup was easy."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"The solution is stable."

"The solution is easy to use and developer friendly."

"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."

"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."

More SSIS pros

Cons

"The amount of data that can be extracted at one point in time should be improved."

"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

"The solution could improve on integrating with other types of data sources."

"It needs more integration tools, so you can connect to different sources."

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

"It's a legacy tool, that is nearing the end of its useful life."

"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."

"Video training would be a helpful addition."

More SSIS cons

Pricing and Cost Advice

Information not available

"SSIS' licensing is a little high, but it gives good value for money."

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."

"People have to opt for a perpetual-based licensing model."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"This solution is included with the MSSQL server package."

"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."

"The solution is available at a lesser price than that of Informatica."

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

More SSIS pricing and cost advice

See which vendors are best for you

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

See recommendations

855,080 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

Financial Services Firm

16%

Computer Software Company

13%

Media Company

Hospitality 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

Ask a question

Earn 20 points

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

Fivetran vs CData Connect Cloud

Compared 100% of the time

More CData Connect Cloud 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

Cloud Data Integration

May 2025

Download CData Connect Cloud product report

Buyer's Guide

SSIS

May 2025

Download SSIS product report

Also Known As

No data available

SQL Server Integration Services

Overview

Connect instantly to your favorite cloud apps and data solutions without installing software. CData simplifies the complexity by providing a consistent interface regardless of the source system. Get direct, live connectivity to any app, like Salesforce, SharePoint, and Workday, or data solution, like BigQuery, MongoDB, Snowflake, S3, and Databricks. And for any additional sources, you can use the API connector to create data connections in minutes without coding.

Effortlessly access and explore data directly from your favorite tools and platforms.

Purpose-built native clients for Power BI, Tableau, Microsoft Excel, Google Sheets, Looker Studio, AWS Glue, Python, and more
SQL Server virtualization for dozens of other cloud tools including Looker, Amazon QuickSight, Qlik Sense, SAP Analytics Cloud, Microsoft Power Apps, and more
Standards-based connectors for IT, developers, and data scientists, including JDBC, ODBC, and ADO.NET

With CData Connect Cloud, your organization can efficiently manage access to all cloud data from a single, high-performance, elastic platform that provides robust security and auditing capabilities. And, with granular user permissions, stakeholders can only access or modify the data they are authorized for in each source system.

CData Software

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

Adeptia, Tibco, Matillion, Exago, Izenda, Alfresco, Cisco, DataRobot, BigID, Combit

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

Buyer's Guide

Cloud Data Integration

May 2025

Download Free Report

Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration. Updated: May 2025.

DOWNLOAD NOW

855,080 professionals have used our research since 2012.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud 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.