Documentation Center

Content Data Store prerequisites

This topic lists the required and supported software for the Content Data Store where a relational database is used to store published content.

Recommended database servers

SDL recommends one of the following database servers:

  • Oracle Server 12.1.0.2
  • Microsoft SQL Server 2012 SP2
Supported Microsoft SQL Server databases

The Content Data Store supports the following Microsoft SQL Server databases:

Supported:
  • Microsoft SQL Server 2012 SP2
  • Microsoft SQL Server 2008 R2 SP3
Deprecated:
  • Microsoft SQL Server 2012 SP1
  • Microsoft SQL Server 2008 R2 SP2
The Service Packs can be downloaded from the following locations:
Supported Oracle databases

The Content Data Store supports the following Oracle databases:

Supported:

  • Oracle Database 12c patch set 12.1.0.2

  • Oracle Database 11g Release 2 patch set 11.2.0.4

Deprecated:
  • Oracle Database 12c patch set 12.1.0.1

  • Oracle Database 10g Release 2 patch set 10.2.0.5

  • Oracle Database 11g Release 2 patch set 11.2.0.3 with one of the following patches applied:

    • For Linux/UNIX systems: PSU 11.2.0.3.2
    • For Windows systems: 11.2.0.3 Patch 2 or higher (for Windows)

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

Supported IBM DB2 databases

The Content Data Store supports the following IBM DB2 database:

Deprecated:

DB2 versionDropped in next version release?
IBM DB2 9.7Definitely

The Content Data Store 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.

You can also store published content on the local file system. However, the following Content Delivery features require a database:
  • Dynamically assembling content onto a Web page through querying and filtering.
  • Profiling & Personalization which enables you to track visitors and offer them personalized content.
  • Intelligent navigation (taxonomies).
  • Outbound E-mail (Tracking database) and Audience Manager (Subscription database)—note that IBM DB2 is not supported.
  • User-Generated Content (UGC)—note that IBM DB2 is not supported.

Licenses

If you use a relational database as a Content Data Store, your Content Delivery system requires a license. To obtain a license, contact Customer Support.