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 the data cache is refreshed during runtime - which depends how often your data changes e.g. hourly.
Visit Collections and Stream Hosts to understand more about Collections.

Server Details

Property
Description
Use Connection Variables
Tick to select saved variables; or enter the text manually for server connection properties.
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 Columns To Return property will be populated with the list of columns from the selected table.
Columns to Return
The columns which the Agent should return. If no columns are specified, the Agent will return all the columns from the table.

Filtering & Sorting

Property
Description
Limit Rows By
Optional criteria for limiting the output.
Available Options:
  • Number of Rows
  • Duration (required the table to have a DateTime column)
  • None (All qualified rows will be returned)
Defaulted to None.
Number of Rows
Limit the number of rows to be returned based on the value.
Applies when Limit Rows By selected as Number of Rows.
Duration Type
The metric of duration used for limiting the output.
  • Day
  • Hour
  • Minute
Defaulted to Day.
Applies when Limit Rows By property value is selected as Duration.
Duration Value
Limit the number of rows to be returned based on the Duration Value configured.
The value will be compared against the selected Timestamp Column. Applies when Limit Rows By property value is selected as Duration.
Timestamp Column
A list of DateTime columns in the selected table. Applies when Limit Rows By property value is selected as Duration.
Filter Criteria
The optional filter(s) applied to the database table contents, expressed with the column name, operator (Contains, Does not contain, Starts with, Ends with and Equals) and compare value.
Sort By
The attribute(s) by which the output should be sorted in Ascending / Descending order (optional).

Endpoints

Name
Description
Output
Records in the selected Table will be made available to this endpoint with attributes matching the configured schema.
Error
If errors are encountered during the execution of this Agent they will be published on this endpoint.