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:- Service Pack 2 for SQL Server 2012: http://www.microsoft.com/en-us/download/details.aspx?id=43340
- Service Pack 1 for SQL Server 2012: http://www.microsoft.com/en-us/download/details.aspx?id=35575
- Service Pack 3 for SQL Server 2008 R2: http://www.microsoft.com/en-us/download/details.aspx?id=44271
- Service Pack 2 for SQL Server 2008 R2: http://www.microsoft.com/en-us/download/details.aspx?id=30437
- 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 version Dropped in next version release? IBM DB2 9.7 Definitely
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.