Import command for reporting assets
You can use the istool export command with the -report parameter to import your reporting assets from a file that contains previously exported assets. These assets can include both report designs and report results.
Purpose
You import reports from an archive file that has the .isx extension.Reports that are created by InfoSphere Information Governance Dashboard cannot be transferred by using the istool command line. Reports created by InfoSphere Business Glossary cannot be imported by using istool.
Prerequisites
To import a report or report results, you must have the role of Suite Administrator, or have read permissions for the template that the report is based on. After the import, you are the owner of that report and have administration, read, and write permissions.
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, [ ].
import
authentication
[generic parameters]
[-abortAfter number_of_errors]
-archive file_name_and_path
[-preview] | -replace
[-responseFile "file_name_and_path"]
-report
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.
- -abortAfter | -abort number_of_errors
- Stops the import after the specified number of errors.
- -report
- Required Specifies that report assets are imported.
- -archive | -ar file_name_and_path
- Required. Specifies the .isx file to import assets from.
- -preview | -pre
- Previews the import. The preview lists the assets that will be imported when the import runs. The assets are not imported when you run a command with the -preview parameter.
- -replace
- Required. If you specify the -replace parameter, and an asset with the same identity exists in the target metadata repository, the existing asset is replaced by or merged with the imported asset, depending on the type of asset. The -replace parameter must be specified for all reporting imports, regardless of whether there are existing assets in the metadata repository.
- -responseFile | -rf "file_name_and_path"
- Specifies the name and path of a response file that contains assets that failed to import during a run of a previous istool import -report command. Not supported with the -preview parameter. For more information, see Using a response file with istool export and istool import commands.
Example
import -domain qakserv:9443 -username user1 -password pass1
-report -archive "c:\MDBds_001.isx" -preview
import -domain qakserv:9443 -username user1 -password pass1
-report -archive "c:\MDBds_001.isx" -replace
Importing multiple types of assets
If the archive file to be imported includes multiple types of assets, you must specify each type of included metadata on the command line when you import the archive file, otherwise only reporting assets are imported. For example, if the archive includes InfoSphere Information Analyzer assets and common metadata assets, you must specify the -ia and -cm options in addition to the -rep options when you import the archive. Use separate import commands for each type of asset for best performance.
- Users and groups
- Common metadata
- InfoSphere DataStage® and QualityStage® assets.
- Reports.
- InfoSphere Information Analyzer assets.
- InfoSphere FastTrack assets.
- InfoSphere Information Governance Catalog extended data sources.
- InfoSphere Information Governance Catalog extension mapping documents.
- InfoSphere Information Governance Catalog business glossary assets. In versions earlier than 11.3, these assets are created in InfoSphere Business Glossary.
- Custom attributes for InfoSphere Information Governance Catalog extended data sources and extension mappings. In versions earlier than 11.3, these assets are created in InfoSphere Metadata Workbench.
Using the -replace option
import> -u admin -p admin100 -dom EVEREST -ar ia_archive1.isx
-ia '' -cm ''
import> -u admin -p admin100 -dom EVEREST -ar ia_archive1.isx
-replace -rep