Content Delivery database prerequisites
This topic lists the required and supported software for 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
- Recommended database servers
-
SDL recommends one of the following database servers:
- Oracle Server 12.1.0.2 (Enterprise Edition)
- Microsoft SQL Server 2016 SP1 (Standard Edition or Enterprise Edition)
- Microsoft Azure SQL Database
- AWS RDS-MSSQL 2016
- Supported Microsoft SQL Server databases
-
Content Delivery supports the following Microsoft SQL Server databases:
Supported:- SQL Server 2016 SP1 (Standard Edition or Enterprise Edition)
- SQL Server 2014 SP2 (Standard Edition or Enterprise Edition)
Deprecated:- SQL Server 2012 SP3 (Standard Edition or Enterprise Edition)
You can download Service Packs for SQL Server from the following locations:- Service Pack 3 for SQL Server 2012: https://www.microsoft.com/en-us/download/details.aspx?id=49996
- Service Pack 2 for SQL Server 2014: https://www.microsoft.com/en-us/download/details.aspx?id=53168
- Supported Oracle databases
-
Content Delivery supports the following Oracle databases:
Supported:
- Oracle Database 12c patch set 12.1.0.2 (Enterprise Edition)
- Oracle Database 11g Release 2 patch set 11.2.0.4 (Enterprise Edition)
Deprecated: No Oracle database are 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
AWS RDS-MSSQL 2016
Deprecated:AWS RDS-MSSQL 2012
- Cloud hosting
-
To host SDL Web 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.
Licenses
Your Content Delivery system requires a license. To obtain a license, contact Customer Support.