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

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. |
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. |
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. |
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. |
Last modified 1yr ago