Previous Topic: Add a CA DataMinder CMS Entry to Tnsnames.oraNext Topic: Apply the BusinessObjects XI 3.1 SP4 Patch


Install CA Business Intelligence

For the current CA DataMinder release, your reports server must be running BusinessObjects XI 3.1 SP3. 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. You must also apply the SP4 patch for BusinessObjects XI 3.1.

The following sections describe how to install a new SAP BusinessObjects Enterprise System. If you want a Custom Or Expand install or a Web Tier install, please refer to chapters 5 and 6 in the CA Business Intelligence Implementation Guide. Find this guide in the \Docs folder of your CA Business Intelligence distribution image.

To prepare your reports server for a CA Business Intelligence installation

  1. Download CA Business Intelligence from the CA Support site, under CA DataMinder product downloads.
  2. Extract the CA Business Intelligence distribution image onto your target reports server.
  3. Review the CA Business Intelligence requirements, especially the requirements for the BusinessObjects administrator account, Apache Tomcat, and MySQL.
  4. Exit all applications that are running.

To run the CA Business Intelligence installer

  1. Navigate to the root of your CA Business Intelligence distribution image on your reports server and run cabiinstall.exe.

    After a short delay (possibly several minutes), the CA Business Intelligence installer starts and prompts you for a locale.

  2. Select English from the locale list and click OK.
  3. Navigate through the installer introduction and license agreement screens.
  4. When the installer prompts you to install CA sample templates, click Yes or No.

    CA sample templates include example reports that demonstrate BusinessObjects reporting capabilities. You can customize these sample reports.

  5. When the installer prompts you to save a response file, click Yes or No.

    The response file, cabireponse.ini, records your choices when you run the CA Business Intelligence installer. You can use the response file to automate any subsequent installations. For example, you may want to rerun the installation on a production system after evaluating CA Business Intelligence on a test system.

  6. When the CA Business Intelligence installer displays the summary screen, click Install.

    There may be a short delay while the CA Business Intelligence Setup wizard starts.

    Note: If the wizard does not appear, check that it is not hidden behind the installer window.

  7. Accept the license agreement and select any language packs that you need to install.

    The wizard now steps you through the main CA Business Intelligence setup steps.

  8. Specify a new installation in the Install Type screen.
    1. Click New to install a new SAP BusinessObjects Enterprise System.
    2. Select one of the following options:
      • Install MySQL Database Server if you do not have a system database server and want to install MySQL on the current computer.
      • Use an existing database server if you want to use an existing database server. For example, click this option if you prefer to use SQL Server for your BusinessObjects databases.
    3. Select the Enable servers upon installation check box if you want to launch BusinessObjects Enterprise when the installation process finishes. If you do not check this option, you must manually enable and run the BusinessObjects Enterprise application server from the Central Configuration Manager (CCM) after installation.
    4. Specify where to install the BusinessObjects Enterprise components in the Destination Folder field (make sure enough disk space is available). The defaults are:
      • C:\Program Files\CA\SC\CommonReporting3 (for 32-bit computers)
      • C:\Program Files X(86)\CA\SC\CommonReporting3 (for x64 computers)
    5. Click Next to continue.
  9. Specify the BusinessObjects CMS port and password details in the Server Components Configuration screen.

    Note: The 'CMS' in these instructions is the BusinessObjects Central Management Server, which manages the entire BusinessObjects Enterprise system. Do not confuse this BusinessObjects CMS with the CA DataMinder Central Management Server.

    1. Specify a port number in the CMS port field.

      The BusinessObjects CMS communicates with other BusinessObjects Enterprise servers through the specified port. The default CMS port number is 6400.

    2. Specify a password for the CMS administrator account in the Password and Confirm password fields.

      (Optional) Select the 'Configure the BusinessObjects Enterprise Administrator password at a later time' check box if you want to set the password after the installation is complete. If you select this check box, you must log in to the CMC with a blank password for the first time to be able to change the Administrator password.

    3. Click Next to continue.
  10. Enter a node name and port in the Server Intelligence Agent screen.

    A Server Intelligence Agent (SIA) node is automatically created during installation of BusinessObjects Enterprise. The Server Intelligence Agent screen is used to name and designate a port address for the SIA.

    1. Enter a unique name to identify the SIA node in the Node Name field. Do not use spaces or non-alphanumeric characters.

      By default, the node name is same as the system host name, but excluding any unsupported characters.

    2. Specify a port number for the SIA in the Port field.

      The default port number is 6410.

      This port is used by the SIA to communicate with the BusinessObjects CMS.

    3. Click Next to continue.

      The wizard validates the port number and warns you if the specified port is not available.

    Note: Server Intelligence is the underlying management architecture that simplifies the BusinessObjects Enterprise administration and deployment. Server Intelligence enables you to use the CMC for all daily maintenance tasks, such as configuring new servers, or starting and stopping existing servers. For details about Server Intelligence, see the CA Business Intelligence Implementation Guide.

  11. In step 8, if you chose to:
  12. Configure the required accounts in the MySQL Database Server Configuration screen.

    Note: This screen only appears if you chose to install MySQL as part of the BusinessObjects Enterprise installation.

    1. Specify the port number for the MySQL database server in the MySQL Port Number field.

      The default port number is 3306. Use this number unless the port is unavailable.

    2. Specify a password for the MySQL root user account.
    3. Confirm the username and specify a password for the MySQL BusinessObjects database user account
    4. Click Next to continue.
  13. Specify the required details in the CMS Database Information screen.

    Select the DBMS that you want to use for the BusinessObjects CMS and Auditing databases. If you select:

    SQL Server

    Before installing CA Business Intelligence, you must create an empty database for BusinessObjects to use. You must also create a SQL Server login to be the owner of the new database.

    On 64-bit systems, you must specify a 32-bit ODBC System DSN to connect to SQL Server. Find odbcad32.exe in the following \Windows\SysWOW64 directory.

    Oracle

    On 64-bit systems, you must specify a 32-bit ODBC System DSN to connect to Oracle.

    Note: If the ODBC connection that you need is not listed, you may need to correct a new ODBC System DSN. Alternatively, your ODBC System DSN may be configured incorrectly. For more details, see Troubleshooting.

  14. Specify the required details in the Select Web Application Server screen.

    The web application server runs BusinessObjects Enterprise web applications such as InfoView, the CMC, and custom web applications. For integration with CA DataMinder, you must deploy BusinessObjects applications to a Java-based web application server (a Tomcat web application server is included with BusinessObjects Enterprise).

    Note: Do not deploy these applications to the IIS web application server included in your Windows operating system. CA DataMinder does not support IIS web application servers.

    Deploy to a Java web application server
    1. Click Java Web Application Server.
    2. Click one of the following:
      • (Strongly recommended) Install Tomcat application server and deploy to it.

        The wizard automatically installs and configures Tomcat.

      • Automatically deploy to a preinstalled Web Application Server.

        The wizard prompts you to enter the configuration and authentication information on the next screen.

    3. Click Next to continue.

      Depending on your selection, you can now configure your web application server or start the installation process.

  15. (Applicable only if you chose to install Tomcat as the web application server for your BusinessObjects Enterprise installation) Specify the Tomcat ports in the Configure Tomcat screen.
    1. Specify the port numbers for the Connection port, Shutdown port, and Redirect port. The defaults are 8080, 8005, and 8443 respectively.

      See the CA Business Intelligence Requirements section for details about these ports.

    2. Click Next to continue.

      Wait while the installer configures CA Business Intelligence for your reports server. This configuration can take several minutes.

  16. Click Next in the Start Installation screen to start the installation process.

    If the progress window does not appear, check that it is not hidden behind the installer window.

    When the installation is complete, the Installation Complete screen displays.

    Note: The installation can take a long time, up to an hour.

  17. Click Finish to complete the BusinessObjects Enterprise main installation.

    When this main installation completes, the CA Business Intelligence installer installs any required BusinessObjects service packs or fixes plus the CA Report templates (if that option was selected).

    After the post-installations are performed, the CA Business Intelligence Completion screen displays with a summary of the installation.

  18. You must restart the host computer to finalize the CA Business Intelligence installation.
    1. (Optional) If you do not wish to restart the system immediately, select 'Restart the machine later'.
    2. Click Done.

Now apply the SP4 patch for BusinessObjects XI 3.1.

Troubleshooting:

CA Business Intelligence: I Cannot Choose an Existing Database Server