Sample Code for Smart Import and Export Using the ODI 12c SDK
(Doc ID 2925308.1)
Last updated on DECEMBER 06, 2024
Applies to:
Oracle Data Integrator - Version 12.2.1.4.0 and laterOracle 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:
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
- 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: 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
Throughout this note placeholders exist, like <ODI_HOME> and <SID> etc. Replace the placeholders, including the surrounding <>, with the actual values used in the environment before using any of the sample code.
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! |