Creating a new Oracle database connection

You can create a database connection using a JDBC driver or an Oracle client.

To create a database connection using JDBC drivers

To create a database connection using the JDBC drivers, perform the following steps:

1. After importing the TrueSight_DataMart.lcmbiar file, in the Repository Resources tab, click Insert Session.
2. In the Open Session dialog box, specify the System, User Name, and Password and click OK
3. Right -click Connections > Insert Relational Connection.
4. In the New Relational Connection dialog box, enter the Resource Name and Description (optional).
5. Click Next.
6. In the Database Middleware Driver Selection screen, expand Oracle > Oracle 11 and select JDBC Drivers. Click Next.
7. In the Parameters for Oracle Connection screen, enter the following details:
   1. In the Authentication Mode list, select Use specified user name and password.
   2. Type the following values:
      1. User Name — Type reuniv (read only user) or type Report Engine Database login name (for users other than read only) you have created using the create_TrueSightOperationsManagementReporting_user_tablespaces.sql script.
      2. Password — Type RE#Adm1n (read only user) or type the password for the Report Engine database login (for users other than read only) you have created using the create_TrueSightOperationsManagementReporting_user_tablespaces.sql script.
      3. Servers — Type the database host name and the port in the following format. The default port number is 1521.
         hostName:listnerPort
         For example, foo.zz.com:1521
      4. Net Service — Type in the Oracle_SID.
   3. Click Next.

To create a database connection using an Oracle client

1. After importing the TrueSight_DataMart.lcmbiar file, in the Repository Resources tab, click Insert Session.
2. In the Open Session dialog box, specify the following details:
   • System— type the host name
   • User Name — type the user name
   • Password — type the password for the user
3. Click OK
4. Right -click Connections > Insert Relational Connection.
5. In the New Relational Connection dialog box, enter the Resource Name and Description (optional).
6. Click Next.
7. In the Database Middleware Driver Selection screen, select Oracle Client. Click Next
8. In the Parameters for Oracle Connection screen, enter the following details:
   1. In the Authentication Mode list, select Use specified user name and password.
   2. Enter the User Name: Type reuniv (read only user) or type Report Engine Database login name (for users other than read only) you have created using the create_TrueSightOperationsManagementReporting_user_tablespaces.sql script.
   3. Enter the Password: Type RE#Adm1n (read only user) or type the password for the Report Engine database login (for users other than read only) you have created using the create_TrueSightOperationsManagementReporting_user_tablespaces.sql script.
   4. Enter the Service: Enter Oracle_SID.
   5. Click Next.
9. In the Configuration Parameters page, type in the values that you populated in the Planning sheet for installation and configuration, and click Next.
10. In the Custom Parameters page, set the appropriate values for the custom parameters.
     The parameters that appear depend on the other parameters that you have set.
11. Click Finish.
     A new connection is created, and in the Connection list, the new connection appears selected.
12. Click OK.

Where to go next

Exporting-the-universe-back-to-the-repository