ODI 12c :- Oracle Data Integrator 12c - Creating Physical Architecture

In this post I am going to show how to create Physical architecture in the Oracle Data Integrator 12c.

Open the ODI Studio.

Click on the ‘Connect to Repository ’ to connect the ODI studio.

Once you connect give the credentials for Connection.

Go to the Topology Tab and Select the Oracle Physical Architecture and click on the New Data Server.

Then give the Data server Details as below.

Give the JDBC details in the JDBC menu.

Click Test Connection button and should have successfull connaction.

Click on the Test Connection button and Check the connectivity and we have successful connection with our physical Database.

Then we can see the Created Data server in the Physical Architecture under Oracle Technology.
Then select the created Data Server and Create Physical Schema for that.

Give the name for Physical schema.

Go toContext tab and Give Logical schema name.

When you are creating Logical schema you have to give this logical name.

Thank you !!!!