Universal Data Access – Defining the Physical and Logical schema for Oracle data source

In this blog, we will be talking about defining the Physical and Logical schema for the Oracle data source so that we can access Oracle database tables in FDMEE. For this blog, we will be connecting to a schema called FINRPT on the local machine. Before accessing the schemas and associated tables in FDMEE, we will configure the schemas in ODI.

Configuring the Oracle Physical schema is shown in the following snapshots:

 
The above snapshot shows me connecting to Oracle database successfully.

The next snapshot shows me configuring the physical schema for the Oracle DB.

The next step would be to configure Context in ODI. ODI by default comes with one Context called as “Global”. We just need to right click and duplicate it to create a new context. The concept of context is similar to the concept of namespace from programming.

The following snapshots show me configuring the context for Oracle database. Please note that the name of the Context and the code has to be UDA_ORCL in case of Oracle database.

I click Yes in the above snapshot to confirm my choices.

The following couple of snapshots show me configuring the Logical schema details for my Oracle table.
Observe that the new added context is now visible in the Logical schemas.

In the next blog, I would be talking about how to import the adapters for configuring Universal Data Access.

Link to previous blogs:

Installing Oracle Data Integrator for enabling Universal Data Access in FDMEE  - http://exploitsinhyperion.blogspot.in/2017/04/installing-oracle-data-integrator-for.html

Connecting to FDMEE Work Repository using Oracle Data Integrator  - http://exploitsinhyperion.blogspot.in/2017/04/connecting-to-fdmee-work-repository.html

Applying OPATCH for enabling Universal Data Access in FDMEE - http://exploitsinhyperion.blogspot.in/2017/05/applying-opatch-for-enabling-universal.html