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."Denodo's best features are its performance, easy data transformation, and the job scheduler."
"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 easy to virtualize data using the solution."
"The most valuable features are query optimization and the single language independence from the sources we're using to catch data."
"This solution provides us with the ability to sync data, and make it available for anyone to use across the business."
"The logical data warehouse functionality is fantastic. It truly stands out. The ClearOptimizer and Virtual Cache are great features. They work together seamlessly to optimize performance."
"Denodo is very stable."
"Access to numerous forums and internet information."
"It has helped us monetize."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"Once you have learned Informatica, it is very easy to use."
"PowerCenter performs well during data transformation and optimization."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"The most valuable feature is Data movement."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"It is an ETL tool, which does the extract, transform, and load."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"Lacks integrations with AWS, GCP and the like."
"The support is not the best and should be improved."
"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."
"We would like this solution to be more universally user-friendly. At present it is really only aimed at IT specialists."
"We occasionally have some integration issues that we need to work through."
"We can't scale it to meet digital requirements."
"I would like to see a proper way to avoid killing the sourcing systems."
"There are a couple of areas that can be improved in Denodo. From a stability point of view, sometimes we see issues in the data management functionality. This only happens now and then, however, and usually takes place when we add in our own customization."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"I would like to see an improvement in the digital adoption."
"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."
"Its scalability can be improved. It is not scalable."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"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."
"The solution does not scale."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The initial setup is complex, especially if you also have to install a console."
"The solution lacks some functions and features."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"If you have something like Cisco on top of it, you will have endless problems."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"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."
"The stability of the software could be improved. Sometimes, the software just crashes. "