How to Export Table Extraction Values Using DB Export

Applies to: All versions of Ephesoft Transact

This page describes how to export extracted values from Table Extraction to your database using the DB Export plugin.

Prerequisites

The following prerequisites must be met before continuing:

  1. The Table Extraction plugin should be added to the Extraction module for your batch class and set to ON.
  2. The DB Export Plugin should be added to the Export module for your batch class and set to ON.
  3. A valid database connection has been established in System Configuration > Connection Manager.
  4. Table Extraction has been configured. For more information, refer to Table Extraction Plugin.
  5. You should have a valid database table to store the extracted values.

Instructions

  1. From the Batch Class Management screen, select your batch class and click Open.
  2. Go to Document Type > DB Export Configuration.
  3. Click Table Mapping.
  4. Map the table column names with the database column names.
  5. Run a batch instance and validate the extracted values.

The values will be automatically exported to your configured database.