workbench extension source export command
You can export extended data source assets from the metadata repository to a file that is in a comma-separated value (CSV) format by using the istool workbench extension source export command.
Purpose
Use this command to export extended data sources or to schedule an 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
workbench extension source export
authentication parameters
[generic parameters]
-directory directory_for export_file
-filename export_file_name
-pattern string_to_match
-type type_of_extension_source
-output log_file_name
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 directory_for export_file
- Specifies the name of the directory that contains the export file. The export file can be a single file in a CSV format. Alternatively, the export file can contain multiple files in a CSV format that are combined into a single file in a compressed format.
- -filename | -f export_file_name
- Specifies the name and directory path of the export file. The export file is in a CSV format. If the file already exists, the export overwrites the file.
- -pattern | -pt string_to_match
- Specifies the text pattern to match in the name of the extended data sources. Use the percent sign (%) as a wildcard character.
- -type | -t type_of_extension_source
- Specifies the type of extended data sources to export. The parameter is case-sensitive.
- -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.
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
Example
Example 1:
workbench extension source export
-dir E:\CLI\files
-o C:\IBM\InformationServer\logs\amount_due_export.log
-dom mysys
-u myid
-p mypassword
-pt %
-t Method
Example 2:
myAppto a file in a CSV format in directory E:\CLI\files. The log file is C:\IBM\InformationServer\logs\amount_due_export.log:
workbench extension source export
-dir E:\CLI\files
-o C:\IBM\InformationServer\logs\amount_due_export.log
-dom mysys
-u myid
-p mypassword
-t Application
-pt myApp%
Example 3:
workbench extension source export
-dir E:\CLI\all_files
-f App
-o C:\IBM\InformationServer\logs\all_EDS_files_export.log
-dom mysys
-u myid
-p mypassword
-pt %
-t Application
workbench extension source export
-dir E:\CLI\all_files
-f StoredProcedure
-o C:\IBM\InformationServer\logs\all_EDS_files_export.log
-dom mysys
-u myid
-p mypassword
-pt %
-t StoredProcedure
workbench extension source export
-dir E:\CLI\all_files
-f File
-o C:\IBM\InformationServer\logs\all_EDS_files_export.log
-dom mysys
-u myid
-p mypassword
-pt %
-t File