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."Powerful but easy-to-use and intuitive."
"The feature I found most helpful in Azure Data Factory is the pipeline feature, including being able to connect to different sources. Azure Data Factory also has built-in security, which is another valuable feature."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"The best part of this product is the extraction, transformation, and load."
"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 flexibility that Azure Data Factory offers is great."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"I like that it's a monolithic data platform. This is why we propose these solutions."
"It's saved time using visualization descriptions."
"SSIS' most valuable feature is its reporting services."
"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."
"The performance is good."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The data reader is the most valuable feature."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."
"We have experienced some issues with the integration. This is an area that needs improvement."
"Some of the optimization techniques are not scalable."
"The setup and configuration process could be simplified."
"We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."
"Azure Data Factory uses many resources and has issues with parallel workflows."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"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."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"It would be nice if you could run SSIS on other environments besides Windows."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"At one point, we did have to purchase an add-on."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"We'd like them to develop data exploration more."
"I would like to see better integration with Power BI."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
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.
