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."Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft."
"From what we have seen so far, the solution seems very stable."
"We haven't had any issues connecting it to other products."
"Allows more data between on-premises and cloud solutions"
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"Its integrability with the rest of the activities on Azure is most valuable."
"The user interface is very good. It makes me feel very comfortable when I am using the tool."
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"It's a competent product."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"The interface is very user-friendly."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The performance and stability are good."
"It is easy to set up the solution."
"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 solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"It can improve from the perspective of active logging. It can provide active logging information."
"There's space for improvement in the development process of the data pipelines."
"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."
"The solution needs to be more connectable to its own services."
"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 are limitations when processing more than one GD file."
"The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"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."
"It would be nice if you could run SSIS on other environments besides Windows."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"We'd like more integration capabilities."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"Improvement as per customer requirements."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
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 Qlik Replicate, 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.