Creating a New ODI Source Dataserver and the Physical Schema

After you created the new database source datastore, you need to create a new ODI sourcet data server and the Physical schema.

Note: Skip this section, if you completed the OBE " Creating an ODI Project and Interface: Exporting a Flat File to a RDBMS Table" earlier.

To create the ODI source data server and physical schema, perform the following steps:

1.	In ODI, Open ODI Topology Navigator and then select the Physical Architecture tab. Expand Technologies, right-click Oracle and select New Data Server.
2.	In the Data Server: New window, enter the values provided in the table below. Click the JDBC tab. Parameter Value Name ODI_STAGE Instance/dblink (Data Server) ORCL User ODI_STAGE Password ODI_STAGE
3 .	Click for JDBC Driver. Select Oracle JDBC Driver. Click OK. Click for JDBC Url, select jdbc:oracle:thin:@<host>:<port>:<sid>, and then click OK. Edit the Url to read: jdbc:oracle:thin:@localhost:1521:ORCL for Oracle Database. Note: Do not copy and paste in the JDBC Url field. This may cause problems with entering a valid URL string.
4 .	Click Test Connection. In the window that opens, click Yes to save your data. In the Information window, click OK. Click Test to verify successful connection. Click OK.
5 .	Click Expand Oracle technology node, right-click ODI_STAGE dataserver, and then select New Physical Schema.
6 .	In Schema (Schema) and Schema (Work Schema) field enter your ODI_STAGE schema. Click Save button. Close ODI_STAGE.ODI_STAGE physical schema window. In the Information window, click OK.
7 .	Open Logical Architecture tab, expand Technologies > Oracle. Right-click Oracle technology and then select New Logical Schema.   1 . Name logical schema ODI_STAGE. In the Global context, connect this logical schema to ODI_STAGE physical schema as shown below. Click Save button and then close the tabs.