Configuring the database connection

The PowerServer Web APIs will connect with the database at runtime. Therefore, you will need to double check that the database connection points to the correct database.

After the PowerServer Web API is installed to the server, you can check and change the database connection settings in the compiled Web API > AppConfig folder > Applications.json or Applications.[DBConnectionProfile].json file.

In the Applications.json (or Applications.[DBConnectionProfile].json) file, locate the "Applications" block > [appname] > "CloudTransactions". This is where the transaction-to-cache mapping(s) is stored. See Managing transaction-to-cache mappings in PowerServer for more information.

In the Applications.json (or Applications.[DBConnectionProfile].json) file, locate the "Connections" block. This is where the cache(s) is stored. See Managing database caches in PowerServer for more information.

Note that the database login password can be an encrypted value (encrypted by the CustomizeDeploy.dll tool).