Installation Guide for Oracle Billing Insight > Configuring the ODI Data Load Processes >

Setting up the Database Topology

You must set up the database topology for connecting to the Oracle Billing Insight schemas when loading data.

To set up the database topology

1. Run and log into ODI.
2. Connect to the ODI repository.
3. Click the Topology tab, expand the Physical Architecture tree, and then expand Technologies. Right-click Oracle, select New Data Server, and specify the following:
   • Name. It is recommended that you use db-ebill.
   • Instance and OLAP Schema. Enter the instance and OLAP schema credentials.
   • Driver List. Click the JDBC tab, click the Search icon, and search for and choose Oracle JDBC Driver from the drop-down list.
   • JDBC URL. Enter the credentials for your database server. Click Search, and select jdbc:oracle:thin:host:port:SID. Replace host, port, and SID with the values for your implementation.
4. Click Save.
5. Click Test.
6. Expand the Logical Architecture, expand Technologies. Right-click Oracle, select New Logical Schema, and specify the following:
   • Name. It is recommended that you use db-ebill.
   • Context. For Global, choose db-ebill OLAP schema name from the Physical Schemas drop-down list.
7. Click Save.
8. In the Physical Architecture tree, expand Technologies tree, and expand the Oracle tree. Right-click the new data server, db-ebill, select New Physical Schema, and specify the following:
   • Schema. Choose your OLAP schema name.
   • Work Schema. Choose your OLAP schema name.
9. Click the Context tab, and click the Add icon. In the Logical Schema drop-down list, select db-ebill.
10. Click Save.