We will need to create a database connection cache in the Database page.
Step 1: In the PowerServer project painter, select the Database page > Basic tab.
Step 2: Select SQL Anywhere (ODBC) from the Provider list.
Step 3: Specify "sales_new" (or any text you like) in the Cache name field.
Step 4: Select PB Demo DB V2022R2 as the data source.
Step 5: Specify "dba" as the user name and "sql" as the password.
Step 4: In the Database driver option group, click the View License Terms link to view the license for the database driver, and then select the option "I have read and agree to the license ...".
Step 5: Click Test Connection to make sure the database can be connected successfully.
The cache will be automatically mapped to the SQLCA transaction object. (You can verify this in the Advanced tab).
