ODBC
HomeContact Support
  • ODBC
  • Listener
    • Example
    • Configuration
  • Context Provider
    • Example
    • Configuration
Powered by GitBook
On this page
  • General
  • Server
  • Database
  • Filtering & Sorting
  • Endpoints
  1. Context Provider

Configuration

PreviousExample

Last updated 3 years ago

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.

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.

Refer to to understand more about Collections.

Collections and Stream Hosts