Create an ODBC System DSN

Create an ODBC System DSN to the CA Configuration Automation database before importing the BIAR file to connect to the database. The ODBC System DSN provides connectivity to the CA Configuration Automation database.

Note: If you are using a SQL Server database, we recommend an OLE DB connection.

Important! If you are using an Oracle database, you do not need to create an ODBC System DSN. Install the Oracle client (TNS entry) on the computer where you installed CA Business Intelligence, and create an entry for the database server in the tnsnames.ora file.

Note: For information about how to install an ODBC driver in UNIX, see the white paper on the SAP Developer Network website named "How to Install and Configure DataDirect 5.2 on UNIX." This white paper describes how to configure the database credentials in the odbc.ini file.

To create an ODBC System DSN on Windows

Navigate to Administrative Tools, Data Sources (ODBC) from the Start menu.
The ODBC Data Source Administrator dialog appears.
On the System DSN tab, click Add.
The Create New Data Source dialog appears.
Select SQL Server from the list and click Finish.
The Create a New Data Source to SQL Server dialog appears.
Enter CCA_CMDB as the DSN name and your database in the Server field and click Next.
The Create a New Data Source to SQL Server dialog continues.
Select the With SQL Server authentication using a login ID and password entered by the user option and enter the username and password of the database server and click Next.
The reports point to the server.
Select the database name (such as ccartm) and click Next.
Click Finish.
The ODBC Microsoft SQL Server Setup dialog appears.
Click Test Data Source.
A message appears indicating that the connection test finished successfully.

To confirm that the ODBC creation completed successfully, go to the ODBC Data Source Administrator dialog and locate the CCA_CMDB DSN name on the System DSN tab.