Sample Foundation DBUtils JSON Configuration File - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

The following is an example of a custom Foundation DBUtils JSON configuration file. This sample illustrates all possible settings that can be specified in a Foundation DBUtils JSON configuration file.

Because of the number of configuration options and the sample data contained in the following example that may not be applicable to your solution, is not recommended that you copy this file for use in a production environment. Instead, it is recommended that you use the following sample JSON configuration file as a guide when creating a custom JSON configuration file for use with Foundation DBUtils.

Note:

In a Foundation DBUtils JSON configuration file, a backslash \ must be escaped by using another backslash. For example, C:\\DATA\\FoundationDBUtils\\.

{

"datasource": "DataSourceName",

"TablespaceOption": "Custom",

"Hyland.Logging": {

"Routes": {

"Console-Traces": {

"DisableIPAddressMasking": "true",

"minimum-level": "Information",

"maximum-level": "Critical",

"Console": ""

},

"DiagnosticConsole": {

"Http": "http://localhost:8989",

"minimum-level": "Trace",

"maximum-level": "Critical"

}

},

"AuditRoutes": {

"AuditLog": {

"Http": "http://localhost:9000"

}

}

},

"TablespaceOptions": {

"Single": {

"Description": "A single tablespace will be used."

},

"Default": {

"Description": "Dbspaces will be created with default values."

},

"Custom": {

"Description": "Dbspaces will be created with custom values. Define these values in the 'Definitions'.",

"Definitions": {

"dbspace1": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace2": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace3": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace4": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace5": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace6": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace7": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace8": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace9": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace10": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace2i": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace3i": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace6i": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

},

"dbspace9i": {

"size": "200",

"growth": "100",

"path": "C:\\DATA\\FoundationDBUtils\\"

}

}

}

},

"ProtectedSection": {

"UserInfo": {

"hsipassword": "password1",

"viewerpassword": "password2"

},

"ConnectionStrings": {

"DataSourceName": {

"ConnectionString": "Data Source=Serve001\\instance;database=TestDB;User Id=username;Password=password",

"providerName": "System.Data.SqlClient"

}

},

}

}