Try our new research platform with insights from 80,000+ expert users

Denodo vs Informatica PowerCenter vs Perforce Delphix comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Featured Reviews

Atanu Chatterjee - PeerSpot reviewer
Data virtualization and integration enabled while caching and scalability room for improvement
In terms of improvements for Denodo, regarding performance, in cases where there are multiple virtualizations—such as reading from one Denodo view that is virtualized, and from that view there's also virtualization, and another team is reading from that view—if multiple virtualizations happen with no caching in between, it becomes slow. This occurs because it is cascading; whenever at the top level someone is reading data, that request is getting cascaded to the nth level, causing issues, especially in cases such as Power BI reports. We need to consider implementing some persistent layer in between. The scaling process should improve because many things are getting automated. The scale-out part needs to be automated, though I am uncertain whether Denodo has already implemented that feature.
Deepak Shiv - PeerSpot reviewer
Provides multiple transformations in one toolset and helpful when extracting data from multiple sources
Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors. In addition, there are KB articles published by Informatica that are really helpful. So, error handling and the KB articles provided by Informatica are very helpful. Even if you face any issues or errors, we can usually resolve them. If the error cannot be solved with Informatica PowerCenter, we can raise a case with Informatica, and their support team will help us address that issue. If it cannot be solved with that particular version, they will consider it and try to solve it with the next patch or hotfix. AI Initiatives: Our company also has organizational AI or machine learning initiatives. However, Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool. It doesn't have a significant role in the field. It is just a small ETL on-premises tool. So basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud and Informatica Cloud), where their AI comes into the picture. But for Informatica PowerCenter, AI does not come into the picture at all.
Amit-Rastogi - PeerSpot reviewer
Handles large volumes of data with ease, but the self-service portal must be more user-friendly
My advice depends on an organization’s needs. If an organization has a large volume of data, Delphix is a good choice. It is robust and very efficient with large volumes of data and different kinds of databases. If someone is looking for a one-stop solution with all features and capabilities, they must consider a different tool. Overall, I rate the product a six or seven out of ten.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Denodo's capabilities offer a strong and intuitive solution for data access."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"The data catalog feature is valuable as it helps define data structures without storing data."
"The most valuable feature in Denodo is data virtualization."
"In PL/SQL, first you need to gather all the data and then start writing the file, but in Denodo you fetch the data and write the data simultaneously. So, for example, if you have 1 million or 2 million records, you don't have to wait to fetch all of the 2 million; you can keep on fetching and writing in the file simultaneously."
"It is a very stable solution."
"The ability to transfer data is very valuable."
"Access to numerous forums and internet information."
"I found the map links, work links, and workflows valuable. They are important features."
"Has a good visual tool for data mapping."
"The technical support for Informatica PowerCenter is good."
"Can manage a huge quantity of data and provide reliability."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"In the end, you have structured, proper data for use in an integrated BI solution."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"It is UI friendly and has all the advantages of an ETL tool."
"Data being available anytime is a life changer."
"The most valuable feature is VDB provisioning."
"The solution's most valuable feature is data cloning."
"The performance offered by the product, its price, and its ability to handle structured and unstructured data were good when compared to the other products in the market."
"The most valuable feature is creating virtual databases."
"It provides the ability to roll back to a point in time or roll forward without the assistance of a DBA."
"It is a stable solution."
"The most valuable aspect is the product is easy to manage, with a good dashboard. We can easily configure it on the front end and back end."
 

Cons

"The integration could use improvement, it's a lot of non-speed line processes that we have discovered, in the country. The configurations could use a lot more improvement."
"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."
"Documentation needs to be improved"
"Performance management could be improved."
"Monitoring event logs can be improved. In the older version, there was a monitoring schedule to get event reports and properly audit the reports. In the newer version, it is not there, and we have to manually configure data and audit events."
"Denodo's training documentation could be improved by providing more material. From an administrative standpoint, I've found that only Denodo websites provide the usual tutorials. It may be because it's a bit of a restricted tool, but it results in trouble with learning. Normally, I can find help and solutions from other sources, but I haven't been able to find any for Denodo. Other that, it's fine and it performs well. I only have six months of experience, so I can't accurately suggest improvements."
"They need to invest more in the optimization engine. It will be a fantastic tool for them to enhance automation and improve the GUI interface, especially for Integration, as some tools are still not fully integrated, such as Iceberg."
"The support is not the best and should be improved."
"The pricing could be improved."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"With all these no code/low code platforms, Informatica still forces us to use the ANSI format of SQL for joins, especially left outer join."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"We had stability issues, mostly with JVM size."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"The reputation of Informatica is that it is expensive."
"As a commercial model, it's very good. However, maybe it would be nice for Delphix to integrate with some other platforms."
"The solution's price needs improvement."
"Delphix is quite expensive."
"Delphix could be improved with better usability and an agentless option."
"This product should be extended and made to be a more comprehensive storage solution."
"When it comes to unstructured and structured data, if Delphix can comply with the requirements for most of the structured data, it would be good, especially if it can include the data scanning part."
"It would be good if any CI/CD and DevOps-aligned feature could be triggered through the DevOps pipeline."
"GUI could be improved."
 

Pricing and Cost Advice

"I don't know the actual cost, but it's tens of thousands of dollars per month."
"Talking with my manager and others, nobody has complained about the pricing so far which is a positive sign."
"The cost for Denodo is in line with other similar products."
"There is an express edition and a licensed enterprise edition."
"I am not super familiar with the pricing, but so far, it seems good. We have been happy. We haven't seen any problems. The only time we had to pay extra was during the upgrade. We didn't upgrade at the time they told us to upgrade, and we had to pay extra to keep the service. They had stopped the support for the older version and moved to the newer version. It was not their fault. It was our fault because we didn't get on board quickly."
"The licensing charges for this solution are payable annually."
"Denodo provides a lightweight 30-day free trial, but when we do courses on top of it, it costs $150 for each person."
"The licensing should be improved, as the cost per connector is quite expensive."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products. Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive."
"The licensing fees are paid on a yearly basis."
"Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support. If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it."
"We have a site license, but we do pay by the division."
"It's much more expensive, almost three times more expensive than most other solutions."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"The solution is in the middle price range compared to other solutions."
"The solution's pricing was reasonable and lower than one million."
"It is an expensive solution."
"The cost is $370K annually for the Delphix Masking Engine and Delphix Virtualization Engine."
"I rate the product price seven to eight on a scale of one to ten, where one is the low price, and ten is the high price."
"Delphix's pricing is affordable."
"The product is a little bit expensive."
"I would say the price is a little high but affordable for our needs."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
866,685 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Manufacturing Company
10%
Computer Software Company
8%
Government
7%
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
7%
Insurance Company
7%
Financial Services Firm
29%
Insurance Company
10%
Computer Software Company
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business13
Midsize Enterprise6
Large Enterprise19
By reviewers
Company SizeCount
Small Business15
Midsize Enterprise10
Large Enterprise71
By reviewers
Company SizeCount
Small Business9
Midsize Enterprise2
Large Enterprise11
 

Questions from the Community

Does Denodo provide useful data virtualization education? Is it useful to attend their training?
If you are a Denodo user, it makes sense to undergo their training. Different types of professionals can benefit fro...
In experience, what might Denodo be lacking or need improvement on?
I like Denodo a lot. It offers quick and easy web service deployment within minutes. There are not any flaws that I ...
Which industries can benefit from Denodo the most?
Denodo is suitable for pretty much all sectors that deal with: Big data Cloud solutions Data governance Logical data...
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stabil...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called ...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a...
What do you like most about Delphix?
The performance offered by the product, its price, and its ability to handle structured and unstructured data were go...
What is your experience regarding pricing and costs for Delphix?
The solution's pricing was reasonable and lower than one million.
What needs improvement with Delphix?
It would be good if any CI/CD and DevOps-aligned feature could be triggered through the DevOps pipeline. Right now, w...
 

Also Known As

No data available
PowerCenter
No data available
 

Overview

 

Sample Customers

Autodesk, VHA, AAA, Sumitomo Mitsui Trust Bank, Caterpillar, European Chemical Agency, Seagate, Nationwide, Time Warner Cable, Pantex, Inditex, BNSF Railways, Vodafone, CIT Group, Jazztel, Wolters Kluwer, Telefonica, TransAlta
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Alberta Blue Cross, Fastweb, SABMiller, California Insurance Guarantee Association (CIGA), Molina Healthcare, AT&T, Nike, Facebook, eBay, Comcast, IBM, HP, Intel, Avaya, BNP Paribas, P&B, Toyota, Walmart, Best Western, Directv, JPMorganChase, Verizon, Bank of the West, Fannie Mae
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration. Updated: August 2025.
866,685 professionals have used our research since 2012.