ODI - Logical Schema

ODI - Logical Schema

The aim of the logical schema is to ensure the portability of procedures and models on different physical schemas at runtime.

A logical schema is an alias that allows a unique name to be given to all the physical schemas containing the same datastore structures.

A logical schema can have one or more physical implementations on separate physical schemas, but they must be based on data servers of the same technology.

A logical schema is always directly linked to a technology.

To be usable, a logical schema must be declared in a context.

Declaring a logical schema in a context consists of indicating which physical schema corresponds to the alias -logical schema - for this context.

Creating a Logical Schema

To create a logical schema:

In Topology Navigator expand the Technologies node in the Logical Architecture accordion.

Select the technology you want to attach your logical schema to.

Right-click and select New Logical Schema.

Fill in the schema name.

For each Context in the left column, select an existing Physical Schema in the right column. This Physical Schema is automatically associated to the logical schema in this context. Repeat this operation for all necessary contexts.

From the File menu, click Save