Creating Master Repository and Work Repository in ODI 12C

•  Master Repository
• Work Repository
• Physical Architecture
• Logical Architecture

Creating a master repository in ODI 12C

Click on file and click on new.

Click on New master respository.

Give the details of connection.

Select the technology that will host your Master Repository. Here we select the Oracle.

Give the default user name and password.

Username : SUPERVISOR

Password : SYNOPSIS

 

Click on Next.

    

Master Respository Created.

Now we want to create work Respository.

Expand the Respositories and Right Click on work repository and click on new work respository.

 

 

Give the connection details.

 

Here Master and  Work Repositories created.

PHYSICAL ARCHITECTURE:

In Topology Navigator we have ‘Physical Architecture‘ we define the physical connection details of any Instance ( either Oracle DB, SQL Server,  IBM DB2, PostgreSQL, MySQL etc.) or any file system.

 

Create Physical  Schema for that we want Expand  physical architecture and expand the technologies. In that we have to select the oracle and right click on oracle .

Select new data server .

DATA SERVER:

 

                 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’.

Here we have the dataserver name and connection details to create data server.

 

 

Give the jdbc connection details

 

Data server created.

Now Right click on data server which has created and click on new physical schema.

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.

 

 

After creating physical architecture and we have create contexts

 

For creating logical architecture  expand it and select technologies and right click oracle and give the name.

 

 

 

Here we completed topology part.