SYNOPSIS

Input

[It reads from a database]

Output

A set of records reflecting the contents of a database table.

DESCRIPTION

This is the tool needed to look up information from a database and join into a stream. You select a table from a database, and this tool can look up a record from the table on the request of the join tool.

Note

This tool, together with other ODBC tools, has a simple database editor/viewer built in that can be utilized for setting up the table needed for operation.

As a prerequisite you will need to have the IP of your server, and have created a database on the server.

At the time of writing, the following databases are supported: MSSQL, MySQL, PostgreSQL, Sybase.

OPTIONS

Various options

The options are decided by the ODBC driver. Most are intuitive, some are not, but can often just be left at their default.

Each driver may vary in how they name the fields that need to be filled in. One may call the username UID, and another just Username, etc.

Table

The table you wish to access.