We performed a comparison between Azure Data Factory and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most important feature is that it can help you do the multi-threading concepts."
"Data Flow and Databricks are going to be extremely valuable services, allowing data solutions to scale as the business grows and new data sources are added."
"In terms of my personal experience, it works fine."
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"The overall performance is quite good."
"It's extremely consistent."
"The trigger scheduling options are decently robust."
"For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"SSIS is easy to use."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The setup was easy. All Microsoft products are easy to set up."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."
"Azure Data Factory uses many resources and has issues with parallel workflows."
"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."
"There aren't many third-party extensions or plugins available in the solution."
"Data Factory's monitorability could be better."
"Improvement as per customer requirements."
"The high prices attached to the product can be an area of concern where improvements are required."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Azure Data Factory is rated 8.0, while SSIS is rated 7.6. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Talend Open Studio, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and Alteryx Designer. 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.
