IT Central Station is now PeerSpot: Here's why

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

Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)

How do you or your organization use this solution?

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

Thank you!

PeerSpot user
1313 Answers

reviewer1258245 - PeerSpot reviewer
Real User

I'm a technical manager and we provide technical services to our customers. We are partners with Oracle.

AshokSharma - PeerSpot reviewer
Top 20Real User

We use ODI for integration services from different systems, such as finance systems and online display systems. Additionally, we integrate it with the external partners with ODI. We use ODI in combination with the SFTP server.

Mohamed Ahmed Fouad - PeerSpot reviewer
Top 20Real User

We primarily use the solution for digital health and sometimes automation tasks.

Muhammad Arif Javed - PeerSpot reviewer
Real User

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.

Rüdiger KOch - PeerSpot reviewer
Real User

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

Muhammad Tahir - PeerSpot reviewer
Real 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.

Business677 - PeerSpot reviewer
Real 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.

David Barragan - PeerSpot reviewer

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.

it_user911514 - PeerSpot reviewer

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

Dava Wang(汪燊) - PeerSpot reviewer
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.

Alan Yves - PeerSpot reviewer

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.

Ricardo Giampaoli - PeerSpot reviewer
Top 5LeaderboardConsultant

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

Rodrigo Radtke De Souza - PeerSpot reviewer
Top 10Consultant

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.

Buyer's Guide
Oracle Data Integrator (ODI)
June 2022
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,336 professionals have used our research since 2012.