Azure Data Factory vs SSIS comparison

Azure Data Factory and SSIS are both solutions in the Data Integration category. Azure Data Factory is ranked #1 with an average rating of 8.1, while SSIS is ranked #4 with an average rating of 7.7. Azure Data Factory holds a 11.0% mindshare in DI, compared to SSIS’s 8.8% mindshare. Additionally, 92% of Azure Data Factory users are willing to recommend the solution, compared to 79% of SSIS users who would recommend it.

Azure Data Factory

Read 86 Azure Data Factory reviews

21,615 Views
17,232 Comparison Views

92% willing to recommend

SSIS

Read 72 SSIS reviews

14,200 Views
11,375 Comparison Views

79% willing to recommend

Azure Data Factory

SSIS

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Dec 19, 2024

SSIS and Azure Data Factory are competing products in the realm of data integration and transformation. Azure Data Factory seems to have the upper hand due to its cloud-native advantages and flexibility, making it a strong contender despite its higher costs.

Features: SSIS provides powerful ETL capabilities, deep integration with SQL Server, and pre-built components for complex data flows, suitable for on-premises environments. Azure Data Factory supports cloud-native scalability, a wide variety of data sources, and advanced data orchestration with real-time processing.

Room for Improvement: SSIS could enhance its cloud capabilities, simplify its deployment process, and improve scalability. Azure Data Factory might reduce its complexity, offer better cost management options, and enhance its integration with non-Microsoft platforms.

Ease of Deployment and Customer Service: Azure Data Factory offers rapid scalability without the need for physical infrastructure, with robust cloud support from Microsoft. SSIS, being on-premise, can be complex to deploy, requiring significant infrastructure but benefits from direct integration with Microsoft ecosystems.

Pricing and ROI: SSIS is cost-effective for organizations within Microsoft infrastructure with lower setup costs. Its ROI is potentially limited by infrastructure complexity. Azure Data Factory, with higher upfront costs, provides significant ROI through its flexible and scalable cloud capabilities.

To learn more, read our detailed Azure Data Factory vs. SSIS Report (Updated: December 2024).

Buyer's Guide

Azure Data Factory vs. SSIS

December 2024

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

Azure Data Factory

Ranking in Data Integration

1st

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (3rd)

SSIS

Ranking in Data Integration

4th

Average Rating

7.6

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of December 2024, in the Data Integration category, the mindshare of Azure Data Factory is 11.0%, down from 13.3% compared to the previous year. The mindshare of SSIS is 8.8%, down from 9.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration

Featured Reviews

Thulani David Mngadi

Data architect at Old Mutual

Data flow feature is valuable for data transformation tasks

The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.

Read full review

Sakiru Dosumu

Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.

Its ability to transform and transport data is extremely valuable

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

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

"I like that it's a monolithic data platform. This is why we propose these solutions."

"The most valuable features of the solution are its ease of use and the readily available adapters for connecting with various sources."

"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."

"The scalability of the product is impressive."

"Data Factory's best features are simplicity and flexibility."

"One advantage of Azure Data Factory is that it's fast, unlike SSIS and other on-premise tools. It's also very convenient because it has multiple connectors. The availability of native connectors allows you to connect to several resources to analyze data streams."

"For developers that are very accustomed to the Microsoft development studio, it's very easy for them to complete end-to-end data integration."

"Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft."

More Azure Data Factory pros

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The initial setup of this solution is very straightforward."

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

"The technical support is very good."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"The script component is very powerful, things that you cannot normally do, is feasible through C#."

"The interface is very user-friendly."

"The performance is good."

More SSIS pros

Cons

"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."

"There is no built-in pipeline exit activity when encountering an error."

"In the next release, it's important that some sort of scheduler for running tasks is added."

"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."

"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."

"The setup and configuration process could be simplified."

"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."

"Integration of data lineage would be a nice feature in terms of DevOps integration. It would make implementation for a company much easier. I'm not sure if that's already available or not. However, that would be a great feature to add if it isn't already there."

More Azure Data Factory cons

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

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"We have issues with SSIS connectors while extracting data from Excel sources."

"The creation of the measure in the DAC's model could be improved."

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

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

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

"This solution needs full support for real-time processing."

More SSIS cons

Pricing and Cost Advice

"The licensing is a pay-as-you-go model, where you pay for what you consume."

"The cost is based on the amount of data sets that we are ingesting."

"The solution's pricing is competitive."

"The licensing cost is included in the Synapse."

"I rate the product price as six on a scale of one to ten, where one is low price and ten is high price."

"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."

"Understanding the pricing model for Data Factory is quite complex."

"I am aware of the pricing of Azure Data Factory, but I prefer not to disclose specific details."

More Azure Data Factory pricing and cost advice

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

"It would be beneficial if the solution had a less costly cloud offering."

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

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

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"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 comes free of cost."

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

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

824,053 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

13%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Financial Services Firm

18%

Computer Software Company

12%

Government

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

See all answers

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

See all answers

How does Azure Data Factory compare with Informatica Cloud Data Integration?

Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...

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?

The solution comes free of cost.

See all answers

Comparisons

Informatica PowerCenter vs Azure Data Factory

Compared 13% of the time

Snowflake vs Azure Data Factory

Compared 10% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Azure Data Factory

Compared 8% of the time

Alteryx Designer vs Azure Data Factory

Compared 7% of the time

IBM InfoSphere DataStage vs Azure Data Factory

Compared 4% of the time

More Azure Data Factory Competitors

Informatica PowerCenter vs SSIS

Compared 23% of the time

Talend Open Studio vs SSIS

Compared 13% of the time

Oracle Data Integrator (ODI) vs SSIS

Compared 8% of the time

IBM InfoSphere DataStage vs SSIS

Compared 8% of the time

AWS Glue vs SSIS

Compared 4% of the time

More SSIS Competitors

Product Reports

Buyer's Guide

Azure Data Factory

December 2024

Download Azure Data Factory product report

Buyer's Guide

SSIS

November 2024

Download SSIS product report

Also Known As

No data available

SQL Server Integration Services

Learn More

Microsoft

Overview

Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

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.

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa

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

Azure Data Factory vs. SSIS

December 2024

Free Report: Azure Data Factory vs. SSIS

Find out what your peers are saying about Azure Data Factory vs. SSIS and other solutions. Updated: December 2024.

DOWNLOAD NOW

824,053 professionals have used our research since 2012.

See our Azure Data Factory vs. SSIS report.

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.