ODI - Datastore (Source and Target)

Card Puncher Data Processing


A datastore is a structure that allows data to be stored. It can be :

Oracle Data Integrator can then access and integrate:

  • all database systems,
  • ERPs and CRMs,
  • mainframes,
  • flat files,
  • LDAP directories,
  • XML data sources,
  • etc.

Type of DataStore

Tow type of datastore exist :

  • source
  • target


The source datastores contain data used to load the target datastore. Two types of datastores can be used as a source of an interface:

  • The datastores from the models,
  • and temporary datastores target of an interface.

The source datastores of an interface can be filtered during the loading process, and must be put in relation through joins. Joins and filters can be recovered from the models definitions, and can also be defined for the interface. Mapping

The mapping defines the transformation rules on the sources enabling to generate data to load the target.


The target datastore is the element that will be loaded by the interface. This datastore may be :

Discover More
Odi Deployment Specification Ds
ODI - (Interface|Mapping)

An interface in Designer consists of a set of rules that define the loading of a datastore or a temporary target structure from one or more source datastores. You would only need the Empty Dataset...
Odi Cdc
ODI - Change Data Capture

The goal of Change Data Capture is to track change in the source data. When running integration interface, ODI-EE can reduce the volume of source data processed in the flow by extracting only the changed...
Endeca Flexfield Security
ODI - Endeca Integration (IKM SQL to Endeca Server)

Stop the agent process Copy the jar files located in the lib directory of the downloaded files Paste them in the following location. If the ODI agent is a Java application running in WebLogic Server: C:\Oracle\Middleware\user_projects\domains\odiagent\lib....
Odi Project
ODI - Project

A project is a group of objects developed using Designer and is the first thing to do when you begin to design. Oracle...
Card Puncher Data Processing
ODI - Reverse-engineering

This article groups all article Reverse-engineering as for instance for Oracle. If the reverse says it has completed but not all the dimensions in the datastore have been populated, just run the...
Odi Jkm Oracle
ODI - Setting up Journalizing/CDC

This is the basic process for setting up CDC on an Oracle Data Integrator data model. Each of these steps is described in more detail below. Set the CDC parameters Add the datastores to the CDC ...

Share this page:
Follow us:
Task Runner