We performed a comparison between Actian Pervasive Data Integrator [EOL], Denodo, and Informatica PowerCenter based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"Denodo's best features are its performance, easy data transformation, and the job scheduler."
"It can support a number of data sources, and it can pull flat files, from cloud-based databases or from those on-premises. Denodo can pull from any data source and interface with the view. Then, we can publish the view."
"It is a go-to tool for data virtualization. The virtualization and data catalog are the features of why we chose Denodo."
"Access to numerous forums and internet information."
"It is a very stable solution."
"Denodo is very stable."
"The most valuable aspects of this solution are the short time frame in which you can deliver and connect."
"Denodo makes it easy to export data as a service or data link to other services."
"The most valuable features are the metadata repository and the data warehouse application console."
"The ability to scale through partitions helped us to improve the performance."
"The setup is very simple."
"It is an excellent ETL tool."
"The technical support for Informatica PowerCenter is good."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The setup is straightforward."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"Sometimes, Windows-related functions do not work properly in Denodo. The analytic functions in SQL do not work properly."
"The solution is slow when there are many virtualization layers."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"The git configuration really should be improved."
"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."
"We can't scale it to meet digital requirements."
"Denodo can improve usage management-related aspects. If you deal with the mini views, it gets stuck. The performance is very slow when we go with a large number of views and high volume."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The licensing is difficult."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"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."
Earn 20 points
