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 Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy."
"Data Factory's most valuable feature is Copy Activity."
"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."
"Its integrability with the rest of the activities on Azure is most valuable."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
"We haven't had any issues connecting it to other products."
"The most valuable feature is the copy activity."
"It is easy to set up the solution."
"Overall, it's a good product."
"The performance is good."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The most important features are it works well and provides self-service BI."
"The performance and stability are good."
"SSIS integrates well with SQL servers and Microsoft products."
"It is easy to set up. The deployment is also very quick."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog."
"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."
"There's space for improvement in the development process of the data pipelines."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"It would be better if it had machine learning capabilities."
"There are limitations when processing more than one GD file."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"It would be nice if you could run SSIS on other environments besides Windows."
"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."
"At one point, we did have to purchase an add-on."
"We'd like them to develop data exploration more."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
Azure Data Factory is ranked 1st in Data Integration Tools with 47 reviews while SSIS is ranked 3rd in Data Integration Tools with 35 reviews. Azure Data Factory is rated 8.0, while SSIS is rated 7.6. The top reviewer of Azure Data Factory writes "The good, the bad and the lots of ugly". On the other hand, the top reviewer of SSIS writes "SSIS 2016 - The good, the bad, and the ugly". Azure Data Factory is most compared with Informatica PowerCenter, Microsoft Azure Synapse Analytics, Informatica Cloud Data Integration, Alteryx Designer and Oracle Data Integrator (ODI), whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), AWS Glue and SAP Data Services. See our Azure Data Factory vs. SSIS report.
See our list of best Data Integration Tools vendors.
We monitor all Data Integration Tools 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.