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."Data Factory's best features are simplicity and flexibility."
"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."
"An excellent tool for pipeline orchestration."
"The scalability of the product is impressive."
"Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
"What I like best about Azure Data Factory is that it allows you to create pipelines, specifically ETL pipelines. I also like that Azure Data Factory has connectors and solves most of my company's problems."
"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."
"It is beneficial that the solution is written with Spark as the back end."
"The UI is very user-friendly."
"The solution is easy to use and developer friendly."
"SSIS' most valuable feature is its reporting services."
"The initial setup of this solution is very straightforward."
"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 feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"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."
"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."
"The Microsoft documentation is too complicated."
"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."
"The deployment should be easier."
"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."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"The performance of this solution is not as good as other tools in the market."
"The security could be improved, as it is more important in our context."
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.
