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). This is the lowest priority (and least recommended) approach, because the 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 (or ODBC driver) 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 database 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 ODBC driver in PowerServer:
SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = False SQLCA.DBParm = "ConnectString='DSN=PB Demo DB V2022;UID=dba;PWD=sql',driver='SqlAnywhere'"
