Lookup table definition: Database lookup
Lookup is supported in the translation TABLE action and as a dblookup Tcl extension. It uses the Database Schema Configurator to configure database connections. It also uses the Lookup Table Configurator to configure the Database Lookup SQL statement and IN/OUT column list.
The Database Lookup feature uses the xlate engine to look up the matched values through the database.
New configurations are saved as a .tbl file.
The Translation Configurator applies the .tbl file in a Table action.
During runtime, the translation engine applies the source field values to the query statement that is defined in the .tbl file. It uses this to look up the specified output value.
Database Lookup action in translation
The
options in the Lookup Table Configurator use the TABLE action to do the lookup. The tables use column name and value address mapping. Multiple sources to multiple destinations are supported.Information storage
The DBLookup.jar file is located in the $HCIROOT/lib/java folder.