Using Bulk Load Tool

With this tool, you can load the relationship data or the entity data in bulk.

Prerequisites

Ensure that the SmartMapper Tools component is selected when installing the plug-in.
Note: Ensure that the data to be loaded conform to rules described in Data Format.

Procedure

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

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

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

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

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

    bulkload -db <db config> -f <filename> -r | -e

    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: The entity and relationship data cannot be loaded simultaneously. That is, each time you run this tool, only one type of data can be loaded, either entity or relationship.

Result

A log file named bulk_load.log is generated in the TIBCO_HOME\bw\palettes\smartmapper\7.1\tools\logs directory after running the tool.
  • Data Format
    When using Bulk Load tool, the data to load must conform to the specific rules.