workbench generate command

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

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.

Prerequisites

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.

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 optional values in the syntax are enclosed in brackets, [ ].

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

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.
-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:

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