1. Oracle Data Integrator Quick Reference Guide
  2. Mappings

10 Mappings

Learn about Mappings in Oracle Data Integrator and how to create them.

Topics

What are Mappings

Find out what Mappings are in Oracle Data Integrator.

Mappings in Oracle Data Integrator (ODI) are the logical and physical organization of your data sources, targets, and the transformations through which the data flows from source to target. A mapping connects sources to targets through a flow of components such as Join, Filter, Aggregate, Set, Split, and so on. A mapping also references the Knowledge Modules (code templates) that are used to generate the integration process. Each of the sources and targets is represented by a datastore. Business rules define how the data progresses from source to target and the manipulations that occur along the way. You define the business rules in natural language and using ODI translate them into SQL. You can save mappings as reusable mappings to use again in different mappings.

Mappings are made up of several parts, datastores, datasets, re-usable mappings, connectors, knowledge modules, variables, sequences, user functions, and other components. Optionally, you can specify a staging schema.

You create and manage mappings using the mapping editor, which opens whenever you open a mapping. Mappings are organized in folders under individual projects, found under Projects in the Designer Navigator.

See Introduction to Mappings in Developing Integration Projects with Oracle Data Integrator.

See Reusable Mappings in Developing Integration Projects with Oracle Data Integrator.

Create Mappings

Learn how to create a mapping in Oracle Data Integrator.

To create a new mapping:
  1. Go to the Designer Navigator, expand the project and folder where you want to create the mapping and select the Mappings node.
  2. (optional) Select Create Empty Dataset if you want the new mapping to contain a new empty dataset.
  3. Construct your mapping by dragging components onto the logical diagram of the mapping editor.
  4. Connect and configure components by dragging connections between the components, dragging attributes across those connections, and modifying the properties of the components using the property inspector.
  5. Use the physical diagram to define where and how the integration process is going to run on your physical infrastructure.
  6. Run the mapping.

See Creating a Mapping in Developing Integration Projects with Oracle Data Integrator.

See Creating a Reusable Mapping in Developing Integration Projects with Oracle Data Integrator.