Azure Data Factory vs. SSIS Data Flow Components

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure Data Factory
Score 9.0 out of 10
N/A
Microsoft's Azure Data Factory is a service built for all data integration needs and skill levels. It is designed to allow the user to easily construct ETL and ELT processes code-free within the intuitive visual environment, or write one's own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on data—the serverless integration service does the rest.N/A
SSIS Data Flow Components
Score 8.1 out of 10
N/A
Devart SSIS Data Flow Components are designed to simplify the ETL process within SQL Server Integration Services (SSIS) packages, allowing users to connect cloud applications and databases through their SSIS workflows without the need to write complex code. Export data from various sources to different file formats Import XML, CSV, and other files to cloud applications and databases Synchronize cloud applications and databases Migrate from one…
$549.95
one-time fee
Pricing
Azure Data FactorySSIS Data Flow Components
Editions & Modules
No answers on this topic
SSIS Integration Database Bundle
$549.95
one-time fee
SSIS Integration Cloud Bundle
$749.95
one-time fee
SSIS Integration Universal Bundle
$999.95
one-time fee
Offerings
Pricing Offerings
Azure Data FactorySSIS Data Flow Components
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsPurchase includes a perpetual product license and a 1 year of subscription which includes the product updates and premium support.
More Pricing Information
Community Pulse
Azure Data FactorySSIS Data Flow Components
Features
Azure Data FactorySSIS Data Flow Components
Data Source Connection
Comparison of Data Source Connection features of Product A and Product B
Azure Data Factory
9.0
Ratings
7% above category average
SSIS Data Flow Components
-
Ratings
Connect to traditional data sources9.00 Ratings00 Ratings
Connecto to Big Data and NoSQL9.00 Ratings00 Ratings
Data Transformations
Comparison of Data Transformations features of Product A and Product B
Azure Data Factory
8.5
Ratings
4% above category average
SSIS Data Flow Components
-
Ratings
Simple transformations9.00 Ratings00 Ratings
Complex transformations8.00 Ratings00 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Azure Data Factory
7.2
Ratings
10% below category average
SSIS Data Flow Components
-
Ratings
Data model creation8.00 Ratings00 Ratings
Metadata management7.00 Ratings00 Ratings
Business rules and workflow7.00 Ratings00 Ratings
Collaboration6.00 Ratings00 Ratings
Testing and debugging7.00 Ratings00 Ratings
Data Governance
Comparison of Data Governance features of Product A and Product B
Azure Data Factory
7.5
Ratings
8% below category average
SSIS Data Flow Components
-
Ratings
Integration with data quality tools7.00 Ratings00 Ratings
Integration with MDM tools8.00 Ratings00 Ratings
User Ratings
Azure Data FactorySSIS Data Flow Components
Likelihood to Recommend
9.0
(0 ratings)
-
(0 ratings)
Support Rating
7.0
(0 ratings)
-
(0 ratings)
User Testimonials
Azure Data FactorySSIS Data Flow Components
Likelihood to Recommend
In a data pipeline, you will be able to add different kinds of activities for example connect from your on-premise SFTP and move CSV files to storage accounts. As well data factory has its own data flow if you are an ETL developer who experimented with maybe you have worked with SSIS, thus, you will start quickly with this new feature of the data factory.
Read full review
No answers on this topic
Pros
  • Creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code.
  • Hybrid data integration is easily and agilely possible through this software.
  • It has lot of various useful components
Read full review
No answers on this topic
Cons
  • Learning curve for pipeline creation interface.
  • Alerting isn't necessarily built in. Had to work around this to meet team needs.
  • With GIT enabled, some features can only be done via git, while some need to be done via the portal.
Read full review
No answers on this topic
Usability
So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.
Read full review
No answers on this topic
Support Rating
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
Read full review
No answers on this topic
Alternatives Considered
Azure Data Factory fits well into our overall systems architecture where we already utilize largely Azure services and also Microsoft based products in the on-premises environment. I think cost structure is also very competitive with Azure Data Factory. Most services provide a visual interface for designing ETL workflows, but our team found Azure Data Factory's interface more intuitive.
Read full review
No answers on this topic
Return on Investment
  • Limiting the amount of data moving up and down from the cloud for cloud-native applications.
  • Overall simple to use interface which is actually easier for a first time ETL developer than SSIS.
Read full review
No answers on this topic
ScreenShots

SSIS Data Flow Components Screenshots

Screenshot of Screenshot of