Oracle Data Integration Sample Code


Unless explicitly identified as such, the sample code here is not certified or supported by Oracle; it is intended for educational or testing purposes only.

 

You must accept the License Agreement to download this sample code.
Accept License Agreement | Decline License Agreement
Name
Created/Modified
Description and Download
LKM Files to Oracle (External Table) 2011-07-08

Loads multiple files using Oracle external table. Also incorporates support for the external table preprocessor.

KM_LKM_Files_to_Oracle__EXTERNAL_TABLE_.xml

Community Knowledge Module: LKM File to Oracle (SQLLDR) with EBCDIC Option 2011-07-06

This LKM loads flat file data into Oracle by using the SQL*LOADER utility. The original LKM File to SQLLDR from ODI 11.1.1.3 was extended to include EBCDIC Data. Does not have the issues related to older versioned :code-sample ID S550: Community Knowledge Module: LKM EBCDIC File to Oracle (SQLLDR)

KM_LKM_File_to_Oracle__SQLLDR__with_EBCDIC_Option.xml

SQL IKM for Oracle Table Function 2011-07-05

Illustration of how to generate SQL components such as Oracle Table Functions from within ODI.

KM_SQL_TableFunction.xml

ODI KM: LKM SQL to Oracle (Bulk - External Table).xml 2011-06-08

Bulk loads data into Oracle - from any database

klm_lkm_SQLtoOracle_Bulk_ExtTable.zip

AIA 2.x Install Accelerator Scripts 2011-05-10

These scripts aim to accelerate and automate installation/configuration process of vanilla SOA suite, AIA Foundation Pack and certain set of PIPs (O2C, Comms PIPs, MDM PIPs) for clustered environment. This version has following updates : - various bug fixes - more flexible patch scripts - support for 10.1.3.5 MLR #2 - support for IPS2 version of Comms PIPs / MDM PIPs - support for Design to Release PIP

scripts_04142011.zip

AIA 2.x Installation Accelerator Scripts 2011-01-24

These scripts aim to accelerate and automate installation/configuration process of vanilla SOA suite, AIA Foundation Pack and certain set of PIPs (O2C, Comms PIPs, MDM PIPs) for clustered environment.

scripts01242011.zip

AIA 2.x Installation Accelerator Scripts 2011-01-24

These scripts aim to accelerate and automate installation/configuration process of vanilla SOA suite, AIA Foundation Pack and certain set of PIPs (O2C, Comms PIPs, MDM PIPs) for clustered environment.

scripts01242011_1.zip

AIA 2.x Installation Accelerator Scripts 2011-01-19

These scripts aim to accelerate and automate installation/configuration process of vanilla SOA suite, AIA Foundation Pack and certain set of PIPs for clustered environment.

scripts_12032010.zip

IKM File to File (Perl) integration with experimental Hadoop parallel processing 2010-11-30

High performance file to file processing Knowledge Module for Oracle Data Integrator that generates Perl code with the optional capability of leveraging Hadoop parallel processing framework to further increase performance / scalability.

IKMFiletoFileIntegrationExperimentalHadoopparallel.zip

IKM SQL as a Source 2010-11-17

Lets users build temporary interfaces that represent inline views or SQL as a source. An option on the IKM captures the query when applied to a temporary interface and the temporary interface is nested in another interface with the derived sub select property set.

IKMSQLasaSource.zip

Warehouse Builder Utility Exchange Downloads 2010-11-15

The collection of downloads described on the OWB Utility Exchange here: http://www.oracle.com/technetwork/developer-tools/warehouse/owbexchange-099994.html

WarehouseBldrUtilityExchangeDlds.zip

IKM SQL Control Append_BIG_DATA 2010-11-09

1.) Added an Option "USE_CREATE_TABLE_FOR_APPEND" to Fully Seed very large tables (over 200 GB), right upon the creation of a table. In Exadata, it is better to use a Create Select as statement, than an Insert into a I$ table and then a subsequent Insert into the target table, when seeding target data, for CDC with Golden Gate. Also Ensure that "CREATE_PARALLEL_HINT" is set. 2.) Added the ability to seed the Target table using a row limit. Set USE_ROW_LIMIT to true and a sample size for ROW_LIMIT. 3.) Defaulted OPTIMIZER_HINT to use parallelism e.g. /*+ parallel(table1,64) parallel(table2,64) */ 4.) Added alter session parallel statements

KM_IKM_SQL_Control_Append_BIG_DATA.xml

IKM Oracle Incremental Update (MERGE) For Exadata 2010-11-09

Added a detection strategy which was not included in the original KM. The Detection Strategies are NONE, MINUS, POST_FLOW, NOT EXISTS and a new one MERGE. The default MINUS was not performant on Exadata. Use NOT EXISTS instead. If no Staging is required, use MERGE. When MERGE is used, Flow Control must be set to false. Upon a Detection Strategy of Merge, no I$ tables will be created. Instead the Merge Statement will contain the entire source select. This is very performant on Exadata when the Source and Target are on the same database.

KM_IKM_Oracle_Incremental_Update__MERGE__for_Exadata.xml

Oracle Data Integrator 11g UDF Sample 2010-11-04

ODI developers seeking sql function portability will use the user defined functions (UDF) in their sql expressions.

odi_11g_udfsample.zip

Code Template LCT_RESTWS_TO_ORACLE.mdl 2010-10-22

Supports calling RESTful web services from inside an OWB code template mapping.

LCT_RESTWS_TO_ORACLE.zip

Metadata synchronization expert 2010-10-01

Expert to synchronize an object with its dependent usages. For example a table to the mappings that use it, or a pluggable mapping to the mappings that use it.

owb_11gR2_synchronize.mdl

OWB SQL Developer Reports 2010-10-01

The SQL Developer reports are primarily reports on the OWB runtime, there are some simple reports for the design and data quality, but the reports are mostly centered on the runtime; analysis of map/flow timings, audit details etc.

owb_sqldeveloper_reports.zip

Oracle Data Integrator 11gR1 Java API Code Samples Package 2010-08-19

This sample code package includes example code for performing the following using the Oracle Data Integrator API: - Connection and Authentication - Start and Restart Scenario - Get Session Status - Create Folders - Interface Consultation, Creation and Edition - Session Monitoring - KM import and find - Create Master and Work Repositories - Upgrade Master and Work Repositories - Create Agent and Context

odi_sdk_samples.zip

Community Knowledge Module: IKM SQL Incremental Update (row by row) 2010-06-24

- Integrates data in any AINSI-SQL92 compliant database target table in incremental update mode. - provide the ability to integrate data from a staging area to a target and be able to know precisely the state of each row processed

IKM_SQL_Incremental_Update_(row_by_row)_v5.zip

Community Knowledge Module: LKM SQL to SQL (row by row) 2010-06-24

Moves data from any generic JDBC SQL source to generic JDBC SQL target, row by row.

LKM_SQL_to_SQL_(row_by_row)_v3.zip

Community Knowledge Module: LKM VSAM to Oracle (JCL IDCAMS - SQLLDR) 2010-06-24

Loads data from an MVS source into Oracle.

LKM_VSAM_to_Oracle_(JCL_IDCAMS_-_SQLLDR)_v1.zip

Community Knowledge Module: LKM SQL to Oracle (CLOB) 2010-06-24

Loads BLOB and standard data from any SQL92 database to an Oracle target database.

LKM_SQL_to_Oracle_(CLOB)_v1.zip

Community Knowledge Module: LKM SQL to Oracle Lob 2010-06-24

Loads data from any ISO-92 database to any ISO-92 compliant target database. Specially modified for dealing with CLOB and BLOB values.

LKM_SQL_to_Oracle_Lob_v2.zip

Community Knowledge Module: LKM File to Oracle (SQLLDR)-Cyrillic 2010-06-24

This LKM loads flat file data into Oracle by using the SQL*LOADER utility.

LKM_File_to_Oracle_(SQLLDR)-Cyrillic_v1.zip

Community Knowledge Module: LKM EBCDIC File to Oracle (SQLLDR) 2010-06-24

This LKM loads flat file data into Oracle by using the SQL*LOADER utility. Call to SQL*LOADER is made and stdout and stderr are redirected into log files. A specific log file is created by SQL*LOADER. Oracle recommends looking at this file in case of error. Control Files (CTL), Log files (LOG), Discard Files (DSC) and Bad files (BAD) are placed in the work directory defined in the physical schema of the source file.

_LKM_EBCDIC_File_to_Oracle_(SQLLDR)_v1.zip

Community Knowledge Module: LKM DB2(MVS) to Oracle (JCL Unload - SQLLDR) 2010-06-24

Create and Exexute a JCL to download a table in a sequentilal file in MVS system - transfer a sequential file to a Agent machine using a FTP command. - Loads data from a DB2 to an Oracle Database using the SQL*LOADER utility

LKM_DB2(MVS)_to_Oracle_(JCL_Unload_-_SQLLDR)_v1.zip

Community Knowledge Module: LKM Attunity to SQL 2010-06-24

- This module reads selected data from the Attunity Stream staging area of Attunity Streams and writes the result into the target temporary table, which is created dynamically. - Loads data to any ISO-92 compliant target database.

LKM_Attunity_to_SQL_v3.zip

Community Knowledge Module: JKM Oracle 10g Consistent (Streams) 2010-06-18

- This JKM provides consistent journalizing procedures for Oracle tables. - This KM uses Oracle Streams to capture data changes on the source tables.

JKM_Oracle_10g_Consistent_(Streams)_v2.zip

IKM Teradata to Teradata (BTEQ) 2010-06-18

- Integration Knowledge Module - Integration from Teradata to Teradata using BTEQ. - Ability to use INSERT, UPSERT, UPDATE or DELETE BTEQ Scripts (specified with the OPERATION_MODE option)

IKM_Teradata_to_Teradata_(BTEQ)_v1.zip

Community Knowledge Module: IKM SQL to Oracle (SQLUnload-EXTTABLE) 2010-06-18

This KM is a simple/limited KM which is for use when transferring data from a single table in an MS SQL Server database direct to the same table (name, columns) in Oracle. the transfer is effected using BCP to take the data out of SQL Server, and Oracle's EXTERNAL TABLE functionality to get the data into the target table. No provision is made to select on Journalized data. No provision is made to join the source tables. It does not check to ensure that generated table or index names are within the limits of the technology.

IKM_SQL_to_Oracle_(SQLUnload-EXTTABLE)_v1.zip

Community Knowledge Module: IKM Postgres to File 2010-06-18

- Loads a file from a Postgres source - The file is populated in truncate / insert mode. - A flow table is created Target technology: FILE Source technology: POSTGRESSQL

IKM_PostGre_to_File_v1.zip

IKM Oracle Incremental Update Lob 2010-06-18

Integrates data into an Oracle target table in incremental update mode. Inexistent rows are inserted; already existing rows are updated. Data can be controlled. Erroneous data is isolated in the error table and can be recycled. When using this module with a journalized source table, it is possible to synchronize deletions.

IKM_Oracle_Incremental_Update_Lob_v1.zip

IKM Oracle Incremental Update (no MINUS) 2010-06-18

Integration Knowledge Module - Integrates data in Oracle database target table in incremental update mode. - Non-existent rows are inserted; existing rows are updated. - Data can be controlled. Invalid data is isolated in the Error Table and can be recycled. - When using this module with a journalized source table, it is possible to synchronize deletions. - This operates without using the MINUS clause on the Insert flow into I$ step, it instead identifies the rows which do not need to be updated with an update statement.

IKM_Oracle_Incremental_Update_(no_MINUS)_v1.zip

IKM Oracle (Pivot) 2010-06-18

Integration Knowledge Module - Pivot data from one row to many rows

IKM_Oracle_(Pivot)_v1.zip

Community Knowledge Module: IKM Oracle (Generic Pivot) 2010-06-18

Integration Knowledge Module - Pivot data from one row to many rows

IKM_Oracle_(Generic_Pivot)_v1.zip

IKM File to Oracle (SQLLDR) DIRECT APPEND Multiple 2010-06-18

Loading Knowledge Module - Loads data from a file to an Oracle Database using the SQL*LOADER utility - Call to SQL*LOADER is made through a Jython call to an Operating System command. - A specific log file is created by SQL*LOADER. Oracle recommends looking at this file in case of error.

IKM_File_to_Oracle_(SQLLDR)_DIRECT_APPEND_Multiple_v1.zip

Community Knowledge Module: IKM File to Oracle (ExtTable) Append 2010-06-18

This KM is a simple/limited KM which is for use when transferring data from a file direct to a table in Oracle. It uses Oracle's EXTERNAL TABLE functionality to get the data into the target table. It does not check to ensure that generated table or index names are within the limits of the technology.

IKM_File_to_Oracle_(ExtTable)_Append_v1.zip

Community Knowledge Module: JKM Oracle 10g Consistent (Streams) 2010-05-24

COMPATIBILITY: ODI 10.1.3.4.4 and above; OWB 11.2 NOTE: Not officially supported. DESCRIPTION - This JKM provides consistent journalizing procedures for Oracle tables. - This KM uses Oracle Streams to capture data changes on the source tables.

JKM_Oracle_10g_Consistent_(Streams)_v2.zip

FTP Windows to Linux: Process Flow Example 2010-05-20

Creating a Warehouse Builder process flow with activities to ftp a file from linux to windows and to test for success.

FTPWindowsToLinux_ProcessFlowExample.zip

Knowledge Module: IKM File to File (Perl) 2010-05-10

Integrate data from file source to file target using Perl.

ikm_file_to_file_perl.zip

Knowledge Modules: MySQL (Experimental) 2010-04-14

A collection of knowledge modules for use with ODI 10.1. Unsupported, but should provide a starting point for developing more robust solutions for these use cases. Includes: KM_CKM_Mysql_3.0_4.0_version_1.0.0.0.xml KM_IKM_File_to_MySQL_mysqlimport_bulk_load_version_1.0.0.0.xml KM_JKM_MySQL_Simple_version_1.0.0.0.xml KM_JKM_MySQL_another_Simple_version_1.0.0.0.xml KM_LKM_File_to_MySQL_mysqlimport_bulk_load_version_1.0.0.0.xml KM_LKM_ISO_SQL_to_MySQL_using_LOAD_DATA_INFILE_version_1.0.0.0.xml KM_LKM_ISO_SQL_to_MySql_load_version_1.0.0.0.xml

Experimental_KMs_MySQL.zip

CustomerOrders update map example 2007-12-13

This example is intended to supplement the ALDSP 3.0 documentation for update maps.

CustomerOrders.zip