Table of Contents
Before you can build and deploy a PowerServer project, you MUST configure the database connection in the Database Configuration window (from the PowerServer project painter > Web APIs tab > Database Configuration button).
Database connection is required 1) when converting the PowerBuilder DataWindow objects to C# models during the deployment process; and 2) when accessing data from the database at application runtime. The database information (including the cache settings and the transaction-to-cache mappings) will be deployed to the ServerAPIs project in the PowerServer C# solution.
This section talks about creating a database connection cache and mapping it with the transaction object in the Database Configuration window. (You may want to consider the other database connection methods as discussed in Working with Database Connections).
Tutorial 13: Connecting to the Database provides step-by-step instructions for how to configure the database connection for every supported database type.
Note that you only need to map the transaction objects that already exist in the PowerBuilder application.