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).