How to import a BIAR file in a CABI 4.1 environment for CA Service Catalog.
Windows running CABI 4.1.
Some information regarding the import of a BIAR file for CABI 4.1 release.
The import wizard does not exist in CABI 4 anymore.
However the BICONFIG command line utility can be used
This article contains the following topics:
1. Create a Data Source Name and ODBC Connection for the MDB on SQL Server
2. Use biconfig to Import the BIAR File
3. Example XML File (SQL Server) to Import BIAR
The Business Intelligence Archive Resource (BIAR) file includes several required components and CA Service Catalog-specific content for use with CA Business Intelligence.
The file includes CA Service Catalog universe, default objects, pre-defined reports, user groups, database schemas, locale strings, and data that helps you customize your CA Business Intelligence implementation, especially your reports.
AD1: Create a Data Source Name and ODBC Connection for the MDB on SQL Server
If you are using Microsoft SQL Server as your DBMS for the MDB, a data source name (DSN) and ODBC connection for the MDB on SQL Server are prerequisites for setting up your CA Business Intelligence implementation.
If necessary, create them now and follow these steps:
1. From the Windows Control Panel, open ODBC.
2. Click Add on the System DSN tab.
3. Select SQL Server as the driver and click Finish.
4. Enter the following information and click Next:
-Data source name (DSN)
Note: Ensure that you create the DSN with the name "caslcm_cabi_dsn".
-Name of the SQL Server server
5. Perform the following actions and click Next:
a. Select SQL Server Authentication
b. Select the option to Connect to SQL Server to obtain default settings for configuration options.
Enter the user ID and password to connect to the database.
6. Perform the following actions and click Next:
a. Change the default database to the SQL Server database. (mdb).
b. Select the option to use ANSI quoted identifiers.
c. Select the option to use ANSI nulls, paddings, and warning.
7. (For localized environments only) Check the option to use regional settings for currency, numbers, dates, and times.
8. Click Finish.
You have now created the DSN and ODBC connection for SQL Server.
AD2: Use biconfig to Import the BIAR File
Importing the BIAR file is a required task to set up your CA Business Intelligence implementation.
We recommend that you use the CA Business Intelligence biconfig batch utility to import the BIAR file.
Note: Delete the CA SLCM Connection from Central Management Console before you import the BIAR file.
Follow these steps:
1. Go to the CA Service Management Install path and locate the \filestore\BOXI\biconfig folder.
2. Copy the contents of the biconfig folder on to the CA Business Intelligence computer.
3. Create an XML file (with the contents of Example file for SQL server or Oracle ) and update the appropriate file, according to your requirements.
Set the following parameters in your BIAR file:
- Networklayer: ODBC
- For Microsoft SQL Server (SQL Server): MS SQL Server 2008 or MS SQL Server 2012
- User name and password parameters for your database:
- For SQL Server: Use sa for the user name.
Note: These users have access to all required tables in the MDB.
- Path name of the SLCM_universe.biar file on the CA Business Intelligence computer
- Name of the DSN created previously in the datasource parameters.
- Server parameter: Computer name of your Oracle or SQL Server server
4. Open a Windows command prompt and navigate to the biconfig folder on the CA Business Intelligence computer and enter the following command:
biconfig -h "<host>" -u "<Administrator>" -p "<password>" -f "XML-config-file-name" (biconfig_import_slcm.xml)
The quotation marks (" ") are required as shown in the command.
However, the brackets [ ] are not required; the brackets signify optional parameters.
The following parameters are required, unless noted otherwise.
-host Specifies the CA Business Intelligence Central Management Server (CMS) host.
-port (Optional) Specifies the CA Business Intelligence CMS port. The default is 6400.
-user Specifies the CA Business Intelligence CMS user.
-password Optional. Specifies the CA Business Intelligence CMS password.
-XML-config-file-name Specifies the path name of the XML file you modified.
If the file resides in the biconfig folder, you can specify the file name only.
Otherwise, specify the complete path name.
-help Optional. Displays the help for the biconfig utility. Enter two dashes to display the help.
Note: For more information about using biconfig, see the biconfig-readme.txt file in the biconfig folder.
6. Verify the import, as follows:
a. 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.
A return code of zero (0) indicates a successful import.
b. Log in to BI launch pad as a CA Business Intelligence administrator.
c. Verify that you can view the CA Service Catalog Reports under Public Folders/CA Reports/CA Service Management/CA Service Catalog.
7. Specify a password for the spadmin user in CA Business Intelligence. It is empty by default.
Note: If you must import the BIAR file again, delete the following elements from the CA Business Intelligence Central Management Console before you import the BIAR file again:
-CA SLCM folder
-CA SLCM Universe
-CA SLCM Groups
AD3: Example XML File (SQL Server) to Import BIAR
Below is an example XML File (SQL Server) content, to Import a BIAR.
My c:\biconfig\biconfig_import_slcm.xml file:
<!-- Import BIAR file -->
<biar-file name="Specify path of the SLCM_universe.biar file on the CA Business Intelligence computer">
<rdbms><Specify the MS SQL Server version></rdbms>
<password><Specify the sa password></password>
<server><Specify the Database Server name></server>
<password mode="normal"><Specify the password for the spadmin user in CA Business Intelligence></password>
<description>SLCM Admin User</description>
<group>SLCM Service Delivery Administrators</group>