PowerServer 2025 R2 Help
New Features

PowerServer 2025 R2 supports configuring and overriding database connection settings through environment variables, aligning with ASP.NET Core configuration best practices.

This enhancement greatly improves deployment flexibility in Docker, Kubernetes, and other containerized or cloud environments, because you can configure database parameters through environment variables, which will override the values in the Applications.json file at runtime (in previous versions, you have to manually modify the values in the Applications.json file under the "AppConfig" folder).

For example, to change the database login user from "dba" to "user" at runtime, you can create an environment variable like this:

Applications.json:

{
......
  "Connections": {
    "Default": {
      "sales": {
        "ConnectionType": "Odbc",
        "OdbcName": "PB Demo DB V2025R2",
        "OdbcDriver": "SqlAnywhere",
        "UserID": "dba",
        "Password": "eyJQYXlsb2FkIMlhPQT09In0=",
        "CommandTimeout": 30,
        "SecurityOptions": null,
        "OtherOptions": null,
        "DynamicConnection": false
      }
    }
  }
}