We performed a comparison between Denodo and Informatica PowerExchange based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"In general, it's good for us to make tests so we can scout the data."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"It allows a lot of traceability and you can decide what data you want to collect"
"While we may not be using all the features of Denodo at this time, we have found the data virtualization features to be very useful in helping us connect our data sources together, bringing all our data into one platform."
"One thing that we have noticed is that when you have a BI tool, you end up building a lot of the logic in the BI tool, but as a company, every company wants to be tool agnostic because today, you could be in the Qlik Sense, and tomorrow, you may decide to go with Tableau or something else that is there. If you have put a lot of logic within the tool, transitioning or moving away from one BI tool to another tool becomes a very intensive process. By keeping the logic in Denodo, you can move to any tool."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"It is easy to integrate the solution with other tools."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"The user interface and user experience are perfectly all right."
"The product's initial setup phase was not complex. The tool is easy to install onto any of the servers, and you can integrate it."
"The scalability is excellent."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems."
"The most valuable feature is connectivity to data sources."
"The data catalog certainly has room for improvement. It is functional but we look forward to development. We are in constant contact with Denodo and they are fully aware of our needs."
"I would like it if we could pull the data model or export the data model because Denodo has, based on how you build, something called associations. The data model gets very confusing when you go look at it. It depends on how you define it, but it's really huge. I wish there was a way to export it into Visio. It could be that they already have a way to do it, and I don't know, but it would be much easier for the architects and even for the developers to look at it than scrunching it into the screen and expanding every small portion of it. If there was an easy way to export the Denodo model into another modeling tool and view it, it would be great."
"Documentation needs to be improved"
"The support is not the best and should be improved."
"I would like to see a proper way to avoid killing the sourcing systems."
"There have been some issues when you are at a table. Currently, Denodo exports data sets for a tabular model. When you are finished modeling your database or data warehouse they export a link to be used in Tableau. They should support other tools like Power BI."
"Tasks such as conversion of a date format or conversion of a number format that can be done in a very easy way in different languages, like SQL or Oracle, are not so easy to do in Denodo. For example, if you want to convert a date from one format to another, in Oracle it's pretty easy; in Denodo, however, it requires so many lines of code. Simple things that can be done very quickly in other database languages require more lines of code in Denodo."
"I would like to see a connectivity option with third-party apps, for example, JDBC, and ODBC drivers. Currently, we need to install it separately from the Denodo side and then connect it."
"Technical support can be improved with respect to delays in ticket response time."
"The product is not suitable for application integration."
"The connectivity with T24 core banking could be improved."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"I would like the stability to improve."
"Should diversify more, maybe with a reporting and visualization utility,"
"I would like to have easier integration with cloud platforms."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
Denodo is ranked 12th in Data Integration with 29 reviews while Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews. Denodo is rated 7.8, while Informatica PowerExchange is rated 7.8. The top reviewer of Denodo writes "Saves our underwriters' time with data virtualization, but could provide more learning resources". On the other hand, the top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". Denodo is most compared with Azure Data Factory, AWS Glue, Delphix, Mule Anypoint Platform and Informatica PowerCenter, whereas Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Azure Data Factory, SSIS and Qlik Replicate. See our Denodo vs. Informatica PowerExchange report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
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.