Running the Managed Reporting Extract Utility

How to:

The Managed Reporting Extract utility is run on the machine where WebFOCUS is installed. You can use Telnet or another form of remote access to execute the utility when it is not possible to physically be at the WebFOCUS machine. For convenience, a batch file is provided to call the utility with standard arguments.

Note: If you are using the Realm Driver to authenticate to another directory, you need to modify the batch file (mrextract.bat) so that the classpath includes the necessary .jar files.


Top of page

x
Procedure: How to Run the Managed Reporting Extract Utility
  1. Navigate to the WebFOCUS77\utilities directory.
  2. Execute the mrextract.bat file (Windows systems) or mrextract file (UNIX systems).

    A series of messages appear:

    -----------------------------------------------
     Managed Reporting Repository Extract Utility
     WebFOCUS Release 7
    -----------------------------------------------
    Extracting MR User Data...
    Extracting MR Role Data...
    Extracting MR Group Data...
    Extracting MR Domain Data...
    Extracting MR Domain Content Data...
    Finished.
    Press any key to continue . . .

    The utility creates the output files in the WebFOCUS77\utilities directory. For information about the format of these files, see Managed Reporting Extract Utility Output Files. For information about reporting from these files with WebFOCUS, see Reporting From Extract Files.


Top of page

x
Syntax: How to Call IBIExtractRepos Programmatically

The underlying program that extracts information from the Managed Reporting Repository is written in Java and is contained in the archive WebFOCUS77\utilities\IBIExtractRepos.jar.

You call the program by using the following arguments

java –cp archivepath ibi.util.IBIExtractRepos configpath option [option] 
> outputfile

where:

archivepath

Is the full or relative path to the IBIExtractRepos.jar file and a number of other supporting jar files, depending on your configuration. For details, review the contents of mrextract.bat (mrextract on UNIX) in the WebFOCUS77\utilities directory.

configpath

Is the full or relative path to the directory containing the WebFOCUS Web application deployment descriptor web.xml file (for example, d:\ibi\WebFOCUS77\webapps\webfocus\WEB-INF). From this file, the value of webfocus_client_root is read and used to determine the location of the WebFOCUS script files.

option

Program options include [-users] [-roles] [-groups] [-domains] [-domaincontent].

>

Redirects the utility output to a file.

outputfile

The name of the output file.

You can tailor the extract utility for your own purposes.


WebFOCUS