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
- 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.
- Select Existing table and specify a table to store the data, or select Existing table to let the system create a new table.
-
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
-