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."The most valuable feature that we use is the Knowledge Modules."
"It's completely user-friendly."
"The scalability is great. It's one of the reasons we chose the solution."
"The CAEM is very useful in its modularity and portability."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"The initial setup is easy."
"It has the ability to easily load slowly changing dimensions."
"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."
"CDC is the most valuable feature."
"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."
"The solution's existing SaaS platform for data integration gives us an edge."
"You can use Oracle GoldenGate as a DR for your system."
"The CDC feature is interesting."
"The replication of the data table is one of the best features."
"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
"It has a built-in automatic scheduling environment."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"I found the initial setup very easy."
"The tool supports multiple target update methods."
"Naturally produces a way to easily debug your DW data solutions."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"Technical Support could be better."
"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."
"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."
"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."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
"Microservices Architecture is not user-friendly."
"The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."
"The solution's performance needs improvement."
"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
"The solution costs a lot."
"The process of transforming the data between two different databases is inefficient and needs to be improved."
"I find the user interface to be difficult for non-technical people."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Improve the object renaming ability (it works, but it could be more automated)."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Technical support isn't the best."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
Earn 20 points