ODBC

Executes an SQL command on an ODBC database connection. Captured data values can be parsed into an SQL command for insertion into a database.

Settings

Connection

Identify a database connection. There are 2 types of connections that can be configured:

    1. Use a system DSN - Select a System DSN from the 64bit ODBC data sources. The System DSN must be configured prior to selection
    2. Use a connection string - Enter an ODBC connection string for the target database.

Note: Ensure that the Umango Windows Service Logon account has access to the connection selected.

SQL Command

Enter the SQL Command to be executed at each document export event. Merge text can also be added using the merge field. Ensure that all merged, non-numeric values are encased in single quotes (') when referenced as a value in a where clause or field assignment.

File Type Options

File Type Options and related information are available here.