Documentation Center

Content Delivery database prerequisites

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

Oracle or SQL Server prerequisites

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

RWS recommends one of the following database servers:

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

Content Delivery supports the following Microsoft SQL Server databases:

Supported:
  • Microsoft SQL Server 2019 (Standard Edition or Enterprise Edition)
Deprecated:
  • Microsoft SQL Server 2017 (Standard Edition or Enterprise Edition)
Supported Oracle databases
Content Delivery supports the following:
  • Oracle Database 19c (19.3) (Enterprise Edition)
Deprecated:
  • Oracle Database 18c (18.3)

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 2019
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:
  • AWS RDS-MSSQL 2017
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:
    • Eclipse Temurin OpenJDK 11 (formerly known as 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 Eclipse Temurin OpenJDK 11 (18.9 LTS release) using the HotSpot JVM.

  • Deprecated: no Java version is deprecated.

Download Eclipse Temurin OpenJDK Java 11 from this location: https://adoptium.net/

Cloud hosting
To host 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.

Elasticsearch prerequisites

The prerequisites below apply to the Content Delivery search database and to the Experience Optimization personalization database .

Required database server
Tridion Sites requires Elasticsearch version 7.10 (on-premises version or Cloud version).
Required plugins
Tridion Sites additionally requires the following Elasticsearch plugins to be installed:

Powershell installation script requirements

To run Powershell database scripts, you require a machine that meets the following requirements (any Tridion Sites 9.6 server machine running Windows meets these requirements):
PrerequisiteDescription
Powershell softwarePowershell 5.0 or higher
Operating systemAn operating system that supports Powershell of 5.0 or higher and any client software for the database you intend to install.
Environment variablesFor Oracle databases where you have defined a Net Service Name for each database in a tnsnames.ora file, you have also defined a TNS_ADMIN environment variable. Set it to the directory where tnsnames.ora resides.
Microsoft .NET FrameworkMicrosoft .NET Framework 4.8 or higher.
Database client softwareFor Oracle databases, Oracle Services for Microsoft Transaction Server (ORAMTS) and Oracle Data Provider for .NET (ODP.NET) are both installed. For maintenance, configuration and debugging purposes, RWS recommends that you also have the Oracle SQL Developer PL/SQL IDE (or SQL*Plus) installed, and Oracle Net.
JavaPowershell database scripts run Liquibase scripts, which require either Eclipse Temurin OpenJDK 11 (18.9 LTS release) using the HotSpot JVM (available for download at https://adoptium.net), or Oracle JDK 11. Make sure that the JAVA_HOME environment variable is set.
SecurityYou need to be logged in as a user with sufficient security clearance. For example, to run a script that installs a database, you must be logged in as a user with rights to create that database.