The PowerBuilder installable cloud apps support the following database types: DB2, Informix, MySQL, Oracle, PostgreSQL, SQL Server (including Azure SQL), SQL Anywhere (ODBC), and Adaptive Server Enterprise (ODBC). Please refer to Supported database types & versions for more information about the supported database types and versions.
For an installable cloud app, database connections are required by both the PowerBuilder IDE and the PowerServer.
-
PowerBuilder IDE requires to use the database connection for project compilation
The cache is used by PowerServer Toolkit to convert the DataWindows to C# models correctly (PowerServer Toolkit will connect to the actual database to get the schema information for generating the models).
-
PowerServer requires to use the database connection at application runtime
Besides the cache, you will also need to map the transaction object with the cache, so that the application can connect with the database successfully at runtime.
You can create the cache and the transaction-to-cache mapping in the PowerBuilder IDE and deploy them to PowerServer during the project compilation (you can also modify them directly in PowerServer later).
Note: When using the SQL Anywhere or ASE database, you will also need to configure the ODBC connection at the server.
This tutorial will provide step-by-step instructions to configure the database connection required by both PowerBuilder IDE and PowerServer.
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.
-
The IP address in this tutorial should be replaced with your actual IP address.
-
When the PowerServer project is built and deployed in the PowerBuilder IDE, the database cache configured in the Database Configuration dialog box and the transaction-to-cache mappings will be deployed and stored in the PowerServer Web APIs. You can manually change these settings in the PowerServer Web APIs later.
-
The SQL Anywhere database and the ASE database can be connected using the ODBC driver only for the installable cloud app, therefore, you will need to install the ODBC driver and create the ODBC data source first in the server hosting PowerServer.
-
For ODBC connections, only 64-bit ODBC data source is supported (32-bit is NOT supported).
