You can use the PowerServer Management APIs to manage the database connections (including the cache, application settings, and transaction-to-cache mappings).
-
If the database connection is stored in the static file (Application.json or Applications.[DBConnectionProfile].json), you can only get the connection via the following APIs:
-
To get the application and transaction mapping
-
To get the cache and cache group
/api/Connection/LoadOne/{cacheGroup}/{cacheName}
-
-
If the database connection is stored in the database, you can get, add, modify, and delete the connection via the following APIs:
-
To get, add, modify, and delete the application and transaction mapping
/api/Application/LoadOne/{appName}
/api/Application/Remove/{appName}
/api/Application/AddTransactionMapping/{appName}/{transName}
/api/Application/EditTransactionMapping/{appName}/{transName}
/api/Application/RemoveTransactionMapping/{appName}/{transName}
-
To get, add, modify, and delete the cache and cache group
/api/Connection/LoadOne/{cacheGroup}/{cacheName}
/api/Connection/LoadGroup/{cacheGroup}
/api/Connection/AddOne/{cacheGroup}
/api/Connection/RemoveOne/{cacheGroup}/{cacheName}
/api/Connection/AddGroup/{cacheGroup}/{copyFrom}
/api/Connection/RemoveGroup/{cacheGroup}
-
