The dbconfigs.json file contains database specific syntax related to formulas, data types, primary and foreign key discovery, datetime casting, and row limiting and range selection. This file is loaded by Exago during runtime and is required in order to provide database specific optimizations or to enable various advanced features.
NoteThis article references
<WebApp>,<Sched>as a placeholder for the application's install location and the Scheduler Service's install location, respectively.
This file is located in:
<WebApp>\Config\Other<Sched>\bin\Config\Otherof each Scheduler Service
These files must be kept consistent and any modifications made to the file directly should be duplicated in all other copies.
Properties and Usage
Most of the component properties and usage of the dbconfigs.json file are documented in the respective relevant section of the support site:
- Automatic Database Discovery
- Database Settings Formula Dictionary Section
- Security Precautions for Database Formulas
- Incremental Loading
Overriding dbconfigs Information
The base dbconfigs.json file is overwritten automatically by the Exago installer in order to provide the most up to date set of features. Any modifications made to the base copy of dbconfigs.json will be overwritten upon each new installation of Exago.
In order to customize this data and ensure that all changes persist between upgrades, a <WebApp>\Config\Other\dbconfigs.overrides.json file can be created and populated with the specific changes as of v2019.1.2+. The format of these changes must follow the same schema as the base file.
ImportantA copy of the
dbconfigs.overrides.jsonfile should also be added to the<Sched>\bin\Config\Otherdirectory of each Scheduler Service.
Examples
The following modifications added to the dbconfigs.overrides.json will persist throughout each new Exago install.
1. Modify the MSSQL 'false' formula to use 1 != 1 instead of 1 = 0:
{
"mssql": {
"FormulaDictionary" : {
"false" : [ "1 != 1" ]
}
}
}
2. Add specific DateTime format to Oracle databases:
{
"oracle": {
"DateFormat" : "YYYY-MM-DD HH:mm:ss"
}
}
3. Allow quotation marks in the schema name for PostgreSQL databases (requires v2021.1.8+):
{
"postgres": {
"UseDelimitersOnSchema" : true
}
}
Currently, properties cannot be deleted or removed via the dbconfigs.overrides.json file. If it is necessary to remove information from dbconfigs.json, it must be done directly within the base file.
CautionProperties that are removed directly from the
dbconfigs.jsonfile may be readded after each new Exago install. To prevent modifications to the basedbconfigs.jsonfrom being overwritten after each install, backup this file prior to installation.