workbench generate command

Use the istool command workbench generate to generate a file in an Asset Interchange (ISX) format from an import file that is in a comma-separated value (CSV) format.

Purpose

Use this command to create an import file in an ISX format from a file that is in a CSV format. You generate a file in an ISX format to later import database, data file, BI report, and BI model assets. This command does not import the generated ISX file.

Requirements

The CSV import file must follow the correct syntax. To download templates of CSV files for database, data file, and BI report assets, see this techdoc.
You must have Write and Create access to the directory of the ISX file.
You must have the Information Governance Catalog Information Asset Administrator or the Information Governance Catalog Information Asset User role.
The version of istool command framework must be the same version as IBM® InfoSphere® Information Governance Catalog.
Run the command from the client tier, or from the engine tier if InfoSphere Information Governance Catalog was installed there.

Command syntax

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.

istool> workbench generate
authentication parameters
archive parameter archive_file_name
-input input_CSV_file
-log log_file
[generic parameters]

Parameters

These parameters are specific to the workbench generate command. For authentication parameters and generic parameters, see Common commands and parameters.

-input | -i input_CSV_file: Specifies the complete or relative directory path and name of the CSV file to use to generate the ISX file. You can specify the directory path of a single file or the directory path that has multiple CSV files.
-log | -l log_file: Specifies the complete or relative directory path and the name of the log file. If the log file exists, the output from the run is appended. If the log file does not exist, it is created.

Output

A return value of 0 indicates successful completion; any other value indicates failure. The reason for the failure is displayed in a screen message.

For more information, see the system log file in either of the following directories:

For Microsoft Windows operating system environment: C:\Documents and Settings\username\istool_workspace\.metadata\.log; where username is the name of the operating system account of the user who runs this command.
For UNIX or Linux operating system environment: user_home/username/istool_workspace/.metadata/.log; where user_home is the root directory of all user accounts, and username is the name of the operating system account of the user who runs this command.

Example

This command runs the generate command to create an ISX import file from the CSV file C:\IBM\InformationServer\imports\DB.csv:

istool> workbench generate 
-dom mysys
-u myid -p mypassword 
-i C:\IBM\InformationServer\imports\DB.csv
-ar C:\IBM\InformationServer\imports
-l C:\IBM\InformationServer\logs