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: December 2024.
Informatica Intelligent Data Management Cloud (IDMC) and Azure Data Factory are significant players in the data management and integration market. Despite IDMC's flexibility and comprehensive toolset, Azure Data Factory holds an advantage due to its seamless integration with the Azure ecosystem, benefiting organizations invested in Microsoft technologies.Features: IDMC is notable for its robust integration capabilities, a flexible data model, and tools supporting data quality, master data...
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.