Oracle Data Integrator (ODI) Valuable Features

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 »
Rodrigo Radtke De Souza
Solutions Architect at a tech consulting company with 51-200 employees
ODI has the ability to connect to virtually any technology out there. If it does not connect out-of-the-box, we can very easily add a new technology into it. This flexibility gives a tremendous developmental advantage to its users, which can use ODI as the official ETL tool for any kind of integration project. Its Knowledge Modules (KMs) may abstract the “how” portion of integrations, allowing the users to focus on the “what” that needs to be done. It can be easily used by either young ETL developers or expert professionals. For resumes, the ease of use for young professionals and its great development flexibility for expert professionals make it a great product to be used for every ETL project out there. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: October 2019.
372,185 professionals have used our research since 2012.
it_user521808
Development Manager
It is an ETL tool, which does the extract, transform, and load. 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 »
Muhammad Tahir
Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees
We can easily create ETL processes and schedules. We can check logs on a daily basis. It handles multiple routines very smartly. View full review »
Dava Wang(汪燊)
Data engineer at realestate.pingan.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 »
Business677
Business Analyst at Paunaste OÜ
* Reusing existing ETL development pattern in the next similar tasks. * It's flexible to add new common procedures. * Knowledge modules can be modified to fix small issues. 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 »
David Barragan
Principal Owner with 11-50 employees
Separate environments for dev, test and prod from one management facility. View full review »
Rüdiger KOch
Team Leader Development with self employed
The most valuable feature that we use is the Knowledge Modules. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: October 2019.
372,185 professionals have used our research since 2012.
Sign Up with Email