Previous Topic: Import the BIAR File with the BICONFIG UtilityNext Topic: Run GRLoader from a Remote MDR

Appendix › Import the BIAR File with the BICONFIG Utility › Oracle Example

Oracle Example

The following example shows the sample XML file for Oracle:

<?xml version="1.0"?>
<biconfig version="1.0">
  <!-- Import BIAR file -->
  <step priority="1">
    <add>
    <biar-file name="C:\biconfig\CCA_CMDB_Report.biar">
            <networklayer>Oracle OCI</networklayer>
            <rdms>Oracle 10</rdms>
            <username>ccaserver</username>
            <password>ccaserver</password>
            <datasource>ORA</datasource>
            <server>testpc</server>
        </biar-file>
    </add>
  </step>
</biconfig>

Import the BIAR File with the Import Wizard

You can import the Business Intelligence Archive Resource (BIAR) file by using the Import Wizard, but you can also use the BICONFIG utility. This file contains the CA CMDB Export report and the CA Business Intelligence Universe required to completing the integration.

Note: If you use the Import Wizard, you must modify the Universe connection manually by logging in to the Universe Designer.

To import the BIAR file

  1. Click Start, Program Files, BusinessObjects XI Release 3.1, BusinessObjects Enterprise, Import Wizard.

    The Import Wizard appears.

  2. Click Next and select Business Intelligence Archive Resource (BIAR) File as the source and browse to select the BIAR file.

    For example, the file is named CCA_CMDB.biar.

  3. Enter the username and password for your destination Business Objects XI Central Management Server (CMS) and click Next.

    The Import Wizard loads the BIAR file.

  4. Click Clear all and perform the following tasks:
    1. Select the Import folders and objects, Import application folders and objects and Import universes options and click Next.
    2. Select the following import scenarios:
      • Use the object's unique identifier to determine whether it already exists in the destination system
      • Update the destination object. In case of name conflict, rename it
    3. Click Next, disable the Overwrite object rights option, and click Next again.
    4. Select the CCA TO CMDB Export Group and click Next.

      Note: Verify that only the CCA to CMDB Export Group is selected and that no other groups or users are selected.

      A message appears indicating that the selected import objects have attached rights.

    5. Click Next and browse to the appropriate report folder that contains BOXI_GRLoader and the CA CMDB Export, for example:

      CA Reports\CA CCA to CMDB\

    6. Click Next.

      The Select application folders and objects dialog appears.

  5. Select your CA Business Intelligence server and click Next.

    The Import options for universes and connections dialog appears.

  6. Select the Import the universes and connections that the selected Web Intelligence and Desktop Intelligence documents use directly option and click Next.
  7. Select the CA Business Intelligence universe under CA Universes, CCA_CMDB, CCA_CMDB.

    The Import options for publications dialog appears.

  8. Select the Do not import recipients option and click Next.

    The A note on importing reports dialog appears.

  9. Click Next.

    The Ready to Import dialog appears.

  10. Click Finish.

    The information is imported to the destination environment.

Modify the Database Connection

Use the Universe Designer to modify the database connection. If you imported the BIAR file with the Import Wizard, you must modify the database connection with the Designer.

To modify the database connection

  1. Click Start, Program Files, Business Objects XI 3.1, Business Objects Enterprise, Designer.

    The User Identification dialog appears.

  2. Enter the enterprise system name, username (such as Administrator), password and click OK.

    The Universe Designer appears.

  3. Click File, Import.

    The Import Universe dialog appears.

  4. Select the CCA_CMDB universe under /CA Universes/ and click OK.

    A message displays that the Universe imported successfully.

  5. Click File, Parameters.

    The Universe Parameters dialog appears.

  6. Perform the following tasks:
    1. Click Edit.

      The Edit CCA_CMDB connection dialog appears.

    2. Click Back.

      The Database Middleware Selection dialog appears.

    3. Perform the appropriate task for your CA Configuration Automation database:
      • For SQL Server, Select Microsoft, MS SQL Server 2005 or 2008 (depending on your CA Configuration Automation database), OLE DB Providers, click Next, change the Universe connection to point to SQL Server and click Next.
      • For Oracle, Select Oracle, Oracle Client to change the Universe to point to Oracle and click Next.

      The Login Parameters dialog appears.

    4. Enter your username (for example, ccaserver), password, and service of the Oracle server (such as ora) and click Test Connection.

      A message appears indicating that the server is responding.

    5. Click Next, Finish.

      The CCA_CMDB connection is modified.

  7. Click File, Save.

    The Universe is saved.

  8. Click File, Export.

    The Export Universe dialog appears.

  9. Select /CA Universes/CCA_CMDB from the Domain drop-down list and click OK.

    The Universe was exported.

Configure the Email and File System Servers in CA Business Intelligence

If you did not configure the destination servers during the integration installation, or if you must configure them for a specific report instance, you can optionally configure the destination servers of the CrystalReportJobServer, ProgramJobServer, and DestinationJobServer. The File System generates the file that the Email system sends to the user you specify.

You can also select any of the following notification destinations:

File Destination

Sends the output to a specific file location.

FTP

Sends the output to a specific FTP address.

Default Enterprise location

Specifies a default location in your BusinessObjects Enterprise. Click the instance title and use a text editor to open the output.

Note: You access the output of successful instances sent to any destination from the History of the object. Click the instance title and use a text editor to open the output.

To configure the email and file servers

  1. Click Start, Programs, BusinessObjects XI 3.1, BusinessObjects Enterprise Central Management Console.

    The BusinessObjects Central Management Console (CMC) login page appears.

  2. Enter your username and password, click Log In.

    The Central Management Console appears.

  3. Click Servers from the Organize column.

    The Servers list appears.

  4. Right-click on the first server you want to configure, such as CrystalReportJobServer, and select Destination.
  5. Perform the following tasks to configure the Destination File System of the CrystalReportJobServer, where you set the Destination directory and the system credentials:
    1. Select File System from the Destination drop-down list.
    2. Enter the destination directory.
    3. Enable the Use Automatically Generated Name option.
    4. Enter your login credentials for Administrator.
    5. Click Save and Close.
  6. Perform the following tasks to configure the Email server of the CrystalReportJobServer to notify a user about a successful schedule:
    1. Select Email from the Destination drop-down list.
    2. Complete the following fields:

      Domain Name—Specifies the domain name of the Email server.

      Host—Specifies the host of the Email server.

      Port—Specifies the port of the Email server.

      To—Specifies the Email address of the user that gets an Email notification when the report runs.

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

    3. Click Save and Close.
  7. Select the ProgramJobServer from the Server list on the CMC and configure the Email and File System servers as you did in steps 5 and 6.
  8. Select the DestinationJobServer from the Server list on the CMC and configure the Email and File System servers as you did in steps 5 and 6.

    The Email and File systems of the CrystalReportJobServer, ProgramJobServer, and DestinationJobServer are configured.

Configure the Program Object in CA Business Intelligence

After you configure the Email and File System servers in CA Business Intelligence, you configure the CMC program object that was imported from the BIAR file. The program file executes the appropriate scripts and you schedule it to launch with the privileged user login of the operating system. Configuring the program objects also lets you add JAR files to the CA Business Intelligence repository, and you can also schedule them like reports. You use the JAR file when CA CMDB is installed on UNIX.

To configure the program object

  1. Log in to the Central Management Console (CMC).

    The CMC Home Page appears.

  2. Click Applications in the Manage column.

    The Applications list appears.

  3. Right-click CMC and select Program Object Rights.
    The Program Object Rights: CrystalEnterprise.Program page appears.
  4. Enable the following options:
    1. Select Run scripts/binaries.
    2. Select Run java programs.
    3. Select Use impersonation.
  5. Select the Schedule with the following operating system credentials option and enter your user name and password.
  6. Click Save.

    The program object is configured.

How to Configure the GRLoader Environment in CA Business Intelligence

If you want to configure a different event, configure GRLoader in CA Business Intelligence manually. Set up a schedule for GRLoader to optionally email the CA CMDB report to a user that you specify. The report triggers an event on the successful schedule of the report, and BOXI_GRLoader waits for XML Schedule event.

The following information provides an overview of how to complete the integration from the Central Management Console (CMC):

  1. Create a schedule event for the XML file.
  2. Do one of the following:
    1. Schedule BOXI_GRLoader and the CA CMDB Export report.
    2. If CA CMDB is on a different computer, execute GRLoader.
    3. Run GRLoader from a remote MDR.

    The XML file is generated and executes the XML Schedule, which starts the schedule of the BOXI_GRLoader program object and loads data into the CA CMDB database.