Import command for InfoSphere DataStage and QualityStage assets

You can use the istool command line interface (CLI) to import assets from a previously exported archive file.


Use the InfoSphere® DataStage® command option with the istool import command to import IBM® InfoSphere DataStage and QualityStage® assets from an archive file to the metadata repository of IBM InfoSphere Information Server. This command is the reverse of the export command.


To import InfoSphere DataStage and QualityStage assets you must have a role that grants you permission to edit assets in the target project. To include related common metadata assets in the import, you must have the Common Metadata Administrator role.

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 before the command name.

Command syntax

authentication options
[generic options]
-archive file_name_and_path 
[-preview | -replace]
[-responseFile "file_name_and_path"]
[-abortAfter number_of_errors]
-datastage '

Command options

authentication parameters
All asset interchange commands use authentication options to connect to a specific installation of InfoSphere Information Server.
generic parameters
The generic parameters are available by all asset interchange commands. Use the generic options to request help on command syntax, or to specify silent or verbose operation.
-archive |-ar "asset_pathname"
Required. Specifies the .isx file to import assets from.
-preview |-pre
Specify this option to preview the action of the command without changing the repository.
Specify this option to replace existing assets with imported assets of the same identity.
-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 -ds command. Not supported with the -preview parameter. For more information, see Using a response file with istool export and istool import commands.
-abortAfter | -abort number_of_errors
Stops the import stops after the specified number of errors.
-datastage | -ds ' "server/project" '
Specifies that InfoSphere DataStage and QualityStage assets are to be imported to the target server and project. You can use the following option within the single quotation marks (' ') that follow the -datastage parameter:
Specifies that only job executables are imported, not job designs.

Importing multiple types of assets

If the archive file 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 InfoSphere DataStage and QualityStage assets are imported. For example, if the archive was exported with the -includedependent option, it could include common metadata assets.

The following commands import assets from the archive file arc.isx in the correct order. The common metadata assets are imported first. The InfoSphere DataStage and QualityStage assets are then imported to the project aProj on the server slice.
import –domain
-username user1 -password pass1
-archive "c:\arc.isx" 	-cm '' 

import –domain
-username user1 -password pass1 
-archive "c:\arc.isx" 	-datastage ' "slice/aProj" '  
Archive files can contain assets from multiple exports of multiple tools. For best performance, when you import from an archive file, or when you migrate assets of varying types in multiple archive files, run separate commands to import the following types of assets in the following order:
  1. Users and groups
  2. Common metadata
  3. InfoSphere DataStage and QualityStage assets.
  4. Reports.
  5. InfoSphere Information Analyzer assets.
  6. InfoSphere FastTrack assets.
  7. InfoSphere Information Governance Catalog extended data sources.
  8. InfoSphere Information Governance Catalog extension mapping documents.
  9. InfoSphere Information Governance Catalog business glossary assets. In versions earlier than 11.3, these assets are created in InfoSphere Business Glossary.
  10. 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.
Asset types not listed can be imported in any order.

Importing standardization rule sets into multiple projects

If an archive file contains only standardization rule sets from InfoSphere QualityStage, you can import the rule sets into more than one project at the same time.

You can use an asterisk (*) as a wildcard character to indicate the projects that you want to import the rule sets into. For example, the following command imports the rule sets into all projects on the server:

import –domain
-username isadmin -password isadmin
-archive "c:\arc.isx" 	-datastage ' "*" '

The following command imports the rule sets into the projects on the server that begin with the letter X:

import –domain
-username isadmin -password isadmin
-archive "c:\arc.isx" 	-datastage ' "*" '

Exit status

A return value of 0 indicates successful completion, any other value indicates failure. The list of exit codes is shown in the command help. Enter istool import -help to see the list of possible exit codes for the import command.

Error handling

When importing from an archive file that contains more than one object, a single failure does not interrupt the operation. The exit status reports an error if one or more objects cannot be imported.


The following command previews an import of assets from the file arc.isx. No assets are imported. Job designs are not included.
import –domain sliver:9443
-username user1 -password pass1
-archive "c:\arc.isx" -pre  -datastage ' -nodesign "slice/aProj" '
After the preview, the command is repeated without the -preview option to import the assets to the project named aProj located on the computer named slice. The InfoSphere Information Server engine on slice is associated with the computer named sliver on the services tier.
import –domain
-username user1 -password pass1
-archive "c:\arc.isx" 	-datastage ' -nodesign "slice/aProj" '