The database connections (including the cache, application settings, and transaction-to-cache mappings) can be stored in the static file or in the database, and can be managed using the PowerServer Management APIs:
-
By default, the database connections are stored in the static file (in the solution > UserExtensions project > AppConfig folder > Application.json or Applications.[DBConnectionProfile].json file).
With the static file approach, PowerServer Management APIs can only get the connection and cannot modify, add, or delete the connection.
-
The database connections can also be stored in the database (you will need to configure this first by following the Storing database connections in the database section).
With the database approach, PowerServer Management APIs can get, add, modify, and delete the connection.
The following sections will show you how to store the database connections in the database, and then manage them using the PowerServer Management APIs.
