Oracle Data Integrator (ODI) Primary Use Case

Ricardo Giampaoli
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Very large and complexes environments implementation, 10000+ users with 24x7 global operation and multiple EPM tools working in sync. View full review »
Alan Yves
Big Data / Business Intelligence / Datawarehousing at DWgrain (Client Health BIS)
Several projects benefited from the ODI data integration capabilities such as Loading OLTP system's data to Data warehouses, pulling data from cloud-based databases and loading to on-premises DW, for example: extracting data from a SQL server which is based on Azure infrastructure. Perform data integration from cloud to cloud. Data migration between OLTP systems. Event-based integration such SOA, for example, BPEL performed calls of ODI scenarios based on EBS events. View full review »
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
We have been using Oracle Data Integrator for populating Financial Services Data Warehouse. Data extraction is done into a staging area from different source systems and then this data is validated and certain quality checks have been performed here. We used Oracle Data Integrator data quality checks builtin capability to perform these different data quality checks. Then data is consolidated and transformed into the staging area and finally gets landed into the data warehouse. I also used this for generating data hand-offs for other applications. View full review »
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
441,726 professionals have used our research since 2012.
Rodrigo Radtke De Souza
Solutions Architect at a tech consulting company with 51-200 employees
We mainly use ODI to integrate all of our EPM applications, which includes Essbase ASO/BSO cubes, Hyperion Planning, DRM and HFM applications. Also it is used to manage a custom data warehouse developed in Oracle DB which is used as source for OBIEE reporting. View full review »
Muhammad Tahir
Assistant Manager - MIS Analyst at TCS Private Limited
Our primary use for this solution is a data integration and merging tool. It easily connects to many databases like MySql, SQL Server, etc. It's completely user-friendly. We can easily manage packages, ETL, and Procedures. View full review »
Business677
Business Analyst at Paunaste OÜ
To have a common ETL tool in the DW team, start a common way of ETL development, set up a process registry, and daily process flow. View full review »
David Barragan
Principal Owner at New Frontier Professionals LLC
Multiple data sources: "Most" of them, Oracle databases (some MS SQL, some Sybase, lots of files and some web services). Because the environment was overwhelmingly Oracle, ODI (we started from OWB) was a much better and cost-effective solution for us than Informatica. View full review »
Rüdiger KOch
Team Leader Development at DB Systel
We use this solution for Data Integration in Data warehouse projects. View full review »
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
441,726 professionals have used our research since 2012.