We performed a comparison between Oracle Data Integrator (ODI) and WhereScape RED based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The CAEM is very useful in its modularity and portability."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Besides loading data, we do most of our transformations in ODI."
"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."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"Data transformations and rollups are easy to accomplish."
"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."
"Support is absolutely excellent, efficient, and timely."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"It has a built-in automatic scheduling environment."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"I found the initial setup very easy."
"The performance of the user interface is in need of improvement."
"Technical Support could be better."
"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 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."
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"We used a third party to do the implementation of ODI."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The initial setup is complex, especially if you also have to install a console."
"Improve the object renaming ability (it works, but it could be more automated)."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Technical support isn't the best."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Customization could be better."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
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, Informatica PowerCenter, SSIS, Azure Data Factory and Oracle GoldenGate, whereas WhereScape RED is most compared with Azure Data Factory, Informatica PowerCenter, SSIS, Matillion ETL and Denodo. See our Oracle Data Integrator (ODI) vs. WhereScape RED report.
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.