The steps for configuring the database for a PowerServer-deployed application are the same as the steps for configuring the database for a PowerBuilder application. However, the way the database server is accessed is different: a PowerBuilder application directly accesses the database server via transaction object(s), while a PowerServer-deployed application accesses the database server via PowerServer data sources.
This chapter describes how to enable a deployed application to access its database. Two key tasks are involved:
-
Setting up communication between the database server and PowerServer. This refers to setting up PowerServer data sources.
-
Setting up communication between the deployed application and PowerServer. This refers to setting up the mapping between the application transaction objects and PowerServer data sources.
Some advanced configurations are also related to database connection setup (for example, database auditing). This chapter outlines common techniques for handling such configurations in the PowerServer environment.