2016-04-14T06:40:00Z

What is your primary use case for Oracle Data Integrator (ODI)?


How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

Guest
99 Answers

author avatar
Real User

We use this solution for Data Integration in Data warehouse projects.

2019-07-12T20:52:00Z
author avatar
Top 20Real User

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.

2019-05-05T21:16:00Z
author avatar
Top 5Real User

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.

2019-01-24T16:35:00Z
author avatar
User

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.

2018-11-25T02:07:00Z
author avatar
User

High volume batch loads to move data from transactional systems into the decision support warehouse.

2018-08-02T16:51:00Z
author avatar
Real User

We use ODI to integrate data from the OLTP database to the data warehouse. The source database systems including Oracle, MySQL, flat files... Our business background is OTA and the total data is about 100T.

2018-03-01T08:21:00Z
author avatar
Top 5Consultant

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.

2016-05-04T06:03:00Z
author avatar
Top 5LeaderboardConsultant

Very large and complexes environments implementation, 10000+ users with 24x7 global operation and multiple EPM tools working in sync.

2016-05-01T11:30:00Z
author avatar
Consultant

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.

2016-04-14T06:40:00Z
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.