Configuration - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external - OnBase/Database-Reference-Guide/Foundation-23.1/Database-Reference-Guide/Installation/Database-Creation/Using-Foundation-DBUtils/Using-the-Foundation-DBUtils-User-Interface/Configuration - 2025-05-01

Database Reference Guide
Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

Navigate to the Configuration tab. If you have not edited the appsettings.json, a blank screen is displayed.

The other tabs are enabled after selecting a Data Source in the upper left corner of the window.

To create a new connection string:

  1. Click Add New. The Edit Connection String dialog box is displayed.
  2. Select a provider from the Database Provider drop-down list.
  3. You must enter different information based on which database provider you selected.

    • For information on creating SQL Server connection strings in the Foundation DBUtils user interface, see SQL Server Connection String.

    • For information on creating Oracle connection strings in the Foundation DBUtils user interface, see Oracle Connection String.

  4. To test the connection to the database using the connection string information you entered, click Test Connection.
  5. Click Save.
  6. To encrypt your connection string configuration information, click Protect Configuration. See Encryption for more information.
  7. Save your connection string information to the JSON configuration file. See Saving Connection strings to JSON Files for more information.

You can also edit or remove existing connection strings. To edit an existing connection string, select the string and click Edit. To remove an existing connection string, select the connection string and click Remove. Upon editing or removing a connection string, you must save the updated information to the JSON configuration file. See Saving Connection strings to JSON Files for more information.