Informatica PowerExchange and Denodo compete in the data integration and virtualization market. Informatica PowerExchange is more favored for its transformation and real-time data capabilities, while Denodo is preferred for data virtualization and semantic integration.
Features: Informatica PowerExchange offers robust data transformation and integration capabilities with features like pushdown optimization, native connectors, and real-time capabilities. It is highly valued in scenarios that require continuous data loading and transformation. Denodo focuses on data virtualization, offering data catalogs and semantic layers that facilitate easy integration with multiple data sources without needing data replication.
Room for Improvement: Informatica PowerExchange needs enhanced cloud integration, a more user-friendly interface, and improved technical support. There are also concerns about pricing and the need for better real-time data handling. Denodo users seek better data catalog functionality, more integration support, and improved documentation and training resources. Performance optimization with large data volumes is another area for Denodo’s improvement.
Ease of Deployment and Customer Service: Informatica PowerExchange is primarily on-premises with some cloud capabilities, receiving mixed customer service feedback. Denodo offers more flexible deployment options including on-premises and cloud environments, but requires improvements in support responsiveness and availability.
Pricing and ROI: Informatica PowerExchange has a complex pricing structure perceived as expensive, though it offers significant ROI through streamlined data processes. Denodo is considered costly, influenced by licensing based on CPU usage, but offers substantial ROI due to its comprehensive feature set despite higher costs.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
Denodo's customer support team is very competent and responsive.
The documentation is very thorough.
They are proactive in conducting webinars and connecting with customers.
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.
While the solution scales well on a single machine, I have doubts about its scalability when deployed as part of a Java component cluster.
Its complexity in configuring and the requirement to install different connectors for different sources affects its scalability.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
The system has dependencies on other environments, like JVM, which can affect its performance.
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
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.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
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.
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
Its catalog is useful for data governance and helps document information for databases and fields.
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.
Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.
The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.
Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.
Denodo Features
At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:
Denodo Benefits
Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:
Reviews from Real Users
Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.
Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.
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.
