Content Delivery database prerequisites
This topic lists the required and supported software for all Content Delivery databases.
Oracle or SQL Server prerequisites
- 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
-
SDL 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 2017
- Supported Microsoft SQL Server databases
-
Content Deliverysupports 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)
- 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 item Type Service tier General Purpose Compute tier Provisioned compute Hardware Intel computer (or cloud equivalent) Database Single database Backups Automated 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_HOMEenvironment variable must be set.
- 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.
Elasticsearch prerequisites
The prerequisites below apply to the Content Delivery search database and to the Experience Optimization personalization database .
- Required database server
- SDL Tridion Sites requires the Elasticsearch 7.7 database.
- Required plugins
- SDL Tridion Sites additionally requires the following Elasticsearch plugins to be installed:
- Ingest Attachment Processor Plugin, documented here: https://www.elastic.co/guide/en/elasticsearch/plugins/current/ingest-attachment.html
- ICU Analysis Plugin, documented here: https://www.elastic.co/guide/en/elasticsearch/plugins/current/analysis-icu.html