DB Export Configuration

Overview

DB_EXPORT plugin is responsible for saving the data of document level fields or tables for a particular batch instance to the external or same database.

Configuration

Select Export module. Navigate to the DB_EXPORT plugin configuration page as shown below:

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10001.jpg

Configurable properties

The following are the configurable properties available with the plugin:

Configurable property Type of value Value options Description
Database Export Switch List of values
  • ON
  • OFF
The switch that defines whether this plugin will run or not. Default value is “OFF”

Export Document Level Fields

The user can map the document level fields with the table column of a database table to export the document level fields of a batch class.

DLF Mappings

Click DLF Mapping to display the following UI:

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10010.jpg

To map the DLFs with the columns of a database table, perform the following steps:

  • Select a database connection that can be configured from System Config Screen.
  • Click Add. The following UI will be presented to map the DLFs with columns of database table:

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10011.jpg

  • On this screen, the user can map a DLF with a column of database table of a particular database.

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10012.jpg

  • The user can configure some Additional Parameter mapping.

Export Tables

The user can map the columns of tables of a batch class with the table column of a database table to export the tables of a batch class.

Table Mappings

Click Table Mapping to view the following UI.

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10018.jpg

To map the table columns with the columns of a database table, User can follow the below given steps:

  • Select a database connection that can be configured from System Config Screen.
  • Click the Add button. The following UI will be presented to map the table columns with columns of database table:

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10020.jpg

  • On this screen, the user can map table columns with a column of database table of a particular database.

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10019.jpg

  • User can configure some Additional Parameter mapping.

Additional Parameter Mapping

User can configure some additional parameter with DLF/Table Mapping.

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10022.jpg

User can map additional parameters with column of database Table.

C:\Users\gajendrayadav\Desktop\Screen shots\4.0.0.0_DBExport_10023.jpg

Dependency

The plugin requires the following prerequisites:

  • The plugin does depend on any other plugin, but the desired output comes only when the document level field has some extracted value.
  • If the “Database Export Switch” is ON, then the mapping provided should be correct. Invalid mapping will result in batch going to error.