How to Manually Import APM 12.9 CABI Reports
I. If the option to configure Business Objects was NOT checked on during the APM 12.9 installation, follow the instructions in the sections:
RUN BIARSETUP.MSI and MODIFY THE BOXI UNIVERSE CONNECTION.
II. If the option to configure Business Objects was checked ON during the APM 12.9 installation, but there was a failure during the report import process, then follow the instructions in the sections: BICONFIG IMPORT REPORTS and MODIFY BOXI UNIVERSE CONNECTION
RUN BIARSETUP.MSI
1. Locate the BIARSetup.msi file on the APM 12.9 installation media in the directory <drive>:\Setups\BIAR
2. From a command prompt, navigate to the \setups\BIAR folder and run BIARSetup.msi with the parameters below:
Note: Substitute your credentials for parameters within the < >’s. (Do not include the >).
Quote marks below ARE needed, where indicated.
msiexec /i BiarSetup.msi DBTYPE="MSSQL" DBSERVER="MyDBServerName" DBNAME="MyDatabaseName"
DBNAME=”<MyDBName>” DBUSER=MyDatabaseUser
BOITAMPASSWORD=<BOITAMUSER pwd
BOITAMUSER=Administrator BOCMSPORT=6400
BOSERVER=BOServerName> DBPORT=1433 DBPASSWORD=DBUSERpwd
DBTYPEVERSION="MS SQL Server 2008"
Example for SQL Server:
Msiexec /i BiarSetup.msi DBTYPE=”MSSQL” DBServer=”TestServer”
DBName=”mdb” DBUSER=sa BOITAMPASSWORD=CABIAdmin1
BOITAMUSER=Administrator BOCMSPORT=6400 BOSERVER=TestBOServer DBPORT=1433
DBPASSWORD=sa DBTYPEVERSION="MS SQL Server 2008"
Example for Oracle:
msiexec /i BiarSetup.msi DBTYPE="ORACLE" DBSERVER="<MyDBServerName"
DBNAME="<MyDBName" DBUSER=mdbadmin BOITAMPASSWORD=CABIAdmin1 BOITAMUSER=Administrator BOCMSPORT=6400 BOSERVER=TestBOServer DBPORT=1521 DBPASSWORD=mdbadmin DBTYPEVERSION="Oracle 1"
3. When the command completes, locate the
C:\Program Files (x86)\CA\SharedComponents\BIAR\biconfig\ biconfig.log file
4. Review the biconfig.log file for errors
Note: a return code = 0 at the end of the log, means normal completion.
5. Follow the instructions in the MODIFY THE BOXI UNIVERSE CONNECTION section.
BICONFIG Import REPORTS
1. Log onto the APM 12.9 server, and navigate to the folder: <drive>:\Program Files (x86)\CA\ITAM\BIAR\biconfig
2. Edit the file named: ItamBoSetup-InstallBiar.xml with Notepad
3. Make sure the biar-file-name path above references the proper location for the
<drive>:\Program Files (x86)\CA\ITAM\BIAR\biconfig\
4. Edit the SQL Server version (i.e., “MS SQL Server 2005” or “MS SQL Server 2008”), mdb username, mdb password, datasource (database name) and SQL Server host name to the parameters for your installation. Save the file.
5. Open a command prompt to the biconfig folder, and type the following command:
biconfig –h <hostname of CABI app server> -u Administrator –p <AdminPwd> -f ItamBoSetup-InstallBiar.xml.
NOTE: The AdminPwd is the password for the Business Intelligence Administrator user.
Example: Biconfig –h MyCABIServer –u Administrator –p boxiadmin –f ItamBOSetup-InstallBiar.xml
If you receive a message about JAVA_HOME not being set, run the following command and then rerun the biconfig command. Set JAVA_HOME=C:\Program Files\CA\SC\CommonReporting3\jre.
Once executed successfully, the command prompt will return.
6. Open <drive>:\Program Files (x86)\CA\ITAM\BIAR\biconfig.log and check it for errors.
Modify the BOXI Universe Connection
Now that the BIAR file has been imported, verify the imported connection information.
Launch the Business Intelligence Designer from Start->Programs->BusinessObjects XI 3.1->BusinessObjects Enterprise->Designer. Enter the required information and click OK.
Click Cancel.
Select the File->Import menu and the following appears. Click the Browse button
Highlight the CA IT Asset Manager universe. Click OK.
.
Click OK.
Click OK. Select the Tools->Connections menu.
Select the ITAM connection and click Test. A message will appear that you are communicating properly to the database.
Click OK on the message, and then click Edit on the Connections screen.
This message displays:
Click Yes to continue.
Verify the SQL server login credentials and database name
Click Next.
Set the following connection parameters.
Click Next and the following screen displays.
Click Finish.
Click Test to verify the server is responding. Click Finish
Click the Save button on the toolbar. Select the File->Export menu.
Select both entries and click OK.
Click OK and close the Designer.
The ITAM reports are now ready for use.