Planon Live : Database
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
The following image depicts the support for the various 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.
Oracle 12c (12.1, 12.2)
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.
Oracle 11.2 (11.2.0.3.0 and 11.2.0.4)
Only supports datapump exports.
Transparent Database Encryption is supported. Note that this is only true for Oracle EE.
Oracle locator must be installed.
Oracle 11.1 (11.1.0.7.0 and later)
Only supports datapump exports.
Oracle locator must be installed.
Microsoft SQL Server
All editions of Microsoft SQL Server are supported.
Setting the containment type to Partial is giving issues and is currently not supported.
Microsoft SQL Server 2017, Microsoft SQL Server 2016, Microsoft SQL Server 2014.
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.
Microsoft SQL Server: all versions
READ_COMMITTED_SNAPSHOT must be on, see the Installation guide for details: