ODI - Datastore (Source and Target)

About

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

• a table,
• a file,
• a message queue
• or any other data structure accessible by middleware used by Oracle Data Integrator (JDBC/ODBC, JMS or JNDI).

Oracle Data Integrator can then access and integrate:

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

Articles Related

Type of DataStore

Tow type of datastore exist :

• source
• target

Source

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.

Target

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

• permanent (defined in a Model)
• or temporary (created by the interface in the staging area).