Sample Code for Smart Import and Export Using the ODI 12c SDK (Doc ID 2925308.1)

Last updated on NOVEMBER 28, 2023

Applies to:

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

Goal

This article provides two Java samples which show how to use the Oracle Data Integrator (ODI) SDK in a standalone program to perform a Smart Export and Smart Import of ODI objects.

For Oracle Data Integrator 11g, see the following two documents:

Document 1463168.1 - Sample Code to Illustrate the ODI Smart Export SDK
Document 1463366.1 - Sample Code to Illustrate the ODI Smart Import SDK

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

Note: The samples provided in this article are provided "as-is" and are not supported nor tested by Oracle. Oracle disclaims all express and implied warranties, including, the implied warranties of merchantability or fitness for a particular use. Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in connection with the use of this material.

It is out of the scope of Support to review, create, or make suggestions on custom code.
See the "Technical Support Policies" section of Document 166650.1 - Working Effectively With Oracle Support - Best Practices

Requirements

The following scripts require:

Java 1.8.0 Update 211 or higher.
ODI SDK Libraries located in the directory: <ODI_HOME>/odi/sdk/lib
JavaX Mangement Library located in the directory: <ODI_HOME>/oracle_common/modules/javax.management.j2ee.jar
XML Parser Library located in the directory: <ODI_HOME>/oracle_common/modules/oracle.xdk
JDBC Driver to connect to the Master and Work repositories. For example, Oracle Database would use the ojdbc8.jar driver library.

Configuring

The scripts will need to be customized to your environment.

The connection information to the ODI Master and Work Repository which the data will be exported or imported.
A directory and filename to save the Smart Export data.
A directory and filename to load the Smart Import data.
The helper OS scripts will also need Java settings customized.

The compile scripts are provided for Linux environments. If you are using Windows, you will need to convert them over.

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.