In this blog we will explore some areas of ODI Topology Navigaor.
- We will explore Dataserver, Physical Schema, Logical Schema & Context.
- Relationship between Physical, Logical Schema & Context.
Regarding setup & configuration of Dataserver, Physical Schema, Logical Schema in ODI using Oracle Technology please refer below video.
Let’s explore Topology Navigator in detail.
In Topology Navigator we have ‘Physical Architecture‘ section where we define the physical connection details of any Instance ( either Oracle DB, SQL Server, IBM DB2, PostgreSQL, MySQL etc.) or any file system.
What is Dataserver?
A ODI object that defines the physical connection to any database instance or any file system. It basically store the host, username & password related details of an instance.
To define any physical connection in ‘Physical Architecture‘, you have to create a Data Server. Just click on your desired technology in Physical Architecture & click on ‘ New Data Server’.
After that you have to provide instance details. In case of any Database instance provide host, user/password & JDBC details.
JDBC Details in case of oracle database as instance:
In case of any file. Just provide the folder path from where you pick raw files in interface.
JDBC Details in case of file:
Now after adding the Data-server, next step is to add the ‘Physical Schema‘ in Data-server.
What is Physical Schema?
Physical Schema represents the actual connection to the data source (any database instance or any file system).
ODI Physical Schema corresponds to a pair of schema:
- Main Schema (Data) – In which ODI look for the source and target objects for the interfaces.
- Work Schema – Generally used by ODI for staging purpose, here ODI create temporary data objects associated to the sources and targets. Example C$, I$, E$ tables. It is always preferred to create & use separate work schema.
To define any physical schema, go to Data Server you created and then just click on new ‘New Physical Schema’.
After that you have to provide Schema Name & Work Schema name using drop down. It will show you all the schema present in selected data-server instance.
- RAW_SCHEMA – schema where my source/target tables lies.
- ODI_WORK_SCHEMA – Created for ODI staging purpose.
Now after adding the Physical Schema, next step is to create Logical Schema & Context.
What is Logical Schema & Context?
- Logical schema represents the logical name associated to that source/target objext.
- One logical schema can be associated with multiple physical schema along with context, i.e. one logical schema is associated with different physical schema using different context.
To add any new context, go to Context Section and then just click on new ‘New Context’.
Create Logical Schema:
To define any logical schema in ‘Logical Architecture‘ . Just click on your desired technology & click on ‘New Logical Schema’.
After that you have to provide the logical schema name & Physical Schema mapping with context.
So in Dev Context, Logical Schema LS_RAW_SCHEMA is pointing to Physical Schema DS_ORACLE_DEV.RAW_SCHEMA.
It may be possible that in Test Context, Logical Schema LS_RAW_SCHEMA is pointing to different Physical Schema DS_ORACLE_TEST.RAW_SCHEMA.
Refer this video clip for better understanding of Logical Schema & Context relationship.
Happy Learning! Your feedback would be appreciated!