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.
Find out what your peers are saying about Azure Data Factory vs. Informatica Intelligent Data Management Cloud (IDMC) and other solutions. Updated: October 2024.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
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.