I haven't found any difficulties managing different data standards. The team and everyone at Informatica Corporation are friendly, and the documentation is self-learning and self-taught, presented in an understandable format with pictorial representations that help us not to depend on others. The only challenge is reading through around 200 pages of documentation, which can be a pain point.
Informatica is easy to integrate with other tools using APIs. However, it has some difficulties. Informatica appears to build revenue by offering different environments. If you have a rare setup, such as SAP HANA CRM systems, it isn't bundled within a standard license, so purchasing an exclusive license is necessary for integrating such atypical systems. These should be included as part of a single license.
Some connections, like MongoDB, are straightforward, and Oracle works well under a single license, but certain source systems pose challenges in managing connections and integration, such as SAP systems and CRM systems, where licenses must be obtained separately from Informatica.
If you have an SAP environment, it's better to consider alternatives or be aware that additional costs may incur for integration.
On a scale of 1-10, I rate Informatica Intelligent Data Management Cloud (IDMC) a 10 out of 10.