DNA User Guide › File Menu › General Settings › Configure SQL Database Connection Details

Configure SQL Database Connection Details

Use the SQL Connectivity tab to set Database Connection details and Parameters for use when you run the Open from Database and Save to Database functions. If the Database connection details change, or if you want to use data located on a different database, edit the connection details.

To configure SQL database connection details

1. In a CA RCM client application window, click File, General Settings.

   The Settings dialog appears.

2. Click the SQL Connectivity tab.
3. Choose a SQL connectivity mode:
   • In implementations that include a CA RCM server that also interacts with the CA RCM databases, select the Request SQL Credentials from a server option.
   • In implementations without a CA RCM server, select the Use static SQL credentials option.

   Enter values in the fields as indicated.

   Note: If you select the Request SQL Credentials from a Server option, you need to provide the credentials for a CA RCM portal administrator and the CA RCM database user.

4. (Optional) Select the Bulk Insert option to write data to a temporary SQL file. This option speeds the save process.
5. Click Apply.