1. Oracle Data Integrator Quick Reference Guide
  2. Data Stores

7 Data Stores

Learn about data stores, what they are and how to create them.

Topics

What are Datastores

Learn what datastores are in Oracle Data Integrator.

A datastore in Oracle Data Integrator (ODI) is a data structure, for example a table in a relational database, or a JMS topic from a Message-Oriented Middleware, that can be used in a mapping as a source or target. All datasources in ODI, regardless of the underlying technology, appear as datastores, and can be manipulated and integrated in the same way. The datastores are grouped in data models, which contain all declarative rules and constraints.

See Datastores in Developing Integration Projects with Oracle Data Integrator.

Create a Datastore

Learn how to create a datastore in Oracle Data Integrator.

The easiest and most common way to create a datastore in ODI is by reverse-engineering its structure from the technology (for example, Oracle or MySQL database). However, you can create datastores in two other ways:
  • Directly in the model.
  • By using the Common Format Designer component.

In these cases, the datastores do not necessarily have to exist in the data server. This can be useful for creating a new text file with a structure that you define.

To create a datastore directly in a model, perform the following steps:
  1. Select a model.
  2. Right-click and select New Datastore.

    The Resource Name field refers to the physical name of the table in a database or the name of the file for a file-based datastore. If you use a mapping to create this datastore in a database, the resource name is the name of the table that is generated. The alias, on the other hand, is the name that you use to refer to the datastore in mappings, joins, and so on.

  3. Set the name. This is the name that is displayed in ODI in the Model tree view. Often, this is similar to the resource name.
  4. Provide a description for the datastore (optional).
After you set up the basic parameters, you may want to add columns to the definition. To do this, perform the following steps:
  1. Click the Attributes tab.
  2. Click the Add Column icon to add another column.
  3. Define properties for each column.

    The meanings of the Name, Type, Logical length, and Scale options depend on the technology of the model. Not Null means that the field is mandatory. You can set other properties in the columns by double-clicking their names in the Models view.

  4. Reorder the newly-added columns using the up and down arrows.

See Creating and Reverse-Engineering a Datastore in Developing Integration Projects with Oracle Data Integrator.