Configuring the Target Data Server

This section describes how to setup an Oracle Data Server. Please use respective settings when configuring a non-Oracle Target Data Server for use with LKM SAP ERP to SQL.

1. Connect to Topology Manager.

2. In the Physical Architecture tree view, expand the Technologies node and select the Oracle technology.

3. Right-click and select New Data Server.

4. Enter the data server Definition as shown below:

   
   Description of the illustration GUID-5A0EB8E7-1EB8-4AE2-8603-0933013202C2-default.jpg

5. Select the JDBC tab, and enter the JDBC connection information to your data server as shown below:

   
   Description of the illustration GUID-506C790D-C0F8-48D7-90C0-B6E955C4705C-default.jpg

   Make sure to change the URL to match your Oracle instance configuration.

6. Click Test Connection to test the connection to this data server.

7. From File menu, click Save.

8. Right-click the data server you created and select New Physical Schema.

9. In the Physical Schema windows that appears, select the ODI_SAP_DEMO for both Schema and Work Schema.

   If you already have a Work Schema for ODI defined for this data server, you can use it instead of the ODI_SAP_DEMO Schema.

10. Go to the Context tab.

11. Click Add and enter in the Logical Schema field the value ODI_SAP_DEMO.

12. From the File menu, click Save.