export asset values command
You can export values of properties and custom attributes of information assets, excluding extended data sources and extension mapping documents, into the file that is in a comma-separated value (CSV) format. Use the istool export asset values command.
Purpose
Use this command to export properties and custom attribute values of information assets, or when you want to schedule an export.
Do not use this command to export extended data sources and extension mapping documents. To export those asset types, use the istool export command. For the full list of supported asset types for which you can export asset values, see Asset types that you can import and export.
Prerequisites
You must have the Information Governance Catalog Information Asset Administrator role.
IBM® InfoSphere® Information Governance Catalog must be installed on the same server as IBM WebSphere® Application Server.
The version of istool command framework must be the same version as 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 before the command name.
Command syntax
export asset values
authentication parameters
[generic parameters]
-directory dir_name
-output log_file_name
-type asset_REST_name
[-pattern]
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.
- -directory | -dir dir_name
- Specifies the directory to contain the export file.
- -output | -o log_file_name
- Specifies the name of the log file that contains the output, including errors, of the command that was run. Include the directory path in log_file_name.
- -type | -t asset_REST_name
- The REST name of the asset type.
- -pattern | -pt
- The pattern to match the asset type name. Put the pattern in double quotation marks ("). You can use a percent (%) or an asterisk (*) as wildcard characters.
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 Microsoft Windows operating system environment
- C:\Documents and Settings\username\istool_workspace\.metadata\.log
- For UNIX or Linux® operating system environment
- user_home/username/istool_workspace/.metadata/.log
Additionally, see the workbench_cli.log file. This log file is located in the directory from which you ran the command.
Example
a_. The REST name for database table is database_table.
export asset values -dom localhost:9445 -u my_user -p my_password -type database_table
-pt "a_*" -dir C:\tmp -o C:\tmp\log.log