Content Delivery database prerequisites

This topic lists the required and supported software for all Content Delivery databases.

The prerequisites below apply to all Content Delivery databases:
  • The Content Data Store (which contains published content)
  • The State Store
  • The Experience Manager database
  • The Discovery Service database
  • The UGC database (part of the deprecated UGC feature)
Recommended database servers

SDL recommends one of the following database servers:

  • Oracle Server 19c (19.3) (Enterprise Edition)
  • Microsoft SQL Server 2017 (Standard Edition or Enterprise Edition)
  • Microsoft Azure SQL Database
  • AWS RDS-MSSQL 2017
Supported Microsoft SQL Server databases

Content Deliverysupports the following Microsoft SQL Server databases:

Supported:
  • Microsoft SQL Server 2017 (Standard Edition or Enterprise Edition)
Deprecated:
  • Microsoft SQL Server 2016 SP2 (Standard Edition or Enterprise Edition)
You can download the Service Pack for SQL Server from the following location:
Supported Oracle databases

Content Delivery supports Oracle Database 19c (19.3) (Enterprise Edition). Content Delivery also supports Oracle Database 18c (18.3).

Deprecated:
  • No Oracle database is deprecated

Note that unlike for the Content Manager Oracle database, no specific Oracle configuration is needed. The database works with default settings.

Supported Cloud-based databases

Content Delivery supports the following Cloud-based databases.

Supported:

  • Microsoft Azure SQL Database
  • AWS RDS-MSSQL 2017
Microsoft Azure SQL Database is supported with the following setup:
Setup itemType
Service tierGeneral Purpose
Compute tierProvisioned compute
HardwareIntel computer (or cloud equivalent)
DatabaseSingle database
BackupsAutomated backups

Deprecated: No Cloud-based databases are deprecated.

Supported Java versions
To run the installation or upgrade scripts, you must have Java installed on the system from which you run the Powershell scripts, and the JAVA_HOME environment variable must be set.
You require one of the following Java versions:
  • Supported:
    • AdoptOpenJDK OpenJDK 11 (18.9 LTS release) using the HotSpot JVM
    • Oracle JDK 11

    If you do not have Java 11 installed, the installer installs AdoptOpenJDK OpenJDK 11 (18.9 LTS release) using the HotSpot JVM.

  • Deprecated: no Java version is deprecated.

Download AdoptOpenJDK OpenJDK Java 11 from this location: https://adoptopenjdk.net

Cloud hosting
To host SDL Tridion Sites databases in the Cloud, you can use the following hosting services:
  • Amazon RDS (Relational Database Services) (for Microsoft SQL Server)
  • Microsoft Azure

The Content Delivery databases can reside on any operating system that supports the specific DBMS you choose to use. Refer to your database vendor documentation to learn which operating systems are supported.