Configure the Components › Integrate CA Business Intelligence with CA Service Catalog › Create DSN and ODBC Connection for CA Service Catalog

Create DSN and ODBC Connection for CA Service Catalog

You can create an ODBC connection to the CA Service Catalog 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: ASC

   Description

   (Optional) Specifies the description of the data source.

   Example: Catalog 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: Catalog Server

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 MDB 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 (mdb) from the drop-down list.
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.

    

    Note: Record the ODBC name of CA Service Catalog in the Installation Worksheet under CA Business Intelligence.

14. Click OK.

    Note: If the MDB Database used by CA Service Catalog and Software Delivery are created, a second ODBC Connection will need 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.