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. 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.
Like the PowerBuilder traditional client/server app, the connection settings are stored at the client; but unlike the PowerBuilder 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 = "Appeontest" SQLCA.ServerName = "172.16.3.243" SQLCA.LogId = "sa" SQLCA.AutoCommit = False SQLCA.DBParm = "Database='qa_datawindow'"
SQLCA.DBMS = "OLE DB" SQLCA.LogPass = "Appeontest" 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 = "Appeontest" 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 V2025;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'"
