We performed a comparison between Oracle Data Integrator (ODI), Oracle Integration Cloud Service, 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 best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"Besides loading data, we do most of our transformations in ODI."
"The product has an ELT approach."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"OIC's accuracy is quite good."
"The most valuable features of this solution are the SFTP adapters, file adapters, and risk adapters, that we use in everyday projects."
"The Oracle integration tool is the most comfortable tool for using those Oracle products."
"The lack of features in something like Oracle Integration Cloud leaves some room for leads implementation partners like us"
"Provides various ways to secure services as well as providing extensive support."
"The initial setup of Oracle Integration Cloud Service was easy."
"The most valuable feature is the ease of customization."
"The OIC is very good."
"Naturally produces a way to easily debug your DW data solutions."
"I found the initial setup very easy."
"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."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"The tool supports multiple target update methods."
"I like the data vault implementations."
"Support is absolutely excellent, efficient, and timely."
"Data transformations and rollups are easy to accomplish."
"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."
"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."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"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."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"We used a third party to do the implementation of ODI."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"In designer mode, sometimes the browser closure or other unknown issues can cause strange behavior, which requires a restart."
"The support and resources were lacking — they weren't there."
"It would be helpful if there were more tutorials or documentation to learn about Oracle Integration Cloud Service."
"Oracle-based automation blueprints for the majority of the integrations would be helpful to have in a future release."
"Dealing with the large file size has occasionally been a challenge."
"Oracle Integration Cloud Service can improve the downloading and uploading of files. I've submitted this issue to the Oracle Idea Labs. The issue is from the front end of Oracle Integration Cloud, we cannot download or upload a file directly or drag and drop it."
"Our client was quite concerned about the cost, which is something that could be reduced."
"Make it more similar to the on-premises features. For example, if you can edit the code directly rather than just dragging and dropping, or if you can edit the examples by going into the background, and one-click migration, I'd like to see included in the next release."
"Customization could be better."
"Improve the object renaming ability (it works, but it could be more automated)."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
More Oracle Integration Cloud Service Pricing and Cost Advice →
Earn 20 points