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 version Dropped in next version release? SQL Server 2005 SP3 Definitely SQL Server 2005 SP4 Probably SQL Server 2008 R2 Definitely - 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 version Dropped in next version release? Oracle Database 11g Release 2, patch set 11.2.0.1 Definitely 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 CRASHPatch 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 BITPatch 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 version Dropped in next version release? IBM DB2 9.7 Under 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.
- 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.