Creating a new SQL Server database connection

You can create a SQL Server database connection using a JDBC driver.

1. After importing the TrueSight_DataMart universe as mentioned in Importing-a-universe-that-is-stored-in-the-repository, 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 MS SQL Server 2008, select JDBCDrivers. Click Next.
7. In the Parameters for MSSQL 2008 Connection screen, enter the following details:
   1. In the Authentication Mode list, select Use specified user name and password.
   2. Enter the following details depending on the authentication:
      • For SQL Server authentication:
        
        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_sql_user.bat 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_sql_user.bat script.
        3. Servers — type the database host name and the port in the following format. The default port number is 1433.
           SQLServerhostName:SQLServerInstancePort
           For example, foo.zz.com:1433
        4. Database — type the SQL Server database name.
      • (Windows only) For Windows authentication:
        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_sql_user.bat 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_sql_user.bat script.
        3. Servers — type the SQL Server host name and the SQL Server port in the following format. The default port number is 1433.
           SQLServerhostName:SQLServerInstancePort;integratedSecurity=true
           For example, clm-pun-000735.bmc.com:1433;integratedSecurity=true
        4. Database — type the SQL Server database name.
   3. Click Test Connection, to validate the connection.
   4. Click Finish.

Where to go next

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