Oracle Data Integrator (ODI) Valuable Features

Paolo Borghi
Oracle Business Intelligence Consultant at a tech consulting company with 51-200 employees
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. View full review »
Ricardo Giampaoli
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at a consultancy with 1,001-5,000 employees
It's the best tool for data integration. It can do anything you want, but the only downside is that you need to know what you are doing. You can take 10 times longer to do the same thing if you don't know how to use the tool. You have to know how to change the KM, how to use the dynamic coding, how to create dynamic models, and so on. In a lot of places, I see people using ODI wrongly, but the good thing about the tool is that isn't hard to fix common mistakes. With this you can improve performance, and in some cases, more than 10 times. View full review »
Alan Yves
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
There are several very important features that we use daily. * All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration. * ODI is really powerful for BI projects with traditional star-schema loads. For example, we integrated Salesforce to an Oracle data warehouse with it.ODI is a platform agnostic, you may have any data source and any target to integrate and ODI will enable you to connect. * It facilitates real-time data replication from Microsoft SQL Server to an operational database sitting on Oracle Database. * It provides for legacy systems integration. It integrates any SQL server database. View full review »
Jose Ann Brown
Director - Special Projects at Sandals Resorts International
The user interface for the data integrator tool is probably the most valuable piece. I'm a relatively newcomer to the ODI. We opted to use ODI instead of Informatica. Relatively, I do not have a lot experience with a lot of VARs, but I've been able to understand a lot more about the direction Oracle is heading through the tool. It was very intuitive. It helps to have a good background in data manipulation, but it's very intuitive and has given a good appreciation of what the tool can do. View full review »
Gurcan Orhan
Data Quality Software Development Manager at Yapı Kredi Bank
Flexibility, ease of customization, extensive features, ease of deployment, and the ability to access to all kinds of different source system technologies. No need for extra hardware for transformation step. Easy to learn & develop. Now, ODI has Cloud Service which you can deploy your repositories to Oracle Data Integrator Cloud Service for you to use both on prem, Big Data and cloud environments. Oracle Data Integrator (ODI) can support any type of databases that has a jdbc driver in a native way. I have accessed and retrieve data from an Ingress database. Big data connectors are implemented to ODI 11.1.1.7 (out-of-the-box) and upper version that support many well-known Big Data architecture. Knowledge Module architecture helps you to build your data integration activities with less effort. You can switch to source, staging area or target to improve your querying performance. If you have to do a join from different source systems, you can decide which data to move to where and figure out the place for best output. Variables can help you to perform loops and conditional statements in packages for helping ETL View full review »
it_user521922
Database Administrator at Tarrant County College
The most valuable feature is being able to schedule the jobs, especially when they're multi-step. View full review »
it_user521808
Development Manager
It is an ETL tool, which does the extract, transform, and load. View full review »
Jérôme Françoisse
Consultant - Oracle ACE with 51-200 employees
The EL-T approach that will first load into the target dataserver before doing the transfer is a great architecture improvement compared to standard ETL tools that use a staging area and usually process the data in Java. With ODI, almost all the job is pushed down on the underlying technology, for instance the Oracle database or the Spark server. 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 is really the tool for any kind of integration because it speaks the language of the technology we connect. We can work with RDBMS but also in Hadoop, cloud services, flat files, web services, etc. View full review »
John Kruebbe
Product Owner, Lead Entrepreneur and Chief Technology Officer(CTO) at a think tank with 1-10 employees
It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases. Going forward, that is very important. View full review »
Aslam Pasha
Assistant Manager at a integrator with 501-1,000 employees
I have found most of the Oracle Fusion middleware and hardware to be valuable. View full review »
Dava Wang(汪燊)
BI developer at lvmama.com
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. View full review »
RenéDe Vleeschauwer
Owner at a tech vendor with 11-50 employees
ODI is a very accessible tool, especially since the mapping functionality has been added. View full review »
it_user515439
User at a insurance company with 10,001+ employees
Provides us with a relational database. View full review »
Jill Corcoran
User
I found nothing overly amazing about this tool, although I appreciate its ability to easily load slowly changing dimensions. View full review »

Sign Up with Email