Configuring application database connectivity

Perform the following database configurations for all prospective PowerBuilder applications that will be deployed with PowerServer Toolkit:

  1. Set up the database used by the PowerBuilder application to interface with PowerServer and the JDBC driver. Refer to the documentation from appropriate database vendors for instructions.

  2. Create the data source in PowerServer. Appeon provides systematic instructions for certified database systems. Refer to the section called “Setting up PowerServer data sources” in PowerServer Configuration Guide for .NET or in PowerServer Configuration Guide for J2EE for more information.

  3. Map the transaction object in the target PowerBuilder application to the newly created data source for the prospective Web or mobile application. You can either dynamically set up the mapping via PowerScript following the instructions in the section called “Dynamic transaction object to data source mapping” in PowerServer Configuration Guide for .NET or in PowerServer Configuration Guide for J2EE or establish the mapping statically in PowerServer Toolkit or AEM.