Guidelines for creating the content store
The content store is a database that is used to store global configuration data, global settings (such as the language and currency formats shown in the user interface), connections to data sources, and product-specific content. You must use a supported enterprise-level database as the content store in a production environment.
Design models and log files are not stored in the content store.
You must create the content store before you can use your IBM® Cognos® Analytics product. If you use the Easy (previously Ready to Run!) option, Informix is installed and configured to use as your content store.
If you are using IBM Db2® for your content store, you can generate a DDL to allow your database administrator to create a Db2 database suitable for the content store. For more information, see Generating a script file to create a database for an IBM Db2 content store.
Database properties
You must create the content store database using one of the databases listed in the following table.
The following table shows the character encoding and protocol that is used by the different types of databases.
Database |
Character encoding |
Protocol |
---|---|---|
Db2 |
UTF-8 |
TCP/IP |
Oracle |
AL32UTF8 or AL32UTF16 |
TCP/IP |
Microsoft SQL Server |
UTF-8 or UTF-16 |
TCP/IP |
Informix® |
UTF-8 |
TCP/IP |
PostgreSQL |
UTF-8 SQL_ASCII LATIN1 (ISO 8859-1) LATIN9 (ISO 8859-15) WIN1252 |
PostgreSQL Protocol v3.0 PostgreSQL Protocol v2.0 |
Collation sequence
Cognos Analytics uses a single sort order that specifies the rules used by the database to interpret, collect, compare, and present character data. For example, a sort order defines whether the letter A is less than, equal to, or greater than the letter B; whether the collation is case sensitive; and whether the collation is accent sensitive. For more information about collation and collation sequences, see the ICU - International Components for Unicode web site (http://site.icu-project.org/), select the User Guide, and search for Collation.