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

KM_LKM_Files_to_Oracle__EXTERNAL_TABLE_.xml

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

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

KM_SQL_TableFunction.xml

Bulk loads data into Oracle - from any database

klm_lkm_SQLtoOracle_Bulk_ExtTable.zip

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

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

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

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

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

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

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

WarehouseBldrUtilityExchangeDlds.zip

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

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

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

odi_11g_udfsample.zip

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

LCT_RESTWS_TO_ORACLE.zip

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

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

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

- 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

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

Loads data from an MVS source into Oracle.

LKM_VSAM_to_Oracle_(JCL_IDCAMS_-_SQLLDR)_v1.zip

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

LKM_SQL_to_Oracle_(CLOB)_v1.zip

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

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

LKM_File_to_Oracle_(SQLLDR)-Cyrillic_v1.zip

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

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

- 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

- 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

- 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

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

- 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

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

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

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

IKM_Oracle_(Pivot)_v1.zip

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

IKM_Oracle_(Generic_Pivot)_v1.zip

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

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

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

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

FTPWindowsToLinux_ProcessFlowExample.zip

Integrate data from file source to file target using Perl.

ikm_file_to_file_perl.zip

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

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

CustomerOrders.zip