Modifying the JSON Configuration File - System Administration - On-Premises - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Premier - Essential

On-Premises System Administration

Platform
OnBase
Product
System Administration - On-Premises
Release
Foundation 22.1
License
Standard
Premier
Essential

Prior to running Foundation DBUtils, you can configure database connection information by editing the corresponding appsettings.json file. By default, this file is stored in the same directory as the application. You can also create a custom JSON configuration file.

Note the following:

  • In order for the options in a custom JSON configuration file to be respected, you must apply the --configoverride switch when running the Foundation DBUtils application. See Command Line Switches for Foundation DBUtils for more information.

  • Any options specified in a custom JSON configuration file override the corresponding option specifications in the default appsettings.json configuration file.

  • Any options specified by applying command line switches override the corresponding option specifications in any default or custom JSON configuration files. See Command Line Switches for Foundation DBUtils for more information.

To connect the Foundation DBUtils application to your database, configure the following settings in the appsettings.json file, or add these settings to a custom JSON configuration file:

Settings

Description

datasource

A unique name, defined by the user, to identify the connection string used to connect to the database.

Note the following.

  • This identifying name may be different from the name of the actual database.

  • If this setting is not specified in the default appsettings.json file, you must specify it in an alternative JSON file or using a command line switch.

ConnectionStrings | [DataSourceName] | ConnectionString

The connection string used to connect to the database.

Note the following:

  • When specifying a SQL Server and instance in a Foundation DBUtils JSON configuration file, you must include two backslashes \\ between the server and instance.

  • If this setting is not specified in the default appsettings.json file, it must be specified in an alternative JSON file or using a command line switch.

ConnectionStrings | [DataSourceName] | providerName

The data provider type used for the database. Only SQL Server and Oracle data providers can be used to connect to the OnBase database. Use one of the following:

  • For a SQL Server database:

    "System.Data.SqlClient"

  • For an Oracle database:

    "Oracle.ManagedDataAccess.Client"

Note:

If this setting is not specified in the default appsettings.json file, you must specify it in an alternative JSON file or using a command line switch.