We performed a comparison between Oracle Data Integrator (ODI) 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 CAEM is very useful in its modularity and portability."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"It's completely user-friendly."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The initial setup is easy."
"It has the ability to easily load slowly changing dimensions."
"Data transformations and rollups are easy to accomplish."
"It has a built-in automatic scheduling environment."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"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."
"Naturally produces a way to easily debug your DW data solutions."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"I like the data vault implementations."
"I found the initial setup very easy."
"If you have something like Cisco on top of it, you will have endless problems."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"The initial setup is a bit complex compared to other tools."
"Reverse engineering is complicated and challenging to manage."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The performance of the user interface is in need of improvement."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Customization could be better."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Improve the object renaming ability (it works, but it could be more automated)."
"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."
Earn 20 points
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while WhereScape RED is ranked 48th in Data Integration. Oracle Data Integrator (ODI) is rated 8.2, while WhereScape RED is rated 8.2. The top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". On the other hand, the top reviewer of WhereScape RED writes "Quick to set up, flexible, and stable". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate, whereas WhereScape RED is most compared with Azure Data Factory, SSIS, Informatica PowerCenter and Matillion ETL.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.