We performed a comparison between Oracle Data Integrator Cloud Service and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"Having a single vendor supporting the entire suite of applications."
"It's on the cloud, so it's scalable and quite easy to work with."
"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"It has the ability to easily load slowly changing dimensions."
"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 like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The initial setup is easy."
"The installation of the client ODI Studio is easy."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"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."
"I've found technical support not very effective. They should work to improve their services."
"The pricing could be more competitive."
"Bulk uploading can be a problem when you hit the upper limit."
"I would like to see different cloud adapters or connectors in case of integration. When you have Oracle to Oracle, they are good. They have really good connectors, but if it is a different ERP, like Obsidian, that is where they are faced with problems in OIC."
"This is an expensive solution compared to other products on the market."
"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"We used a third party to do the implementation of ODI."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"The initial setup is complex, especially if you also have to install a console."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"The solution lacks some functions and features."
"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."
More Oracle Data Integrator Cloud Service Pricing and Cost Advice →
Oracle Data Integrator Cloud Service is ranked 20th in Cloud Data Integration with 7 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Oracle Data Integrator Cloud Service is rated 8.0, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Oracle Data Integrator Cloud Service writes "A well-established product that meets all our specifications in terms of usability". On the other hand, 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". Oracle Data Integrator Cloud Service is most compared with IBM InfoSphere DataStage, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate. See our Oracle Data Integrator (ODI) vs. Oracle Data Integrator Cloud Service report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.