The PowerBuilder installable cloud apps support the following database types: SQL Anywhere (ODBC), PostgreSQL, SQL Server, MySQL, Informix, Oracle, and Adaptive Server Enterprise (ODBC). Please refer to Supported database types & versions for more information about the supported database types and versions.
A successful database connection in the installable cloud app will include at least two parts:
-
Part 1: Configuring the database connection for project compilation
The database caches created in the PowerBuilder IDE will not only be used by the project compilation (PowerServer Toolkit will connect to the target database when converting the DataWindows to C# models), but also used by the application runtime (the cache will be deployed to the PowerServer solution and then be used for the database connection at runtime).
-
Part 2: Configuring the database connection for app runtime
These database configurations (including downloading the database driver, mapping the transaction object etc.) will be used by the application runtime only.
This tutorial will provide step-by-step instructions to help you complete both parts.
Here are some information that you shall be noticed before reading this tutorial:
-
The database server to be connected should be configured properly.
-
PowerBuilder IDE is installed in a Windows 10 64-bit machine in this tutorial.
-
ODBC Data Source (64-bit) is used whenever ODBC is needed in this tutorial.
-
The IP address in this tutorial should be replaced with your actual IP address.
-
Be sure to complete both parts if you want to make the installable cloud app to connect with the database successfully.
-
When the PowerServer project is built and deployed in the PowerBuilder IDE, the database connection configured in the Database Configuration dialog box and the transaction-to-cache mappings will be deployed and stored in the PowerServer C# solution. You can manually change these settings in the PowerServer C# solution later.
