Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Query Online or by using a GUI to map them. Azure Data Factory can integrate with about 80 data sources, such as generic protocols, SaaS platforms, SQL and NoSQL databases, and other various file types. In addition, it supports both cloud and on-premise data warehouse and database destinations. In terms of support, there are multiple Azure Data Factory help options via online forums, online support request forms, email, or phone support. It is also easy to find digital training materials.
One disadvantage about Azure is that it does not have data sharing. Azure’s Data Factory pricing model can be frustrating for some organizations since it is based on the number of pipeline orchestration runs, the number of compute-hours for debugging and flow execution, and the number of operations like pipeline monitoring. In contrast, Informatica has a base version of Integration Cloud starting at a standard rate of $2,000 per month.
Even though I am a fan of Azure, I like Informatica Cloud Data Integration more. While Azure’s main focus is ETL, Informatica focuses on both ETL as well as data integration. Similar to Azure, Informatica also has a comparable range of transformations. However, Informatica provides a library of their available transformations, in addition to giving you the ability to customize them using a proprietary transformation language. Unlike Azure, Informatica has data sharing through their Informatica cloud. Informatica also provides Cloud Connectors for over 100 applications and databases, and if developers need to create new connectors, they can do so using Informatica’s Connector Toolkit. Regarding technical support, Informatica is very helpful and even has an online training program made available through their own Informatica University. In addition, Informatica has a 30-day free trial.
Conclusion: For me, it was an easy choice of which product to buy. Informatica Cloud Data Integration has way more to offer in terms of features and benefits, while Azure’s package just didn’t seem as appealing to me.
We performed a comparison between Azure Data Factory and Informatica Cloud Data Integration based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Ease of Deployment: Azure Data Factory users say the initial setup is straightforward. Some Informatica Cloud Data Integration users say the initial setup is straightforward while others say it is complex.
Features: Users of both products are happy with their stability,...
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Query Online or by using a GUI to map them. Azure Data Factory can integrate with about 80 data sources, such as generic protocols, SaaS platforms, SQL and NoSQL databases, and other various file types. In addition, it supports both cloud and on-premise data warehouse and database destinations. In terms of support, there are multiple Azure Data Factory help options via online forums, online support request forms, email, or phone support. It is also easy to find digital training materials.
One disadvantage about Azure is that it does not have data sharing. Azure’s Data Factory pricing model can be frustrating for some organizations since it is based on the number of pipeline orchestration runs, the number of compute-hours for debugging and flow execution, and the number of operations like pipeline monitoring. In contrast, Informatica has a base version of Integration Cloud starting at a standard rate of $2,000 per month.
Even though I am a fan of Azure, I like Informatica Cloud Data Integration more. While Azure’s main focus is ETL, Informatica focuses on both ETL as well as data integration. Similar to Azure, Informatica also has a comparable range of transformations. However, Informatica provides a library of their available transformations, in addition to giving you the ability to customize them using a proprietary transformation language. Unlike Azure, Informatica has data sharing through their Informatica cloud. Informatica also provides Cloud Connectors for over 100 applications and databases, and if developers need to create new connectors, they can do so using Informatica’s Connector Toolkit. Regarding technical support, Informatica is very helpful and even has an online training program made available through their own Informatica University. In addition, Informatica has a 30-day free trial.
Conclusion:
For me, it was an easy choice of which product to buy. Informatica Cloud Data Integration has way more to offer in terms of features and benefits, while Azure’s package just didn’t seem as appealing to me.