Installation Guide › Installing Client Applications › Configure Client Applications After Installation › Configure Direct Client Connection to Databases

Configure Direct Client Connection to Databases

In implementations that do not include a CA RCM server, configure your client applications to work directly with the database server.

To configure direct client connection to databases

1. Verify that the database server is running.
2. Run the Data Management application.

   The Enter Server Credentials dialog appears.

3. Click Cancel. Then click File, General Settings from the main menu.

   The Data Management Settings dialog appears.

4. Click the SQL Connectivity tab.
5. Select the Use Static SQL Credentials option.
6. Configure the following fields and options:

   SQL Server Type

   Specifies whether a Microsoft SQL Server or Oracle Server hosts CA RCM databases.

   Server

   Defines the target on the database server:

   • For a Microsoft SQL Server, this field specifies the host name of the database server instance.
   • For an Oracle database server, this field specifies the Oracle service name, as defined in the tnsnames.ora file in the Oracle service directory.

   Database

   (Microsoft SQL Server only) Defines the main CA RCM database.

   Username, Password

   Define the login credentials of the database user or schema owner.

   Windows Authentication

   (Microsoft SQL Server only) When the database user is mapped to a general Windows user account in the environment, specifies whether the Windows user is used to log in to the database server.

7. Click Apply.

   A message confirming SQL connectivity appears. The application is now connected to the database.

8. Close the dialog.
9. Repeat this procedure in the DNA application.

   The client applications are configured and ready for use.