14.1 Terminology Information

There are similarities in the functionality between Oracle Data Integrator and Oracle Data Transforms, however, the terminology is different.

The differences in the terminology used in Oracle Data Integrator Studio and Oracle Data Transforms are:

Oracle Data Integrator Studio Oracle Data Transforms Functions

Data Server

Connection

Represents the physical object where data is stored.

Examples include Database Instances, File Servers, and Cloud Application Instances. The properties contain all information required to connect and access data.

Technology

Connection Type

Examples include Oracle, IBM DB2, Oracle Netsuite, Oracle Object Storage.

For the list of supported technologies, see Supported Connection Types.

Physical Schema

Schema

Examples include Database Schema, File server Folder, Object Storage Bucket.

Data Store

Data Entity

A Tabular representation of a data structure. Examples include Database Tables, Files.

Reverse Engineering

Import Data Entity

The process of obtaining the metadata for a filtered set of objects in a Schema. Examples include Table Definitions from an Oracle Schema, VOs from a Cloud Applications Offering.

Model

Data Entity

The container for the imported objects. The properties define the rules for importing (how to filter and so on).

Project

Project

Container for the Transformation Design components (Mappings, Packages, Jobs). This doesn't include Data Servers, Schemas, Data Stores and Folders (which are shared between Projects)

Mapping

Data Flow

The Transformation Design. Defines how data flows from one Data Store to another, and how it is transformed.

Package

Workflow

Defines the sequence in which Mappings will be executed, together with what happens of failure conditions.

Job / Session

Job

The execution of a Package, Mapping or Reverse Engineer.

Schedule

Schedule

The rules for when a session executes.

Resource

Resource

Something you can schedule (a mapping or package).