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.

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