Export command for reporting assets

You can use the istool export command with the -report parameter to export your IBM® InfoSphere® Information Server reporting assets. These assets can include both report designs and report results.

Purpose

The reporting asset interchange commands export reports from your InfoSphere Information Server installation. You can identify the reports to export by using the following methods:

Export all the reports associated with a particular suite component.
Export reports by name. You can specify wildcards as part of the report name.

You can also specify that the export includes the report results as well as the design details of a report.

Exporting all reports at the same time to an archive file can be resource-intensive. If you want to export all reports for migration purposes, use the -ownedByProduct option to export all reports with separate commands for each product.

Note: Reports that are created by InfoSphere Information Governance Dashboard cannot be transferred by using the istool command line.

To transfer all assets of all types, see Moving all assets from one metadata repository to another

Prerequisites

To export a report or report results, you must have administration, read, and update permissions for that report. The creator of a report automatically has administration, read, and update permissions, and can grant permissions to other users or groups. A user with the Suite Administrator role can export any reports.

The preferred way to run this command is in the istool command-line window. If you run this command in your operating system command-line window or in scripts, you must add istool to the command name.

Command syntax

Optional parameters and values in the syntax are enclosed in brackets, [ ].

export 
authentication
[generic paramters]
-archive "file_name_and_path" 
[-maxArchiveSize number_of_megabytes]
[-updatearchive] 
[-abortIfError number_of_errors]
[-responseFile "file_name_and_path"]
-report   
'-reportName "report_name"  
		[-ownedByProduct "product_name"]
		[-includeLastReportResults number_of_results |
		-includeAllReportResults |
		-includeReportResultName report_result_name]'
|
'-ownedByProduct "product_name"  
		[-reportName "report_name"]
		[-includeLastReportResults number_of_results |
		-includeAllReportResults |
		-includeReportResultName report_result_name]'

Parameters

authentication parameters

Required. All asset interchange commands use authentication parameters to connect to a specific installation of InfoSphere Information Server.

generic parameters

The generic parameters are available to all asset interchange commands. Use the generic parameters to request help on command syntax, to specify silent or verbose operation, and to use a script to run commands.

-archive |-ar "file_name_and_path"

Required. Specifies the .isx file that the assets are exported to.

-maxArchiveSize | -mas number_of_megabytes

For enhanced export and import performance, creates additional archive files when the size of the export file exceeds the specified number of megabytes. For example, if you specify 500 and the total size of the export is 1,300 MB, two additional archive files are created with numeric suffixes added to their names. For import, specifying the first archive file imports all. For more information, see common parameters.

-updatearchive | -up

Adds exported assets to the archive file if it exists. If you do not specify -updatearchive, the content of the existing archive file is overwritten.

-abortIfError | -abort number_of_errors

Stops the export after the specified number of errors.

-responseFile | -rf "file_name_and_path"

Specifies the name and path of a response file that contains assets that failed to export during a run of a previous istool export -report command. Not supported with the -preview parameter. For more information, see Using a response file with istool export and istool import commands.

-report

Required. Specifies that report assets are exported. Must be followed by either -reportName or -ownedByProduct.

-reportName | -repName "report_name"

Exports reports by name. The argument report_name can include wildcard characters. For example,

 -reportName "MyRep*"

exports the reports MyRep1, MyRep2, and MyRepTues. If you specify this parameter together with the -ownedByProduct parameter, reports that specify both criteria are exported.

-ownedByProduct | -prod "product_name"

Exports the reports that are associated with the specified suite component. If you specify this parameter together with the -reportName parameter, reports that satisfy both criteria are exported. You can use the following values:

Administration
FastTrack
Information Analyzer
QualityStage

-includeLastReportResults | -incLastResult number_of_results

Exports the specified number of report results along with the report design that you specified by using the -reportName or -product_name parameters. For example,

-reportName "MyRep1" -includeLastReportResults 20

exports the report design for MyRep1 together with the 20 most recent results for that report.

-includeAllReportResults | -incAllResults

Exports all results along with the report design that you specified by using the -reportName or -prod parameters. For example,

-reportName "MyRep1" -includeAllReportResults

exports the report design for MyRep1 together with all the results for that report.

-includeReportResultName | -incResultName "report_name"

Exports the most recent results for the report that is specified by report_name. You can use wildcards in report_name to return results for a number of reports. For example,

-includeReportResultName "MyRep*"

exports the most recent results for the reports MyRep1, MyRep2, and MyRep15.

Exit status

A return value of 0 indicates successful completion; any other value indicates failure.

Examples

For best performance when exporting all reports, run separate commands, each specifying a different value for the -ownedByProduct option. The following command exports all the Administration reports and report results to the archive file ExportAllReports.isx.

export -report '-reportName "*" -includeAllReportResults -ownedByProduct 
"Administration"' -domain 
server_host:server_port -username user -password 
password -archive ExportAllReports.isx

The following command exports all the InfoSphere QualityStage reports on the qakserv system to the archive, QSRAI_001.isx.

export -domain qakserv:9443 -username user1 -password pass1 
-archive "c:/QSRAI_001.isx" -report '-prod "QualityStage"'

The following command exports the report named FreqPat to the archive QSRAI_001.isx.

export -domain qakserv:9443 -username user1 -password pass1 
-archive "c:/QSRAI_002.isx"  -report '-reportName "FreqPat"'