Database Server requirements

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

  • SAP SQL Anywhere 8.0.2, 9.0, or 10.0.1 with ODBC Driver, or SQL Anywhere 11.0, 12.0, 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

  • SAP HANA 1.00.36 with ODBC 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 2000 SP4, 2005 SP1, 2008, 2012, 2014, or 2016 with MS SQL Server native driver

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

  • Oracle 8i, 9i, 10g, 11g or 12c with Oracle native driver

  • Teradata 13.1.0.0 with Teradata .NET Data Provider driver

  • PostgreSQL 9.2 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.