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."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 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 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."
"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."
"It has the ability to easily load slowly changing dimensions."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The technical support from Oracle is good and responsive. I used them for security updates and patches."
"Most of our customers have been using multitenant options. Advanced Compression and Advanced Security are the most valuable features in most customer environments."
"I like the design of the database because it works well. I also like the stability of the solution."
"Significant assistance in tuning both the migration process and the production database was provided by Oracle Consulting Services, which provided excellent and very professional advice."
"RDBMS with good performance and technical support. It's a scalable, stable, secure, and easy to implement solution that can be deployed both on cloud and on-premises."
"It is a reliable database warehouse solution that is transparent to the end user."
"The solution is easy to use. It also offers a Database Vault."
"It's extremely easy to use and the performance is great."
"The resource management aspect of the solution could be improved."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"We used a third party to do the implementation of ODI."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"It needs easier security."
"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."
"It should have flexible licensing across different platforms. It has got different licensing models for Intel Power and SPARC servers."
"There are plenty of options and features in this solution, but they are, somehow, not being used very well. Therefore, training and support should be increased and improved for this solution. They can make people aware of how to make proper use of their server so that people can optimize it because its cost is just too much. They can provide training on the policies and procedures to be used for archiving and all such things. There should be some kind of segregation in licensing. With a full license, all options should be available. There should also be a basic license with limited functionalities. This kind of basic license would be useful for us because we don't use most of the functionalities."
"Technical support and how they treat their customers need to be improved."
"The product's price can be lower since it is a bit of an expensive solution."
"It could be slightly more intuitive, but other than that, we really like it as a solution."
"The price should be lower."
"The high availability features are a little complex to set up and manage."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while Oracle Database is ranked 2nd in Relational Databases Tools with 282 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, Informatica PowerCenter, SSIS, Azure Data Factory and Matillion ETL, 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.