Configure the Components › Integrate CA Business Intelligence with CA Service Catalog › Import CA Service Catalog Reports

Import CA Service Catalog Reports

Perform the following steps to import Business Intelligence Archive Resource (BIAR) file.

Follow these steps:

1. Set Java home on the CA BI Reporting server.
   1. Right-click My Computer on your desktop and select properties.
   2. Click the Advanced Tab.
   3. Click the Environment Variables.
   4. Under System Variable, click New.
   5. Enter the variable name as JAVA_HOME.
   6. Enter the variable value as the install path for the Development Kit.

      Example: C:\Java\JDK

   7. Click OK.
   8. Click Apply Changes.
2. Copy the BIAR folder from the CA Business Intelligence media\Disk1\cabi\biconfig directory to the CABI Machine in any directory(for example, C Drive(C:\biconfig)).

   Note: If the biconfig folder does not exist under the C drive, then create the biconfig folder.

3. Copy the SLCM_universe.biar file from \\<SLCM Application Server>\C$\Program Files\CA\Service Catalog\reporting\CABI\biar to the C:\biconfig folder.
4. Copy xml_biar_import.xml file from the biconfig\Samples folder into the biconfig root folder and rename to xml_biar_import.catalog.xml.
5. Edit xml_biar_import.catalog.xml file so that it reads similar to the following example, which is outlined more generally in Step 4:

   <?xml version="1.0"?>
   <biconfig version="1.0">
     <!-- Import BIAR file -->
     <step priority="1">
       <add>
       <biar-file name="C:\biconfig\SLCM_universe.biar">
               <networklayer>ODBC</networklayer>
               <rdms>MS SQL Server 2008</rdms>
               <username>sa</username>
               <password>password</password>
               <datasource>ASC</datasource>
               <server>Catalog Server Name</server>
           </biar-file>
       </add>
     </step>
   </biconfig>
   

   Note: Verify that the name for <datasource> matches the DSN name specified in the Installation Worksheet under CA Business Intelligence, CA BI Data Source Name to MDB. For example, in the screenshot above, the DSN name is ASC.

6. In the Command Prompt window, change the directory to the C:\biconfig location, and then execute biconfig.bat to import the BIAR file using the following command:

   biconfig -h “<CABI_Server_Name>” -u “<administrator>” -p “<admin_password>” -s “secEnterprise” -f “xml_biar_import.catalog.xml”
   

7. Verify the import, as follows:
   1. Review the biconfig.log file in the biconfig folder:

      This file lists the status of the import. This file also includes error messages if the BIAR file is not imported successfully.

   2. Log in to InfoView as a BusinessObjects Enterprise administrator.
   3. In InfoView, verify that you can view the CA SLCM Reports under Public Folders/CA Reports/CA SLCM.

   

8. Change the catalog administrator password (default: spadmin).

   Note: The new password must match the password that spadmin uses to log in to CA Service Catalog.

   To set the password, perform the following steps:

   1. Log in to the BusinessObjects Enterprise Central Management Console.
   2. Click Users and Groups link under the Organize column.
   3. Click User List.
   4. Double-click spadmin to open the Properties page.
   5. Specify the password in both the Password and Confirm fields.
   6. Click Save & Close. Log out from the Central Management Console when done.

   Importing of the CA Service Catalog reports is complete. See CA Service Catalog Integration Guide for complete steps on importing CA Service Catalog reports.