Skip Headers
Oracle® Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator
11g Release 1 (11.1.1)

Part Number E12644-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

13 IBM Informix

This chapter describes how to work with IBM Informix in Oracle Data Integrator.

This chapter includes the following sections:

13.1 Introduction

Oracle Data Integrator (ODI) seamlessly integrates data in an IBM Informix database. Oracle Data Integrator features are designed to work best with IBM Informix, including reverse-engineering, journalizing, and integration interfaces.

13.2 Concepts

The IBM Informix concepts map the Oracle Data Integrator concepts as follows: An IBM Informix Server corresponds to a data server in Oracle Data Integrator. Within this server, an Owner maps to an Oracle Data Integrator physical schema.

Oracle Data Integrator uses Java Database Connectivity (JDBC) to connect to an IBM Informix database.

13.3 Knowledge Modules

Oracle Data Integrator provides the Knowledge Modules (KM) listed in Table 13-1 for handling IBM Informix data. These KMs use IBM Informix specific features. It is also possible to use the generic SQL KMs with the IBM Informix database. See Chapter 4, "Generic SQL" for more information.

Table 13-1 IBM Informix Knowledge Modules

Knowledge Module Description

IKM Informix Incremental Update

Integrates data in an IBM Informix target table in incremental update mode. This IKM creates a temporary staging table to stage the data flow. It then compares its content to the target table to guess which records should be inserted and which others should be updated. It also allows performing data integrity check by invoking the CKM.

Inserts and updates are done in bulk set-based processing to maximize performance. Therefore, this IKM is optimized for large volumes of data.

Consider using this IKM if you plan to load your IBM Informix target table to insert missing records and to update existing ones.

To use this IKM, the staging area must be on the same data server as the target.

JKM Informix Consistent

Creates the journalizing infrastructure for consistent journalizing on IBM Informix tables using triggers.

Enables Consistent Set Changed Data Capture on IBM Informix.

JKM Informix Simple

Creates the journalizing infrastructure for simple journalizing on IBM Informix tables using triggers.

Enables Simple Changed Data Capture on IBM Informix.

LKM Informix to Informix (SAME SERVER)

Loads data from a source Informix database to a target Informix staging area located inside the same server.

This LKM creates a view in the source database and a synonym in the staging area database. This method if often more efficient than the standard "LKM SQL to SQL" when dealing with large volumes of data.

Consider using this LKM if your source tables are located on an IBM Informix database and your staging area is on an IBM Informix database located in the same Informix server.

RKM Informix

Retrieves IBM Informix specific metadata for tables, views, columns, primary keys and non unique indexes. This RKM accesses the underlying Informix catalog tables to retrieve metadata.

Consider using this RKM if you plan to extract additional metadata from your Informix catalog when it is not provided by the default JDBC reverse-engineering process.

RKM Informix SE

Retrieves IBM Informix SE specific metadata for tables, views, columns, primary keys and non unique indexes. This RKM accesses the underlying Informix SE catalog tables to retrieve metadata.

Consider using this RKM if you plan to extract additional metadata from your Informix SE catalog when it is not provided by the default JDBC reverse-engineering process.

SKM Informix

Generates data access Web services for IBM Informix databases. See SKM SQL in Chapter 4, "Generic SQL" for more details.


13.4 Specific Requirements

There are no specific requirements for using IBM Informix in Oracle Data Integrator.