We performed a comparison between Oracle Data Integrator (ODI) and Oracle Database based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The most valuable feature that we use is the Knowledge Modules."
"It's scalable."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"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 initial setup is easy."
"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 CAEM is very useful in its modularity and portability."
"It is one of the most reliable database systems."
"There is a lot of functionality in Oracle Database. The reports and the GUI are good."
"The solution is very stable with the performance being very reliable."
"The stability has been good so far. It's reliable."
"The reliability is the solution's most valuable feature. We've had great success with the solution."
"The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful."
"Oracle Database is very stable. In terms of stability and performance, Oracle is super. On the database side, Oracle is number one in our tests."
"The interface of Oracle Database is very workable and easy to use."
"The resource management aspect of the solution could be improved."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"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."
"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."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"Upgrade is the most critical phase for the lifecycle of a database. In order to be sure that the migration succeeds, you need to be up-to-date. Therefore, regularly install the patchset and security updates."
"The initial setup could be easier."
"They need to work on non-relational data a bit more. If Oracle Database can support non-relational data streaming, it would be great."
"The documentation needs improvement because as it is now, providing support is a headache."
"Oracle Database could improve security to make the solution better in the future."
"The software really doesn't need any improvement, but the way they do the billing should be improved. They charge by all the chips on the server, whether you use them or not. If you have a server that has 64 chips on it and you use one chip, they charge you for 64, and that's a terrible business model."
"The monitoring of processes that are executing could be better. I find it very difficult to find processes that had been in a suspended state in order to stop them."
"The quality of technical support could be better. They could respond faster."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Oracle Database is ranked 2nd in Relational Databases Tools with 278 reviews. Oracle Data Integrator (ODI) is rated 8.2, while Oracle Database is rated 8.6. 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 Oracle Database writes "Supports a large volume of transactions compared to other databases". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Mule Anypoint Platform, whereas Oracle Database is most compared with SAP HANA, SQL Server, MariaDB, IBM Db2 Database and SingleStore.
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.