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 »
Rodrigo Radtke De Souza
Sr. Consultant - Software Development at a tech company with 10,001+ 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 »
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 »
Rein Adamson
User
* 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 »

Sign Up with Email