Azure Data Factory vs. HVR (discontinued)

Azure Data Factory is a great data integration tool for developing a cloud data platform, especially within the Azure ecosystem. Azure Data Factory is very good for the Data Ingestion part. It can work for simple data transformation with its Data Flow, but it will also need cluster configuration, and there is some cost. Also, it is an excellent tool for orchestrating data pipelines. But for complex data transformations, you may need to use technologies like Databricks and PySpark.

Incentivized

HVR is a real-time replication tool, if you want to centralize your database to cloud in order to provide the best services to your clients or end-users then HVR plays a vital role. multiple sources such as on-premises and cloud databases need to be combined or out together on cloud for creating a centralized warehouse then HVR is very much useful as a replication tool. HVR is a very robust tool.

Incentivized

• Azure Data Factory supports a vast array of source and destination connectors, both from within the Microsoft ecosystem (like Azure Blob Storage, Azure SQL Database, Azure Cosmos DB) and external platforms (like Amazon S3, Google Cloud Storage, SAP, Salesforce, and many more).
• Azure Data Factory's Mapping Data Flows provides a code-free environment to design data transformations visually. Users can drag and drop elements to create complex ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes without needing to write any code.
• Azure Data Factory provides a unified monitoring dashboard that offers a holistic view of all pipeline activities. I think this makes it easier for users to track the status of various jobs, identify failures, and pinpoint bottlenecks.

Incentivized

• Data replication from source to target system
• Almost Realtime data refresh
• CDC solution

Incentivized

• For complex JSON when it comes to mapping nested attribute it's not easy to flatten out
• Data Factory V1 does not have a good implementation experience as compared to V2
• Work with on premise solutions sometimes is not too friendly because you will need to set a VPN

Incentivized

• Connectivity with more source such as salesforce
• Missing Enterprise manager

Incentivized

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.

Incentivized

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

Incentivized

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.

Incentivized

HVR was cost-efficient to us compare to other tools also we had a demo with our data and found out that HVR's performance is much better when replicating data from SAP to Snowflake compare to any other tool. A huge volume of data can be handled very easily. Also, the connectivity with the number of sources to pull the data is very good and they are continuously adding more sources.

Incentivized

• It is very useful and make things easier
• Debugging can improve
• Its better suited than other products with the same objective

Incentivized

• Almost Real time data availability
• Makes Reporting easy for BI team
• Quick development saves human efforts

Incentivized