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 feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"It is beneficial that the solution is written with Spark as the back end."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"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 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 UI is very user-friendly."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"We can connect with multiple data sources easily using an external connector in SSIS."
"It is easy to set up the solution."
"It is easy to set up. The deployment is also very quick."
"The one element of the solution that we have used and could be improved is the user interface."
"The pricing model should be more transparent and available online."
"The product's technical support has certain shortcomings, making it an area where improvements are required."
"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."
"I have not found any real shortcomings within the product."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"The product could provide more ways to import and export data."
"Generic processes should be used instead of custom code for each table."
"We'd like them to develop data exploration more."
"It needs more integration tools, so you can connect to different sources."
"I would like to see more features in terms of the integration with Azure Data Factory."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"The security could be improved, as it is more important in our context."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"Tuning using this solution requires extensive expertise to improve performance."
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.
