Configure Database Mapping tab

Use this tab to set the mapping rules for file parsing. Each mapping defines the following:

  • A table in the Staging database to store the data

  • What to use as a primary key for that table

  • Rules to map specific document fields or record fields into the database table fields

  1. Navigate to the template and open the Database Mapping tab. In the Primary key field, select the field to use as the table, primary key, or select Autogenerate.
  2. Select Existing table and specify a table to store the data, or select Existing table to let the system create a new table.
  3. Click Create default mappings to define the initial default mapping.
    Field Mapping
    • FieldId: Old name of the field, name from source

    • Data type: Data type of the field values