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 prerequisites

SDL recommends one of the following database servers:

  • Oracle Server 11.2.0.2
  • Microsoft SQL Server 2008 R2 SP2
Supported Microsoft SQL Server databases

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

Supported:
  • SQL Server 2008 R2 SP2
  • SQL Server 2008 R2 SP1

Deprecated:

SQL Server versionDropped in next version release?
SQL Server 2005 SP3Definitely
SQL Server 2005 SP4Probably
SQL Server 2008 R2Definitely
Supported Oracle databases

The Content Data Store supports the following Oracle databases:

Supported:

  • Oracle Database 10g Release 2 patch set 10.2.0.5
  • Oracle Database 11g Release 2 patch set 11.2.0.2

Deprecated:

Oracle versionDropped in next version release?
Oracle Database 11g Release 2, patch set 11.2.0.1Definitely
Please note:
  • For Oracle 10.2.0.2, install Oracle 10.2.0.2 and apply the 10.2.0.5 patch set.
  • For Oracle 11.2.0.1, apply one of the following (publicly available) Oracle patches:

    Linux

    On Linux, install the following patches:

    • Patch 10401379: ODP.NET APPL. CRASHES IN KOCTXED() - WHICH IS CALLING ITSELF UNTILL CRASH
    • Patch 9053676: APPSST GSI 11G : ORA-07445: [KKQVSEARCHLOGOPN() [PC:0X104AAA664]
    Windows

    On Windows, install the following patches:

    • Patch 10352691: ORACLE 11G 11.2.0.1 PATCH 9 BUG FOR 32 BIT
    • Patch 10352692: ORACLE 11G 11.2.0.1 PATCH 9 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64)
Supported IBM DB2 databases

The Content Data Store supports the following IBM DB2 database:

Deprecated:

DB2 versionDropped in next version release?
IBM DB2 9.7Under review

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.