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 is read from the  table, e.g. every ten seconds.
Refer to Collections and Stream Hosts to understand more about Collections.
Server
Property
Description
DSN
The name that was given to the DSN setup within the ODBC Data Source Administrator.
Database
The name of the database to connect to.
Once selected, the Table field will be populated with the list of available tables in the database.
Use Authentication
More often than not, the authentication will be baked into the DSN so there will not be a need to use authentication to access the database. Tick to override the default authentication.
User Name
The user name to use for authenticating the connection.
Password
The password to use for authenticating the connection.
Database
Property
Description
Table
The name of the table to read.
Filtering & Sorting
Property
Description
Filters
An optional rule to filter the return results.
Limit Rows Returned
An optional limit on the number of returned rows e.g. the first 100 rows.
Sort By Column
One or more columns by which the returned results are sorted.
Sort By Order
Choose whether results are sorted in ascending or descending order.
Endpoints
Name
Description
Output
The read events will be made available on this endpoint with attributes matching the columns from the table selected.
Error
Errors encountered during the execution of this Agent 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 the data is read from the table, e.g. every ten seconds.

Property	Description
DSN	The name that was given to the DSN setup within the ODBC Data Source Administrator.
Database	The name of the database to connect to. Once selected, the Table field will be populated with the list of available tables in the database.
Use Authentication	More often than not, the authentication will be baked into the DSN so there will not be a need to use authentication to access the database. Tick to override the default authentication.
User Name	The user name to use for authenticating the connection.
Password	The password to use for authenticating the connection.

Property	Description
Table	The name of the table to read.

Property	Description
Filters	An optional rule to filter the return results.
Limit Rows Returned	An optional limit on the number of returned rows e.g. the first 100 rows.
Sort By Column	One or more columns by which the returned results are sorted.
Sort By Order	Choose whether results are sorted in ascending or descending order.

Name	Description
Output	The read events will be made available on this endpoint with attributes matching the columns from the table selected.
Error	Errors encountered during the execution of this Agent will be published on this endpoint.

Last modified 1yr ago