Why is better and why?
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.
I work at a company with 10,000+ employees and I'm looking at these 2 cloud integration solutions: AWS Glue and Informatica Intelligent Cloud Services.
Please advise which one is the best choice and why?