Using Bulk Extract Tool

This tool allows you to extract the relationship data or the entity data in bulk.

1. On a command line, navigate to the directory in which the SmartMapper tools reside.

   • On Windows, the directory is TIBCO_HOME\bw\palettes\smartmapper\7.0\tools.

   • On Linux, the directory is TIBCO_HOME/bw/palettes/smartmapper/7.0/tools.

   • On Mac OS, the directory is TIBCO_HOME/bw/palettes/smartmapper/7.0/tools.

2. Enter bulkextract on the command line and press Enter to get help information.
3. Enter the following command to load the desired entity or relationship:

   bulkextract -db <dbconfig> -f <filename> -r <relname> | -e <entityname> [-c <criteria>]

   Note: On Linux and Mac OS, if you use Microsoft SQL Server to run the tool, make sure you enclose the database URL in quotation marks ("), unless you use the db.properties file to configure the database connection.

   See more information in Parameters for SmartMapper Tools.

   Note: Entities (-e) and relationships (-r) cannot be extracted simultaneously. That is, each time you run this tool, only one type of data can be extracted, either entity or relationship.