In BusinessObjects Enterprise, a database can be defined as a data repository that organizes a collection of information into structures (tables) for rapid search and information retrieval.
Databases allow tables to be grouped together into collections of logically related tables that are named tablespaces. Tables are grouped into tablespaces within a database system in the same way that files are grouped into a directory within a file system.
Note: This documentation uses the terms "tablespace" and "database" interchangeably.
The following database systems are supported for the Central Management System (CMS) database:
See the BusinessObjects Enterprise Supported Platforms documents on the CA Business Intelligence DVD for a full list of database systems that are supported for each component of BusinessObjects Enterprise.
You can use any database system with BusinessObjects Enterprise as long as the CA Technologies product implementing BusinessObjects Enterprise supports the database system (see your CA Technologies product documentation). If you do not have a database system ready, the BusinessObjects Enterprise installer can create and configure a SQL Anywhere database system as part of the installation process.
Notes:
BusinessObjects Enterprise uses several databases to store internal system information. They can be configured as several tablespaces within a single database system, or as tablespaces distributed across several database systems.
The following table details the different database or tablespace repositories that BusinessObjects Enterprise uses.
|
Repository |
Description |
Mandatory for Installation? |
|---|---|---|
|
CMS |
Main repository that stores BusinessObjects Enterprise user, group, security, content, and service information. If you do not have a CMS database from a previous installation, objects in this database are initialized by the BusinessObjects Enterprise installer. |
Yes |
|
Auditing |
Activity tracking repository that allows administrators to view system usage information, such as the number of report generation or login events. Auditing can be enabled and configured during the installation process. |
No |
BusinessObjects Enterprise scripts require database user privileges that permit the creation and deletion of database objects, including tables, indexes, and temporary data. Rather than assign administrative privileges to the account that BusinessObjects Enterprise uses, this table summarizes the required privileges for each supported database system.
|
Database |
Required Account or Role Privileges |
|---|---|
|
IBM DB/2 |
User with Connect to database, Create tables, and Create schemas implicitly enabled |
|
Oracle Database |
User with the following privileges enabled:
Alternatively, a user with the CONNECT and RESOURCE roles enabled, and the Admin Option setting disabled for both roles. |
|
SQL Anywhere |
User with the following privileges enabled:
|
|
MySQL |
Default database owner (DBO) account permissions |
|
Microsoft SQL Server |
Default database owner (DBO) account permissions |
|
Sybase ASE |
Default database owner (DBO) account permissions |
Databases can require specific configuration to function best with BusinessObjects Enterprise. The following table provides a list of additional configuration settings.
|
Database |
Additional Required Settings |
|---|---|
|
IBM DB/2 |
DB2CODEPAGE=1208 |
|
Oracle |
NLS_LANG must be set to a valid UTF-8 setting, such as AMERICAN_AMERICA.WE8MSWIN1252 or AMERICAN_AMERICA.AL32UTF8. The FORCE setting must be enabled. |
|
Sybase |
LC_ALL must be set to a valid locale, as found in the configuration file SYBASE_HOME/locales/locales.dat. |
|
Copyright © 2012 CA.
All rights reserved.
|
|