After you create the database connection cache in the PowerBuilder IDE in Part 1: Configuring database connection for project compilation (the cache will also be deployed to the PowerServer C# solution and used for database connection at runtime), you are just a few steps away from making the database connection to work in the installable cloud application:
-
Step 1: Select and agree to download the database native .NET Core driver to the PowerServer C# solution. See Downloading the database driver.
You will make this section in the PowerBuilder IDE before the PowerServer solution is generated, so that when the PowerServer solution is loaded, it will automatically download the required driver.
-
Step 2: Map the transaction object with the database cache. See Mapping the transaction object.
You will do the mapping in the PowerBuilder IDE. But you will have a chance to modify them in the PowerServer solution later.
-
Step 3: Configure the ODBC connection at the server when using the SQL Anywhere or ASE database. See Configuring ODBC for SQL Anywhere and ASE.
The ODBC connection at the server is only required when using the SQL Anywhere or ASE database.
Step 1 & 2 apply to all supported database types, which means, no matter which database is used in your application, you will need to complete both steps.
