Skip to main content
Last updated June 28, 2014 00:55, by julien.testut
Feedicon  

Knowledge Modules Samples


To download, right-click on Sample link and select Save Link As... Unzip the files after download before importing the objects in ODI.

Oracle

Sample Description
LKM Oracle to Oracle Datapump Plus Description :
- This is an enhanced version of the LKM Oracle to Oracle (datapump). For details, go to http://www.ateam-oracle.com/using-oracle-data-pump-in-oracle-data-integrator-odi/.
ODI 12c - Temporal KMs Description :
- An Oracle RKM and IKM for temporal validity support. For details, go to https://blogs.oracle.com/dataintegration/entry/odi_12c_temporal_data_loading
JKM Oracle to Oracle Consistent (OGG)-Custom Description :
- This JKM provides consistent journalizing procedures for Oracle tables.
IKM Oracle SCD Type 2 or Type 4 Custom Date and Flag Description :
- Management of TYPE 2 Slowly Changing Dimensions on Oracle.
- Data can be controlled. Invalid data is isolated in the Error Table and can be recycled.
IKM Oracle Incremental Update Row By Row Update Description :
- Integrates data into an Oracle target table in incremental update mode.
- Inexistent rows are inserted; already existing rows are updated.
IKM Oracle 11g UnPivot Control Append Description :
- Pivot data from one row to many rows
- Uses Oracle's New UnPivot Command in Oracle 11g Database .
IKM Oracle 11g Pivot Control Append Description :
- Pivot data from one row to many rows
- Uses Oracle's New Pivot Command in Oracle 11g Database .
IKM Oracle Incremental Update (MERGE) For Exadata 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 efficient on Exadata when the Source and Target are on the same database.
IKM File to Oracle (ExtTable) Append 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.
IKM File to Oracle (SQLLDR) DIRECT APPEND Multiple 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.
IKM Oracle (Generic Pivot) Integration Knowledge Module
- Pivot data from one row to many rows
IKM Oracle (Pivot) Integration Knowledge Module
- Pivot data from one row to many rows
IKM Oracle Incremental Update Lob Integrates data into an Oracle target table in incremental update mode.
Inexistent rows are inserted; already existing rows are updated. Data can be controlled.
IKM Oracle Incremental (No Minus) Integrates data in Oracle database target table in incremental update mode.
- Non-existent rows are inserted; existing rows are updated.
- Data can be controlled.
Inexistent rows are inserted; already existing rows are updated. Data can be controlled.
IKM SQL to Oracle SQLUnload-EXTTABLE 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.
LKM EBCDIC File to Oracle SQLLDR 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.
LKM File to Oracle SQLLDR with EBCDIC Option 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.
LKM File to Oracle SQLLDR Cyrillic This LKM loads flat file data into Oracle by using the SQL*LOADER utility.
LKM SQL to Oracle CLOB Loads data from any ISO-92 database to any ISO-92 compliant target database.
Specially modified for dealing with CLOB values.
LKM SQL to Oracle Bulk ExtTable Bulk loads data into Oracle - from any database
LKM SQL to Oracle Lob Loads data from any ISO-92 database to any ISO-92 compliant target database.
Specially modified for dealing with CLOB and BLOB values.
LKM VSAM to Oracle JCL IDCAMS - SQLLDR Loads data from an MVS source into Oracle.
LKM DB2 MVS to Oracle JCL Unload - SQLLDR Create and Execute 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 Oracle using SQLLDR

Apache Sqoop

Sample Description
IKM SQL to HDFS File Sqoop ODI knowledge module to import data from relational databases into HDFS files using Sqoop.
For details, go to http://www.ateam-oracle.com/importing-data-from-sql-databases-into-hadoop-with-sqoop-and-oracle-data-integrator-odi
IKM SQL to HDFS Hive Sqoop - ODI knowledge module to import data from relational databases into HDFS Hive tables using Sqoop.
For details, go to http://www.ateam-oracle.com/importing-data-from-sql-databases-into-hadoop-with-sqoop-and-oracle-data-integrator-odi

File

Sample Description
IKM File to File (Perl - Hadoop) 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.
IKM PostgreSQL to File - Loads a file from a Postgres source
- The file is populated in truncate / insert mode.
- A flow table is created

Generic

Sample Description
IKM SQL Control Append From DUAL Description :
- Integration Knowledge Module.
- Integrates data in any ISO-92 compliant database target table in truncate / insert (append) mode.
IKM for Oracle Table Function Illustration of how to generate SQL components such as Oracle Table Functions from within ODI.
IKM SQL as a Source Lets users build temporary interfaces that represent inline views or SQL as a source.
IKM SQL Control Append BIG DATA 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.

Greenplum

Sample Description
Greenplum KMs Set of KMs for Greenplum (LKM, IKMs and CKM), also includes the Greenplum technology for import into the ODI Topology.

Hive Hortonworks

Documentation: Teradata UDA Knowledge Modules Documentation (PDF)

Sample Description
CKM Hive Hortonworks CKM for Hive Hortonworks Hadoop distribution
IKM File to Hive Hortonworks LOAD DATA IKM to load files to Hive Hortonworks using the bulk command LOAD DATA
IKM Hive Hortonworks Control Append IKM to load a Hive Target Table from a Hive Staging area, the insert operation can be controlled with CKM Hive Hortonworks KM
IKM Teradata Aster SQLMR to Hive Hortonworks Control Append IKM to invoke a Teradata SQL Map Reduce command in a Teradata Aster Staging Area then insert the result into a Hive Hortonworks target table.
The insert operation can be controlled
IKM Hive Hortonworks Multi Table Insert IKM to integrate a Hive staging area into multiple target Hive tables in a single SQL statement
RKM Hive Hortonworks RKM for Hadoop Hive Hortonworks

Microsoft SQL Server

Sample Description
JKM Oracle to MSSQL Consistent (OGG) Description :
- This JKM provides consistent journalizing procedures for Oracle tables to SQL Server using OGG
JKM MSSQL to MSSQL Consistent (OGG) Description :
- This JKM provides consistent journalizing procedures for MSSQL tables using OGG

MySQL

Sample Description
Experimental_KMs_MySQL.zip Knowledge Modules: MySQL (Experimental)
A collection of knowledge modules for use with ODI.
Unsupported, but should provide a starting point for developing more robust solutions for these use cases.

Teradata

Sample Description
IKM Teradata to Teradata BTEQ - 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)

Teradata Aster

Documentation: Teradata UDA Knowledge Modules Documentation (PDF)

Sample Description
Teradata Aster Technology Definition Technology definition for Teradata Aster to be imported in ODI topology
CKM Teradata Aster CKM for Teradata Aster Discovery Platform
IKM Teradata Aster Control Append IKM Control Append for Teradata Aster Discovery Platform
LKM File to Teradata Aster ncluster loader Loads a Teradata Aster staging area using ncluster loader bulk loading utility
LKM Hadoop Hcatalog Hortonworks to Teradata Aster SQL-H Loads a Teradata Aster staging area table from a Hcatalog table (in Hadoop) using Teradata SQL-H protocol.
Note: this LKM actually only creates a C_ view in Aster that loads the data when selected
 
 
Close
loading
Please Confirm
Close