PowerServer 2022 R2 Help
Setting up dynamic database connection for the app runtime

When there is no transaction-to-cache mapping configured for the installable cloud app (either statically or dynamically), the Transaction object properties can be used to connect with the database (just like the traditional client/server app). However, this is the lowest priority (and least recommended) approach, because these property values will be stored at the client app (in the script or in the application INI file) and then transferred between the client app and PowerServer when PowerServer establishes the database connection.

And unlike the traditional client/server app which directly connects with the database through a local driver, the installable cloud app relies on the PowerServer Web APIs and the .NET Core database provider in PowerServer to connect with the database. (Therefore, you will need to make sure PowerServer can access the specified database server.)

For example, the following properties can be sent to the PowerServer and used to connect with the database through the corresponding .NET Core native provider in PowerServer:

SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = "Appeon123!@#"
SQLCA.ServerName = "172.16.3.243"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='qa_datawindow'"

SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = "Appeon123!@#"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='172.16.3.243',PROVIDERSTRING='database=qa_datawindow'"

SQLCA.DBMS = "ADO.Net"
SQLCA.LogPass = "Appeon123!@#"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Namespace='System.Data.SqlClient',DataSource='172.16.3.243',Database='qa_datawindow'"

SQLCA.DBMS = "ORA Oracle"
SQLCA.LogPass = "appeon"
SQLCA.ServerName = "172.16.3.98/pdborcl" //servername must point to a remote instance; cannot be local.
SQLCA.LogId = "DBO"
SQLCA.AutoCommit = False
SQLCA.DBParm = "DisableBind=1"
SQLCA.DBParm = "TableCriteria='DBO',DisableBind=1"

The following properties can be sent to the PowerServer and used to connect with the database through the .NET Core ODBC provider in PowerServer:

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=PB Demo DB V2022;UID=dba;PWD=sql',driver='SqlAnywhere'"

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=en_ase1253;UID=en_ase1253;PWD=en_ase1253',driver='ase'"