Database Server

The installable cloud apps can work with the following databases:

  • Oracle 12c, 18c, or 19c

  • PostgreSQL 11.3, 12, or 13

  • SQL Server 2016, 2017, or 2019

  • SQL Anywhere (ODBC) 16 (16.0.0.2043 or later) or 17

    If SQL Anywhere is on a different machine from PowerBuilder, make sure to enable the connection pooling setting in the ODBC driver. Connection pooling is enabled by default if SQL Anywhere is on the same machine as PowerBuilder.

  • ASE (ODBC) 16.0

    Different from the PowerBuilder runtime environment where the ASE database is connected using the native driver, ASE databases can only be connected using the ODBC driver in the PowerServer runtime environment. This driver change has caused some differences. See ASE database for more details.

  • MySQL 5.6, 5.7, or 8.0

  • Informix 12.x or 14 (Beta feature) *

    * Beta means the feature has not been fully tested, has known bugs, and does not receive standard technical support. We will collect reported bugs and try to address in a future version.

Note

SQL Anywhere and ASE databases can only be connected through the ODBC driver. The other databases are connected using the native driver for .NET Core.