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 significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"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's most valuable features are it utilizes the database engine and is very lightweight."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"Besides loading data, we do most of our transformations in ODI."
"The out-of-box integration between Oracle and SAP is really beneficial"
"The OIC is very good."
"The most important part would be the use of connectors. The significant number of cloud connectors available for active integration is its value."
"Technical support responds quickly."
"I particularly like the drag-and-drop feature for designing integrations and processes."
"It's very easy to get started on the solution. It's also easy to maintain, scale, and integrate according to cost factors."
"Oracle Integration Cloud Service is a really good product and the ROI is very good with it. It lowers development time. A development cycle that may have taken a year without Oracle Integration Cloud Service can drop down to three or four months with it."
"Oracle Integration Cloud Service integrates well and is user-friendly. If you are not a developer or ops engineer you can still use the solution with ease. You do not need to have developers' knowledge, you can easily adapt and learn quickly to integrate the services. They have good documentation."
"I like the data vault implementations."
"Data transformations and rollups are easy to accomplish."
"The most valuable feature is the metadata generated code."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"Naturally produces a way to easily debug your DW data solutions."
"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."
"The tool supports multiple target update methods."
"Support is absolutely excellent, efficient, and timely."
"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."
"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 you have something like Cisco on top of it, you will have endless problems."
"The initial setup is complex, especially if you also have to install a console."
"The price needs to be lowered. It's too expensive."
"The solution lacks some functions and features."
"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."
"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."
"The bulk processing needs improvement."
"They need to make tools framework available for implementation partners"
"The support and resources were lacking — they weren't there."
"It has lengthy documentation, making the process of building applications more time-consuming."
"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."
"If an inbound file is larger than one GB, it cannot be transformed within Oracle."
"While most of the adapters are available through Oracle Integration Cloud Services, they do not have a lot of features. I would like to see some enrichment in this area and for the solution to go deeper into the applications and upgrade the adapters."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
"Technical support isn't the best."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Customization could be better."
"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)."
More Oracle Integration Cloud Service Pricing and Cost Advice →
Earn 20 points