We performed a comparison between Oracle Data Integrator (ODI), Oracle GoldenGate, and WhereScape RED based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It has the ability to easily load slowly changing dimensions."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"It is an ETL tool, which does the extract, transform, and load."
"It's completely user-friendly."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"It is quite scalable."
"GoldenGate enables us to merge and transform data from various sources in real time. It's a powerful tool that can read and load most data sources."
"What I like most about Oracle GoldenGate is that it supports cross-platform migrations. For example, Oracle GoldenGate could pump data from one type of system to another such as the data from Oracle DB to SQL Db2."
"This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation."
"For small databases, GoldenGate handles the migration well."
"They've recently improved the ease of implementation."
"The solution's existing SaaS platform for data integration gives us an edge."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"Naturally produces a way to easily debug your DW data solutions."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"Support is absolutely excellent, efficient, and timely."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"It has a built-in automatic scheduling environment."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"The tool supports multiple target update methods."
"The most valuable feature is the metadata generated code."
"The performance of the user interface is in need of improvement."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"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."
"Technical Support could be better."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"If you have something like Cisco on top of it, you will have endless problems."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting."
"In some cases, expectations were not met, especially when specific tables were expected to be disabled, and changes were anticipated in the target environment. We had to take backups from the source and refresh the address to address this."
"We struggle with memory. It's limited. However, it may be because of our unique business case and how we use it that it's limiting for us."
"Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."
"The GoldenGate license is very costly."
"The solution, in general, should be easier to use, with less need to perform workarounds within the system."
"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."
"It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
Earn 20 points