Informatica PowerExchange and Informatica Intelligent Data Management Cloud (IDMC) are both competitors in the data integration and management category. While IDMC has an upper hand due to its cloud-native architecture and scalability, PowerExchange is preferred for its integration capabilities with large databases like Teradata.
Features: Informatica PowerExchange offers robust real-time data capture, high performance in data transformation, and broad connectivity. Its native real-time scanning and change data capture are highly valuable. IDMC integrates data quality and management across multiple domains, features a cloud-native design, and offers significant scalability. Users highlight its enterprise-scale performance and rich integration toolkit.
Room for Improvement: Informatica PowerExchange needs better integration capabilities and a user-friendly interface. Real-time processing and high availability features need enhancement, and pricing is a significant concern with a call for better technical support. For IDMC, enhancing integration with other systems and adding more connectors is recommended. Users seek better user interfaces, automation, and cloud feature parity improvements.
Ease of Deployment and Customer Service: Informatica PowerExchange is mainly on-premises with noted complexity in setup, while customer service is reliable but criticized for delayed responses. IDMC stands out with flexible cloud deployment, simplifying cloud implementations, though users desire a more intuitive interface. Support is generally good, though some variability in response time is noted.
Pricing and ROI: Informatica PowerExchange uses a capacity-based pricing model that can be costly but offers reliable value with efficient use, featuring straightforward licensing for real-time integration. Its ROI is seen in operational streamlining and potential savings. IDMC's pricing depends on data volume and complexity, potentially expensive for large sets, but offers scalable options, leading to faster ROI, especially in digital transformation projects.
We see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
If they are unsure how to resolve an issue, they keep customers informed, providing updates about progress and ensuring communication with the product team to deliver accurate responses.
I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
I find Informatica Intelligent Data Management Cloud (IDMC) to be a sustainable and scalable solution.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach.
The observability concept in Informatica Intelligent Data Management Cloud (IDMC) needs improvement as the capabilities are not up to the mark compared to the industry.
The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
IDMC is often described as the 'Ferrari of Master Data Solutions,' implying that while expensive, it is business-critical and, therefore, justified.
The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview.
I think the costs are reasonable for the kinds of features that Informatica Intelligent Data Management Cloud (IDMC) has.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
Informatica Intelligent Data Management Cloud (IDMC) can connect to pretty much any application, including Oracle Analytics and Power BI, and it works quite seamlessly.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
In on-premise, we call it EDC for metadata management, while in cloud-based technologies, it is known as the Metadata Command Center, which serves the same purpose as EDC concerning CDGC.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
Product | Market Share (%) |
---|---|
Informatica Intelligent Data Management Cloud (IDMC) | 3.6% |
Informatica PowerExchange | 1.1% |
Other | 95.3% |
Company Size | Count |
---|---|
Small Business | 42 |
Midsize Enterprise | 24 |
Large Enterprise | 134 |
Company Size | Count |
---|---|
Small Business | 8 |
Midsize Enterprise | 3 |
Large Enterprise | 12 |
Informatica Intelligent Data Management Cloud (IDMC) integrates data quality, governance, and integration with flexible architecture. It supports multiple domains and a data models repository, delivering AI-enhanced data management across cloud-native platforms.
IDMC provides seamless integration and governance capabilities that support diverse data environments. Its comprehensive suite includes customizable workflows, data profiling, and metadata management. AI features, a data marketplace, and performance scalability enhance data management. While its interface poses challenges, its robust matching and cloud-native integration facilities are essential for complex data ecosystems. Users employ IDMC for connecting systems, ensuring data quality, and supporting data compliance but seek better pre-built rules, services, and improved connectivity, especially with platforms like Salesforce. Licensing, cost, and added AI functionalities are areas for potential refinement.
What are the key features of IDMC?IDMC is implemented across industries for data integration, metadata management, and governance. Organizations use it to connect systems, migrate data to cloud environments, and maintain data quality. They manage master data and automate business processes, facilitating data lineage and ensuring compliance with privacy regulations.
Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.