Database
Prerequisites
Rebooting the application server service is required when switching or upgrading from one database platform to another.
Unicode character sets are supported.
Supported database platforms
Note that the future release numbers are subject to change in the course of time.Database platforms | Notes |
|---|---|
Oracle • Supported editions SE1, SE, EE and PE. • XE is not supported. | |
 During a Planon database upgrade, the Oracle Enterprise Edition database option Basic table compression is not supported, as this option makes it impossible to add columns to tables including default values. | |
Oracle 19 Oracle 18 | • Only supports datapump exports. • Transparent Database Encryption is supported. Note that this is only true for Oracle EE. • The use of Pluggable Databases (PDBs) is supported. • Oracle locator must be installed. |
Microsoft SQL Server • All editions of a specific version are supported. • Setting the containment type to Partial is giving issues and is currently not supported. | |
Microsoft SQL Server: all versions Microsoft SQL 2016: as service pack 0 is known to give issues, only service pack 1 and higher are supported. | • SQL Server transparent data encryption is supported. Note that this is only true for the Enterprise Editions of SQL Server. • SQL-based and Windows-based authentication are supported. |