Configure the database connection

Before you can build and deploy a PowerServer project, you MUST configure the database connection in the Database page of the PowerServer project painter.

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 project painter > Database page. (You may want to consider the other database connection methods as discussed in Working with Database Connections).

Tutorial: 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 exist in the PowerBuilder application.