Consulting services

The Challenge

Many organizations encounter significant challenges when migrating their Oracle Data Integrator (ODI) environments from earlier versions (ODI 10, ODI 11, ODI 12) to the latest release, ODI 14 (December 2024). Experience shows that standard upgrade procedures using the Oracle Upgrade Assistant (UA) alone may lead to complications. These issues often emerge during initial testing phases or, even more critically, in subsequent development activities.

In particular, ODI Mappings and Interfaces pose substantial difficulties due to structural changes introduced in recent ODI versions. These elements require careful handling to avoid long-term inefficiencies in your data integration workflows.

The Background:

• Many users are experiencing a great number of difficulties when updating from ODI11 to ODI12;

• The experience of D&T teams has shown that a simple upgrade from version of ODI to another can create various problems, not only while testing new upgraded objects, but also in their future development;

• Oracle Upgrade Assistant (UA) upgrades all of the objects in the ODI11 repository, but only for one of them, ODI Interfaces, it’s better to use our tool. ODI Mappings use a specific style that can create many difficulties when they need to be fixed or in cases of future deployments (normal operations in each data warehouse system).

We are focused on Oracle Data Integrator (ODI is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services), Oracle GoldenGate, Database Administration, Data Guard and RAC. Our service offerings include consulting services, education services, support services as well as product services. We are 100% committed to customer satisfaction and ensuring quality in all services that we deliver.

ODI Course Oracle Data Integrator 11g, 12c : Administration and Development

Duration: 5 days.

Classroom Training: Instructor led with hands on exercises.

Training: available on-demand.

Numbers: up to 8 people per training.

Attendees: Data Warehouse Administrators Experienced SQL Developers Data Modelers Business Analysts SOA Architects Database Administrators

Assuming no prior Oracle Data Integrator (ODI) knowledge, in this course you will get an in-depth overview of ODI. The course will include many practical exercises that will help to achieve the most effective learning of ODI.

With the release of ODI 12c, Oracle has also released its own converter, the OWB to ODI migration utility to facilitate the porting of all developments carried out on OWB to ODI.

It is a “command line” tool without any GUI or integrated environment.

One of the requirements to be able to carry out the migration is related to the versions of OWB: only 11gR2 versions are supported, specifically, it is only possible to migrate from OWB 11.2.0.3 or 11.2.0.4 OWB to ODI 12c.

Oracle GoldenGate Consulting and Support

We are an Oracle consulting partner focused on Oracle GoldenGate, ODI, Database Administration, Data Guard and RAC. Our service offerings include consulting services, education services, support services as well as product services. We are 100% committed to customer satisfaction and ensuring quality in all services that we deliver.

Oracle GoldenGate provides low-impact capture, routing, transformation and delivery of database transactions across heterogeneous environments in real-time.