Previous Topic: System DSN Connection Configuration ExampleNext Topic: Changing CA ControlMinder Service Account Settings


Deploy the Report Package on a Report Portal that Works in Windows Authentication

Valid on Windows

To make use of the standard CA ControlMinder reports, you need to 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.

To deploy the report package on the Report Portal

  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. Create a System DSN for the CA ControlMinder reporting database and specify to use Windows NT Authentication.

    The system DSN you create is used to connect to the CA ControlMinder reporting database.You specify the system DSN when you configure the report package.

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

    Defines the type of RDBMS used for CA ControlMinder reporting.

    Value: MSSQL2005.

    import_biar_config.xml

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

    Value: 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. It is set by default to the name of the English version for your RDBMS.

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

    Important! Remove the user name, password and server fields from the file.

    <biar-file name>

    Defines the full pathname to the CA ControlMinder reports file (.biar). This is the file that you copied in the previous step.

    <networklayer>

    Defines the network layer supported by your RDBMS.

    Value: ODBC.

    <rdms>

    Defines the type of RDBMS used for CA ControlMinder reporting.

    Value: Generic ODBC datasource

    <datasource>

    Defines the DSN you created

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

  8. Open a command prompt window 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_mssql_2005.xml
    

Example: Sample Microsoft SQL Server 2005 Import Configuration File Configured to use Windows Authentication

The following code snippet is an example of an edited import configuration file (import_biar_config_mssql2005.xml) for MS SQL Server 2005 you deploy on a Report Portal that works in Windows Authentication:

<?xml version="1.0"?>
<biconfig version="1.0">
	<step priority="1">
		<add>
			<biar-file name="c:\temp\biconfig\
			AccessControl_R12.5_EN_JP_KR_SQL_6_DEC_2009.biar">
				<networklayer>ODBC</networklayer>
				<rdms>Generic ODBC datasource</rdms>
				<datasource>acdb</datasource>
			</biar-file>
		</add>
	</step>
</biconfig>