Install the Components › Install CA Business Intelligence › Create DSN and ODBC Connection

Create DSN and ODBC Connection

You can create an ODBC connection to the CA Business Intelligence Central Management Database.

Follow these steps:

1. Run the odbcad32.exe file from the following location:

   c:\Windows\SysWOW64\
   

   The ODBC Data Source Administrator dialog opens.

   

2. Click the System DSN tab, and click Add.

   The Create New Data Source wizard opens.

   

3. Select SQL Server from the driver list and click Finish.

   The Create a New Data Source to SQL Server page opens.

   

4. Enter the following parameters.

   Name

   Specifies the name of the database.

   Example: BOXI

   Description

   (Optional) Specifies the description of the data source.

   Example: Business Objects CMS Database

   Server

   Use the drop-down list and select the server where the database resides. If a Named Instance of SQL is used, then enter <SQL Server>\<Named Instance>.

   Default: localhost

5. Click Next:

   The Create a New Data Source to SQL Server page opens.

   

6. Select the With SQL Server authentication using a login ID and password from the user option.
7. Select the Connect to SQL Server and obtain default settings for the additional configuration options.
8. Type a Login ID and Password with access to the BOXI database, and click Next.

   The Microsoft SQL Server DSN Configuration page opens.

   

9. Select the Change the default database to check box and select the database name from the drop-down menu.
10. Click Next.

    

11. Click Finish.

    The ODBC Microsoft SQL Server Setup page opens.

    

12. Click Test Data Source and verify the connection.

    A confirmation message appears.

    

13. Click OK to close the message and click OK to close the ODBC Microsoft SQL Server Setup page.

    The ODBC Data Source Administrator page opens.

    

14. Click OK.

    Note: If the MDB Database used by CA Service Catalog and Software Delivery are created, a second ODBC Connection needs to be created to this MDB Database. This step is performed in the Post-Configuration section, but you could perform now if products are installed and the MDB Database is created.

    The DSN and ODBC connection are complete.