My Oracle Support Banner

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


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:
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




 The following scripts require:




The scripts will need to be customized to your environment.

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



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.