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."It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"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."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"We use the solution to move data from on-premises to the cloud."
"It is easy to integrate."
"Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The setup is straightforward. It's very easy to install."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The setup was easy. All Microsoft products are easy to set up."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"It would be better if it had machine learning capabilities."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"For some of the data, there were some issues with data mapping. Some of the error messages were a little bit foggy. There could be more of a quick start guide or some inline examples. The documentation could be better."
"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."
"The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."
"On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Future releases should improve the data lineage, as it currently is not good."
"I would like to see better integration with Power BI."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"It's a legacy tool, that is nearing the end of its useful life."
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.