We performed a comparison between Oracle Data Integrator (ODI), SAP Replication Server, 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."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."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Oracle provides great documentation."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"It's completely user-friendly."
"The installation of the client ODI Studio is easy."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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."
"SAP is renovating different things. We are using external tools to connect as of now. It is going well, and now the new generation integration platforms are going to be pretty easy."
"We can customize any workflow and we also like the business domain modeling that can be done."
"It's pretty good at handling replication, even under high load. It also provides cross-database replication, for example, from Sybase to Oracle."
"It speeds up the performance in terms of how fast you are able to access the data, look at it, get it reported to you, and send it to somebody. It also reduces the amount of storage."
"SAP Replication Server is an application that I consider to be a robust system. It has proven to be highly reliable in my experience."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"I found the initial setup very easy."
"Data transformations and rollups are easy to accomplish."
"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."
"The most valuable feature is the metadata generated code."
"The tool supports multiple target update methods."
"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."
"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."
"The initial setup is a bit complex compared to other tools."
"If you have something like Cisco on top of it, you will have endless problems."
"The price needs to be lowered. It's too expensive."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The performance of the user interface is in need of improvement."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"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."
"There is room for improvement in terms of pricing and faster support."
"If someone wants to replicate their data from Sybase to a newer technology for data warehousing or other purposes, it would be better if they supported those."
"The private solution is expensive. If you're in a situation where you're paying IBM or AWS or somebody just to host you specifically, you're paying people to run it and you're taking care of all the upgrades."
"Improvement is a never ending story, and HANA is doing some improvements. We are able to adopt that, and we have to do it by integration with HANA. They are very major changes that we need to see."
"I would like to see it become mobile-friendly."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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."
"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)."
"Customization could be better."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Technical support isn't the best."
Earn 20 points