For PostgreSQL, SQL Server, MySQL, Informix, and Oracle databases that PowerServer can directly connect with (through their native .NET Core driver), there is no need to install any other client or tool in the server hosting PowerServer. The native .NET Core driver is automatically downloaded to the PowerServer solution after you configure properly in the PowerBuilder IDE (see Downloading the database driver for details).
For SQL Anywhere and Adaptive Server Enterprise databases that PowerServer connects with through the ODBC data source, besides the .NET Core driver (see Downloading the database driver for details), you will also need to install the ODBC driver and create the ODBC data source first in the server hosting PowerServer (see the following section for details).
The SQL Anywhere database and the Adaptive Server Enterprise (ASE) database can be connected using the ODBC driver only for the PowerBuilder 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 how to install the ODBC driver and create the ODBC data source for SQL Anywhere, refer to Configuring ODBC for SQL Anywhere.
For how to install the ODBC driver and create the ODBC data source for ASE, refer to Configuring ODBC for ASE.
The database caches and the transaction-to-cache mappings will be deployed from the PowerBuilder IDE to the PowerServer C# solution and used by PowerServer to establish the database connection at runtime. You can modify them in the PowerServer solution by following instructions in Managing database caches in the PowerServer solution and Managing transaction-to-cache mappings in the PowerServer solution.
