Client Tools Guide › File Menu › Configure Database Connection Details › Configure Direct Client Connection to Databases

Configure Direct Client Connection to Databases

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

Follow these steps:

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 GovernanceMinder 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 GovernanceMinder 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.