My Oracle Support Banner

Sample Code to Export Mappings that Match a Criteria Using the ODI 12c SDK and Groovy (Doc ID 2250484.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.


This is a sample Groovy script for exporting Oracle Data Integrator (ODI) Mappings using the SDK (ODI Java API).

Only the Mappings that match the following criteria will be exported:

The Mapping will be exported on disk into a Folder identical to the one that contains the Mapping in ODI Studio > Designer.
Folder on disk will be automatically created if needed.

The export file name will match the one of Mapping in ODI Studio, to which suffix "MAP_" has been added to help identifying the type of exported object.

One log file will contain all the successfully exported Mappings.
Another log file will be created for the Mappings that could not be exported.
A third log will contain the list of Mappings (in the Project) not having a Scenario.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.