This section explains each of the properties in the configuration blade.
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.
Use Connection Variables
Tick to use saved variables for the authentication properties; or enter the text manually.
The MySQL server name / IP address.
e.g. localhost / 127.0.0.1
The MySQL login username.
The MySQL login password.
A list of Schemas to be selected.
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.
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.
New records created between each interval will be available on this endpoint with attributes matching the configured schema in the selected table.
If errors are encountered during the execution of this Agent they will be published on this endpoint.