ODI - Logical Schema

Card Puncher Data Processing


Creating a logical schema:

Odi Topology Create Logical Schema

Naming Convention

Oracle recommend that you prefix any logical schema name with the technology it belongs to. The name should be a meaningful name such as the one used usually to reference applications, schemas or business areas. Put the name in uppercase.





Connect to Topology Manager

  • Select Topology > Logical Architecture > Technologies in the tree, then select the technology you want to attach your schema to.
  • Right click and select Insert 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.
  • Click OK .

Discover More
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...

Share this page:
Follow us:
Task Runner