Item: Azure Data Factory
Rating: 9
Author: Niloofar Keshvari Nia

Use Cases and Deployment Scope

Get full data integration at scale with Microsoft Azure Data Factory's management service for serverless data integration,‌ hybrid data integration is easily and agilely possible through this software. We are creating ETL and ELT workflows as well as orchestrating and monitoring pipelines without writing any code. Full management and serverless integration with default features installed on the system and various connectors reduce costs. It is used in all company departments and project management units of our customers. Since ADF adopts an intelligent intent-driven mapping methodology, it enables copy activities to be automated.

Pros and Cons

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

It should integrate more ETL and audit functionality.
Pipelines lack flexibility because moving Data Factory pipelines between different environments, such as for development or testing, require increased security and flexibility.
The number of pre-defined templates is small and they should have more variety.

Return on Investment

Facilitate better decision-making and improve business processes.
Optimize business process outcomes by increasing internal efficiency and operational effectiveness.
Boosts revenue growth while improving business process agility.

Alternatives Considered

IBM InfoSphere DataStage, SnapLogic and Pentaho

The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.

Key Insights

Do you think Azure Data Factory delivers good value for the price?

Yes

Are you happy with Azure Data Factory's feature set?

Yes

Did Azure Data Factory live up to sales and marketing promises?

Yes

Did implementation of Azure Data Factory go as expected?

Yes

Would you buy Azure Data Factory again?

Yes

Other Software Used

Azure Backup, Microsoft Azure, Azure Cosmos DB

Likelihood to Recommend

If you know a bit about database management everything is pretty easy, based on my personal experience. You can build a lot of things entirely in design, even if you do not know all the syntax, [since] having ready-made templates simplifies everything to get started and build the first pipeline.

Database management and ETL tool for big data that is smart and reliable

Overall Satisfaction with Azure Data Factory