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 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