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 valuable aspect is the copy capability."
"We haven't had any issues connecting it to other products."
"In terms of my personal experience, it works fine."
"The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages."
"It is easy to integrate."
"Its integrability with the rest of the activities on Azure is most valuable."
"The trigger scheduling options are decently robust."
"It is easy to set up. The deployment is also very quick."
"SSIS' most valuable feature is its reporting services."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"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 technical support is very good."
"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."
"In the next release, it's important that some sort of scheduler for running tasks is added."
"The setup and configuration process could be simplified."
"There is no built-in pipeline exit activity when encountering an error."
"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
"The pricing scheme is very complex and difficult to understand."
"The number of standard adaptors could be extended further."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"Azure Data Factory's pricing in terms of utilization could be improved."
"It hangs a lot of the time."
"I would like to see better technical documentation because many times information is missing."
"It needs more integration tools, so you can connect to different sources."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"It would be nice if you could run SSIS on other environments besides Windows."
"Tuning using this solution requires extensive expertise to improve performance."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
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 Matillion ETL, 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.
