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

General

Property
Description
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

Property
Description
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

Property
Description
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

Name
Description
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.