ODI - The physical schema

Card Puncher Data Processing

Creation

When you create a data server, the physical schema windows appear automatically or right click on a data server, insert a physical schema.

Fill in:

  • the schema
  • the work schema. ODI Knowledge Modules often use temporary objects to stage temporary data for jobs optimization. These temporary objects are always stored in a particular schema or directory called the Work Schema (or staging area).
  • the context

For a database (Oracle)

It is preferable to create a specific schema dedicated to any Work tables. By creating a schema named “SAS” or “ODI” in all your data servers, you ensure that all Oracle Data Integrator activity remains totally independent from your applications. 

CREATE USER odi IDENTIFIED BY odi;
GRANT CONNECT,RESOURCE TO odi;

Odi Topology Create Physical Schema

For a file system

Odi Essbase Data Server File




Discover More
Odi Work Schema
ODI - CDC Journalizing Infrastructure

When the journals are started, the journalizing infrastructure (if not installed yet) is deployed or updated. When the journalizing knowledge module creates triggers, they are installed on the tables...
Odi Topology Create Data Server
ODI - Data Server (Data Source)

Data servers describe connections to your actual physical application servers and databases. They can represent for example: An Oracle Instance, A File System, An XML File, A Desktop database...
Odi Oracle Reverse Def
ODI - Reverse-engineering Oracle

for Oracle create a context create a physical data server and its physical schema create (if not define in the physical schema) a logical schema You have two type (two ways) to reverse...
Odi Designer Execute On
ODI - Staging Area (or Work area)

ODI Knowledge Modules often use temporary objects to: stage temporary data for jobs optimization. execute some rules ... These temporary objects are always stored in a particular schema or directory...



Share this page:
Follow us:
Task Runner