Previous Topic: How to Install and Configure the IntegrationNext Topic: Schedule the BOXI_GRLoader Program Object


Install the Integration Patch

Use the CA Configuration Automation CMDB Integration installer (cca-cmdb.exe) to install the integration components, such as the CA Configuration Automation database connection configuration and the CA Business Intelligence configuration.

Ensure taht you meet the following prerequisites:

Important! Do not install the JDK version 1.6.0_29 version, because of the connectivity issues.

Important! After you complete the installation, restart the CA Business Intelligence Application Server service (such as Tomcat) and the Server Intelligence Agent. Before you restart the Application Server service, delete the CAFApp folder from the CA Business Intelligence webapps directory, for example, C:\Program Files\CA\SC\CommonReporting3\Tomcat55\webapps.

Important! If the CA Configuration Automation Server uses an Oracle database, install the Oracle administrator client on the CA Business Intelligence computer, which lets CA Business Intelligence communicate with the CA Configuration Automation database. You also configure the TNS listener to have an entry that is named "CCA" which points to the CA Configuration Automation database. CA Business Intelligence uses this name as the datasource name to connect to the Oracle database. If you do not perform these steps, the CA CMDB Export report execution fails on Oracle.

If you install CA Business Intelligence 3.3 SP1, then select the webapps directory that is based on the Tomcat6 or Tomcat7 directory PATH.

For example:

Follow these steps:

  1. Launch the installer (cca-cmdb.exe) on the computer that has CA Business Intelligence.

    The CCA CMDB Integration Introduction page appears.

  2. Click Next.

    The CCA Database Server page appears.

  3. Select your CA Configuration Automation database (SQL Server or Oracle) from the Database Type drop-down list, complete the following fields, and click Next:
    Server Name

    Specifies the name or the IP address of the server where the CA Configuration Automation database resides. For IPv6 addresses, maximal extended form and maximal abbreviated form addresses are supported. Link local IPv6 addresses are not supported.

    Port Number

    Specifies the database listening port number. Accept the default or enter a different port number if you did not use the vendor-recommended default port number when you installed the database software.

    SQL Server Default: 1433

    Oracle Default: 1521

    Instance Name (Optional)

    (SQL Server only) Specifies the database instance name.

    Service Name

    (Oracle only) Specifies the Oracle database System Identifier (instance name).

    The CCA Database Configuration appears.

  4. Enter the following information in the corresponding field and click Next:
    Database Name

    Specifies the CA Configuration Automation database name.

    Database User

    Specifies the user name authorized to update the CA Configuration Automation database schema.

    Database User Password

    Specifies the password for the CA Configuration Automation database user that you specified in the previous field.

    Note: Type the password again to verify that you entered it correctly.

    The installer verifies the database details by connecting to the database and verifies if it upgraded with the CMDB patch installer.

    Note: If the verification fails, an error message directs you to upgrade CA Configuration Automation before configuring the CA CMDB Export report.

    The Choose CABI Folder page appears.

  5. Click Choose and browse to your CA Business Intelligence installation directory, such as the following example, and click Next:

    C:\Program Files\CA\SC\CommonReporting3

    The Choose CABI webapps Folder page appears.

  6. Click Choose and browse to your CA Business Intelligence webapps directory, and click Next:
  1. Complete the following credential information and click Next:
    Server Name

    Specifies the name of the BusinessObjects report server, such as localhost.

    Port

    Specifies the CA Business Intelligence report server listening port.

    Default: 6400

    Administrator

    Specifies the user name of the CA Business Intelligence report server administrator.

    Default: Administrator

    Administrator Password

    Specifies the password of the CA Business Intelligence administrator.

    Note: Type the password again to verify that you entered it correctly.

    System User Name

    Specifies the System user name that configures the user name of the File System, Program Object, and BOXI_GR Loader (if user selected these options during the installation) objects.

    System Password

    Specifies the password for the System User that configures the password of the File System, Program Object, and BOXI_GR Loader (if you selected these options during the installation) objects.

    Note: Type the password again to verify that you entered it correctly.

    The Configure Email page appears.

  2. (Optional) Complete the following fields to configure email notification destinations for CrystalReportJobServer, ProgramJobServer, and DestinationJobServer and click Next:

    For Email Notifications:

    Domain Name

    Specifies the domain name of the Email server.

    Host Name

    Specifies the host name of the Email server.

    To Address

    Specifies the Email address of the user that gets an Email notification when the report runs. You can specify additional email addresses by separating each one with a semicolon (;).

    From Address

    Specifies the Email address of the user that sends an Email notification when the report runs.

    Subject

    Specifies the subject of the email sent when the report runs.

    Note: You can manually configure the email and file system servers in CA Business Intelligence if you did not configure them during the installation, or if you want to configure them for specific report instances in the future.

    The Configure FTP page appears.

  3. (Optional) Complete the following fields to configure FTP notification for the servers CrystalReportJobServer, ProgramJobServer, and DestinationJobServer and click Next:
    FTP Host

    Specifies the FTP host name.

    FTP Port

    Specifies the FTP port.

    User Name

    Specifies the user name to connect to the FTP host.

    Password

    Specifies the password to connect to the FTP host.

    Note: Type the password again to verify that you entered it correctly.

    FTP Account

    Specifies the FTP account.

    Destination Directory

    Sends the output to a specific location on the FTP server.

    File Name

    Specifies the file name of the report file (XML).

  4. (Optional) Complete the following fields to configure File System notification for the servers CrystalReportJobServer, ProgramJobServer, and DestinationJobServer and click Next:
    File Destination Directory

    Sends the output to a specific location on the local CA Business Intelligence file system.

    User Specific File Name

    Creates a report file with file name that you specify in .XML format.

    The CABI_GRLoader page appears.

  5. (Optional) Enter the following details when you want installer to configure the GRLoader program object parameters:
    GRLoader arguments

    Specifies the GRLoader arguments (program object parameters).

    Working Directory

    Specifies the working directory where GRLoader copies the GRLoader binaries.

  6. Click Install after reviewing the summary.

    The installer confirms that the integration installation completed successfully.

  7. Click Done.

    The installer closes.