Database Server requirements

Appeon PowerServer 2020 can connect to any of the following database servers:

  • SAP SQL Anywhere 16.0 or 17.0 with SQL Anywhere .NET Data Provider driver

  • SAP Adaptive Server Enterprise (ASE) 12.5.x or 15.x with ASE native driver

  • IBM DB2 UDB 9.7 with IBM DB2 native driver

  • Informix 7.x, 8.x, 9.x, 10.x or 11.x with IBM Informix .NET Provider

  • Microsoft SQL Server 2012, 2014, 2016, 2017, or 2019 with MS SQL Server native driver

  • MySQL 5.5.x or 5.6.x with ADO.NET Data Provider driver

  • Oracle 11g, 12c, 18c, or 19c with Oracle native driver

  • PostgreSQL 9.2 or 12.x with PostgreSQL psqlODBC driver

Notes:

  1. SAP IQ database is supported in the PowerServer for J2EE edition only, not in the PowerServer for .NET edition.

  2. Usually, whether the database can be connected via a 32-bit driver and/or a 64-bit driver is determined by the database itself, so we recommend you make sure of this by checking the documents provided by the corresponding database vendor. If the database can be connected by both drivers, then you can decide which driver to install and use according to the PowerServer version: if you have installed a 32-bit PowerServer, then you should install and use the 32-bit driver, otherwise, install and use the 64-bit driver.