Reports Integration Guide › Deployment › CA Business Intelligence › CA Business Intelligence Requirements

CA Business Intelligence Requirements

Note the following requirements before you install CA Business Intelligence.

BusinessObjects Enterprise

For the current CA DLP release, your reports server must be running BusinessObjects XI 3.1 SP4.

InfoView Browser

In BusinessObjects XI 3.1 SP4, InfoView is not supported in Microsoft Internet Explorer 9.

CA Business Intelligence

Compatibility with CA products is provided through CA Business Intelligence. CA Business Intelligence is a wrapper that includes a BusinessObjects Enterprise installation.

The current CA DLP release supports CA Business Intelligence 3.2. When you install CA Business Intelligence 3.2 on your reports server, BusinessObjects XI 3.1 SP3 and its InfoView web portal also get installed.

Important! You must also apply the SP4 patch for BusinessObjects XI 3.1!

CA Business Intelligence version details are in version.txt. Find this file in:

• The \Disk1\cabi\biek subfolder on your CA Business Intelligence distribution media.
• The \CommonReporting3 subfolder below the CA Business Intelligence installation folder.

For full details, see the CA Business Intelligence Implementation Guide, included in your CA Business Intelligence distribution image.

Reports Server host computer

Note the following requirements for your reports server.

Operating System

CA DLP integration with CA Business Intelligence has been tested on Windows Server 2003.

CA also supports CA Business Intelligence on the following Windows systems:

• Windows Server 2003 SP2, 32-bit and 64-bit editions
• Windows Server 2003 R2 SP2, 32-bit and 64-bit editions
• Windows Server 2008, including SP2, 32-bit and 64-bit editions
• Windows Server 2008 R2, 64-bit edition only

Note: The current CA DLP release does not support integration with a CA Business Intelligence deployment hosted on a non-Windows system.

Windows KB925336 Patch

(Needed for Windows Server 2003 SP2 only)

The CA Business Intelligence distribution image is very large. Consequently, you need to install the KB925336 patch onto your target reports server. This patch fixes an error message when installing very large Windows Installer packages. The CA Business Intelligence installer prompts for this patch if it is not already installed.

RAM

2GB RAM.

Note: Although CA Business Intelligence is supported on systems with 2GB RAM, we recommend a minimum of 3GB.

BusinessObjects Repository Database

CA Business Intelligence 3.2 supports the BusinessObjects repository database on the following platforms:

• Oracle 10.1, 10.2, 11.1. See further Oracle requirements below.
• SQL Server 2000 SP4, 2005, or 2008. See further SQL Server requirements below.
• IBM DB2/UDB 9.1, 9.5, or 9.7
• Sybase Adaptive Server Enterprise 15
• MySQL 5.0 (embedded in CA Business Intelligence 3.2).

CA Business Intelligence 3.2 plus the SP4 patch for BusinessObjects XI 3.1 supports the repository database on the platforms listed above, plus these additional platforms:

• SQL Server 2008 R2
• Oracle 11.2
• Sybase Adaptive Server Enterprise 15.7

To enable support for these additional 'BOXI SP4' database platforms, you must:

1. Install the preceding database version (for example, Oracle 11 precedes Oracle 11.2).

2. Apply the SP4 patch for BusinessObjects XI 3.1.

3. Migrate the repository to the database version or, for SQL Server 2008 R2, perform an in situ upgrade.

Note: CA DLP integration with CA Business Intelligence has been tested using MySQL 5.0.

BusinessObjects Audit Database

The BusinessObjects audit database is supported on the same platforms as the repository database, with one exception. Sybase Adaptive Server Enterprise 15.7 is not supported.

SQL Server

Before installing CA Business Intelligence, you must:

• Create an empty database for BusinessObjects to use.
• Create a SQL Server login to be the owner of the new database.
• Install the relevant SQL Server client tools on the host server.

  These client tools are available from your database vendor and include the drivers (that is, the OLE DB Providers) that the universe uses to access the CA DLP central management server. These drivers are essential. Without them, CA DLP cannot apply row level security (RLs) to report results.

• (On 64-bit systems only) Specify a 32-bit ODBC System DSN to connect to SQL Server. Find odbcad32.exe in the \Windows\SysWOW64 directory.

Oracle

Before installing CA Business Intelligence, you must:

• Install the relevant Oracle client tools.

  These client tools are available from your database vendor and include the drivers (that is, the OLE DB Providers) that the universe uses to access the CA DLP CMS. These drivers are essential. Without them, CA DLP cannot apply row level security (RLs) to report results.

• Specify a 32-bit ODBC System DSN to connect to Oracle.

  (On 64-bit systems only) The 32-bit ODBC driver is available to download as part of Oracle 32-bit Oracle Data Access Components on the Oracle web site. After installing the driver, you can create the 32-bit ODBC System DSN using the Data Sources (ODBC) applet in Administrative Tools.

• Add the CA DLP CMS to tnsnames.ora.

  (On 64-bit systems only) An Oracle CA DLP CMS must use a 32-bit ODBC System DNS to connect to your BusinessObjects CMS. To allow the CA DLP CMS to connect using 32-bit Oracle client software, the tnsnames.ora file must include an entry for the CA DLP CMS database. You must also specify the location of tnsnames.ora in the registry.

  See the reference below for details.

BusinessObjects Administrator Credentials

The installer creates a default BusinessObjects administrator account (name: administrator). This account is used to import CA DLP report templates and to access BusinessObjects InfoView.

You must supply the password for this account when you install CA Business Intelligence.

MySQL Database Credentials

If you use MySQL as your report database, the installer requires the following information:

MySQL root password

Supply the password for the MySQL root user.

User name

Supply the user ID of the database account that is used to manage the report database.

Password

Supply the password for the database account that is used to manage the report database.

Database name

Supply the name of the report database instance.

Apache Tomcat

The CA Business Intelligence installer includes an embedded version of Apache Tomcat. If you use this version of Tomcat as your application server, the CA Business Intelligence installer requires the following information:

Connection port

Tomcat connects to this port.

The default port is 8080.

Redirect port

Tomcat redirects requests to this port.

The default port is 8443.

Shutdown port

Tomcat issues SHUTDOWN commands to this port.

The default port is 8005.

More information:

Add a CA DLP CMS Entry to Tnsnames.ora