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 to query the database table for new records. e.g. every ten seconds.

Visit Collections and Stream Hosts to understand more about Collections.

Server Details

PropertyDescription

Use Connection Variables

Tick to use saved variables for the authentication properties; or enter the text manually.

Hostname

The MySQL server name / IP address.

e.g. localhost / 127.0.0.1

Username

The MySQL login username.

Password

The MySQL login password.

Database

PropertyDescription

Schema

A list of Schemas to be selected.

Table Name

The name of the table to connect to. Once selected, the Timestamp Columns property will be populated with the list of columns from the selected table.

Timestamp Column

A sequential unique ID column e.g. Auto Increment Column / DateTime Column.

This column is used to determine whether a new record has been created in the table since the last poll. If there are new records since the last poll the Agent will return the new records as output.

Endpoints

NameDescription

Output

New records created between each interval will be available on this endpoint with attributes matching the configured schema in the selected table.

Error

If errors are encountered during the execution of this Agent they will be published on this endpoint.

Last updated