We performed a comparison between Denodo, Informatica PowerCenter, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."In general, it's good for us to make tests so we can scout the data."
"Denodo is lightweight in terms of how it leads you to combine your discrete data systems at one spot."
"The data abstraction is the most valuable feature."
"The most valuable feature is Data Catalogs."
"Overall, the product works quite well and has a good set of features."
"Data mining is one of the valuable features. We're able to connect all of the data sources with the installed driver, so that is a good advantage in Denodo. Being able to join the tables and view them is also valuable."
"Access to numerous forums and internet information."
"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 has a Data Catalog that uses the Model repository."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"It has very good monitoring and process monitoring."
"It has good standard features for ETL development."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"The most valuable features are the metadata repository and the data warehouse application console."
"In the end, you have structured, proper data for use in an integrated BI solution."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The most valuable feature is Data movement."
"It's completely user-friendly."
"The most valuable feature that we use is the Knowledge Modules."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"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."
"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."
"The solution is slow when there are many virtualization layers."
"Lacks integrations with AWS, GCP and the like."
"The dropdown menus feel antiquated to me, and the administrative portals need improvement."
"The solution should have its own acceleration technology."
"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."
"The feature that you have to connect on LDAP needs improvement."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"I would like to see an improvement in the digital adoption."
"The pricing could be improved."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"The UI is a little outdated."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"We used a third party to do the implementation of ODI."
"The initial setup is a bit complex compared to other tools."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"If you have something like Cisco on top of it, you will have endless problems."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."