Implementation Guide › Implementing Enterprise Reporting › How to Set Up Reporting Service Server Components › Report Package Deployment › Deploy the Report Package on the Report Portal

Deploy the Report Package on the Report Portal

To use the standard CA ControlMinder reports, import the report package file into BusinessObjects InfoView.

Note: This procedure describes how you deploy a report package on the Report Portal when no previous version of the same package is already deployed.

Follow these steps:

1. Verify that the central database, Distribution Server, and Report Portal are set up.

   Note: Verify that the JAVA_HOME variable is set up on the Report Portal computer.

2. Insert the CA Business Intelligence for Windows DVD into your optical disc drive and navigate to the \Disk1\cabi\biconfig folder.
3. Copy the contents of the biconfig directory into a temporary directory.
4. Insert the appropriate CA ControlMinder Server Components DVD for your operating system into your optical disc drive and navigate to the \ReportPackages folder.
5. Copy the following files from the optical disc into the same temporary directory:
   • \ReportPackages\RDBMS\import_biar_config.xml
   • \ReportPackages\RDBMS\AC_BIAR_File.biar

   RDBMS

   Defines the type of RDBMS used for CA ControlMinder reporting.

   Values: Oracle, MSSQL2005

   import_biar_config.xml

   Defines the name of the import configuration file (.xml) for your RDBMS.

   Values: import_biar_config_oracle10g.xml, import_biar_config_oracle11g.xml, import_biar_config_mssql_2005.xml

   Note: If you use MS SQL Server 2008 as your central database, configure the import_biar_config_mssql_2005.xml file.

   AC_BIAR_File.biar

   Defines the name of the CA ControlMinder reports file (.biar) for your language and RDBMS.

   Note: The <biar-file name> property of the import configuration file for your RDBMS points to this file. The property is set by default to the name of the English version for your RDBMS.

6. Edit your copy of the import_biar_config.xml file. Define the following XML properties:

   <biar-file name>

   Defines the full pathname to the CA ControlMinder reports file (.biar). You copied the file in the previous step.

   <networklayer>

   Defines the network layer supported by your RDBMS.

   Values (Windows):

   • OLE DB—for MS SQL Server authentication mode.
   • Oracle OCI
   • ODBC—for Windows Authentication mode.

   <rdms>

   Defines the type of RDBMS used for CA ControlMinder reporting.

   Values (Oracle OCI): Oracle 10 or Oracle 11

   Values (ODBC): Generic ODBC datasource

   Values (OLE DB): MS SQL Server 2005, MS SQL Server 2008 or any value except Oracle 10 or Oracle 11

   Note: For more information about the values that you can specify for this property, see the CA Business Intelligence documentation.

   <username>

   Defines the user name of the RDBMS administrative user you created when you prepared the central database for Enterprise Management.

   <password>

   Defines the password of the RDBMS administrative user you created when you prepared the central database for Enterprise Management.

   <datasource>

   Defines one of the following:

   • (Oracle) The name of the database
   • (SQL Server 2005 or 2008) The database you created
   • (ODBC) The DSN you created

   Important! Specify the name of the database used by CA ControlMinder for reporting and not the CA Business Intelligence CMS.

   <server>

   Defines the name of the SQL Server 2005 or 2008 computer. Leave this value empty for Oracle Database 10g, 11g, and ODBC.

7. Perform the following:
   • Open a command prompt and enter the following command:

     System_Drive:\BO\biconfig.bat -h host_name -u user_name -p password -f ac_biar_config.xml
     

     host_name

     Defines the Report Portal host name.

     user_name

     Defines the Report Portal administrator you configured when you installed the Report Portal.

     password

     Defines the password for the Report Portal administrator.

     For example:

     biconfig.bat -h reportportal.comp.com -u Administrator -p P@ssw0rd -f C:\BO\import_biar_config_oracle11g.xml
     

   • (UNIX) Set the execute permission for the script file biconfig.sh and execute it as follows:

     temp_dir/biconfig.sh -h host_name -u user_name -p password -f ac_biar_config.xml
     

     For example:

     biconfig.sh -h reportportal.comp.com -u Administrator -p P@ssw0rd -f /tmp/rp/import_biar_config_orcl.xml
     

   The batch file imports the CA ControlMinder reports into InfoView. The import can take a few minutes to complete. A log file (biconfig.log) is created in the same folder as the batch file and indicates whether the import was successful.

Example: Sample Oracle Database 11g Import Configuration File

The following code snippet is an example of an edited import configuration file (import_biar_config_oracle11g.xml) for Oracle Database 11g:

<?xml version="1.0"?>
<biconfig version="1.0">
  <step priority="1">
    <add>
      <biar-file name="c:\temp\AccessControl_R12.5_EN_ORCL_22_JUN_2009.biar">
        <networklayer>Oracle OCI</networklayer>
        <rdms>Oracle 11</rdms>
        <username>root</username>
        <password>P@ssw0rd</password>
        <datasource>orcl</datasource>
        <server></server>
      </biar-file>
    </add>
  </step>
</biconfig>

Example: Sample Microsoft SQL Server 2005 Import Configuration File

The following code snippet is an example of an edited import configuration file (import_biar_config_mssql2005.xml) for MS SQL Server 2005:

<?xml version="1.0"?>
<biconfig version="1.0">
  <step priority="1">
    <add>
      <biar-file name="c:\temp\AccessControl_R12.5_EN_SQL_11_JUN_2009.biar">
        <networklayer>OLE DB</networklayer>
        <rdms>MS SQL Server 2005</rdms>
        <username>dbAdmin</username>
        <password>P@ssw0rd</password>
        <datasource>r125db</datasource>
        <server>rdbms.org</server>
      </biar-file>
    </add>
  </step>
</biconfig>

More information:

Configure a Windows Endpoint for Reporting

Configure a UNIX Endpoint for Reporting