SQL Query Builder

The ODBC Lookup configuration tool is an easy-to-use utility for building ODBC SQL commands. Alternatively, an SQL command can be manually written. To run the configuration tool, select Build Lookup.

Database Connection

There are 2 types of connections that can be configured.

1. DSN - make sure the DSN you use is setup as a 64bit connection and is of the type System DSN (not a User DSN etc). DSNs that don't meet this criteria will not be available in the list for selection.
2. Connection String - Make sure an ODBC connection string is used.

Make sure that the Umango Windows Service Logon Account has the necessary permissions to access the database connection. This is often an issue that is overlooked and causes problems with connectivity.

Data Field

Once a database connection is selected, the data fields become enabled for selection and configuration. The user can select the related options from the configuration fields based on the capture rule they require.

Alternatively, the Edit SQL button provides more technically savvy users a way of writing their SQL command directly and insert mergeable values into the command.