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."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 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 solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"It has the ability to easily load slowly changing dimensions."
"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."
"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 Data Redaction feature is easy to use and we are quite happy with it."
"We find technical support to be very responsive. They briefly describe everything on phone and we handle the operations. I'd say we've been more than satisfied with their level of service. They're quite helpful and knowledgeable."
"Compared to other databases, Oracle Database is very simple to manage in terms of the database itself."
"I like the design of the database because it works well. I also like the stability of the solution."
"The solution is scalable."
"I love the performance tuning feature of Oracle Database because it provides hints and indexing, which are very valuable. Some of its other valuable features are its rack, record key vaults, and backup compression."
"It is very fast. The response times are very fast."
"Stability and availability are the features I like the most in the solution."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"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."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"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."
"The quality of technical support could be better. They could respond faster."
"They should be putting more emphasis on the Windows platform. Usually, they run very well on the Linux platform, however, their performance on Windows is a little bit lower quality."
"There are actually a lot more features for the Oracle Databases. It is almost impossible for a single person to know and give all the features."
"Digital support of the product could be improved."
"As of now, Oracle is branded to Oracle only, the option of migrating to other databases is not available."
"It would be better if the administrator part could be simplified. At the moment, we need specialized skills for managing or administering Oracle Database. If that is simplified, my juniors or basic database engineers could use it. Right now, we need specific administrative skills to manage the Oracle Server."
"There is a new version of Oracle and Database Firewall, version 20, for which I would be interested in receiving training."
"Probably about 80% of their online documentation is useless. When you go to the Oracle documentation, you have to plow through page after page of stuff to get to anything that looks anything like an example of what it is that you might actually do. There are lots of other people who have filled that gap, and there are also websites where you can easily find the answers to most of your questions."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Oracle Database is ranked 2nd in Relational Databases Tools with 279 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.