Configuration

This section explains each of the properties in the configuration blade.

General

PropertyDescription

Collection

This associates this Agent to a specific Collection and defaults to that of the current Data Stream.

Polling Interval (seconds)

This determines how often the table is checked for new rows, e.g. every ten seconds.

Refer to Collections and Stream Hosts to understand more about Collections.

Server

PropertyDescription

DSN

The name that was given to the DSN setup within the ODBC Data Source Administrator.

Database

The name of the database to connect to. Once selected, the Table field will be populated with the list of available tables in the database.

Use Authentication

More often than not, the authentication will be baked into the DSN so there will not be a need to use authentication to access the database. Tick to override the default authentication.

User Name

The user name to use for authenticating the connection.

Password

The password to use for authenticating the connection.

Database

PropertyDescription

Table

The name of the table to be monitored.

Timestamp

PropertyDescription

Column

The column from the selected table that is used to distinguish new rows from older rows. Ideally, the selected column should have a unique, incrementing value for each new row.

Endpoints

NameDescription

Output

The read events will be made available on this endpoint with attributes matching all the columns from the selected table.

Error

Errors are encountered during the execution of this Agent will be published on this endpoint.

Last updated