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 12.2.1.0.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Goal

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:

A given Project will be explored for Mappings that have a Scenario.
Those Mappings will then be exported, using legacy export mode (not smart export).

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.

Solution

	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.

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

Applies to:

Goal

Solution

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

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