Setting The Topology

 Hi Gurus,



Today Let me show you how to set the topology for oracle schemas.

Assuming that you have the following schemas defined in your oracle database.
1. SRC_SCOTT

2. TRG_SCOTT

Run the ODI Studio

Click  on connect to repository.
Select the appropriate ODI Login
Click OK
Now ODI is connected to Repository and you would able to see the ODI tools Desiner,Topology, Operator and Security manager

Click on topology
Expand the technolgy tree
Select oracle technology

Right Click on Oracle technology
Click on New Data server
Now the Data server creation wizard opens

Enter same name for your data server: ORACLE_DS
Give the user name and password of System user of your database: system/sysdba
Then click on JDBC

Click on search button to select the appropriate JDBC Driver
Enter the JDBC url to connect to your database
My database is running on my local system (localhost) on port number 1521 and SID is "odigurus"

Click on Test connection
Click OK to save
Click on Test

If the test connection is successful then you need to create physical schemas
Right click on the Created Data Server
Click on New physical schema

Now the Physical schema creation wizard opens
Select "SRC_SCOTT" as shown below
Click on Context

 Click "+" symbol

Give some logical schema name: SRC_SCOTT_LS
Click on Save

 Repeat the Above steps to create a physical schema for TRG_SCOTT

Now you have perfectly defined the topology for the Oracle schemas SRC_SCOTT and TRG_SCOTT
You can go to designer and start creating models for these two physical schemas

Thanks & Regards

WWW.ODIGURUS.COM