This section explains each of the properties in the configuration blade.
Visit Collections and Stream Hosts to understand more about Collections.
Once all the Server properties are entered, the agent will attempt to open a connection with the database server. If successful, then the Database property will be populated with a list of available databases to select.
Last updated
| Property | Description |
|---|---|
| Property | Description |
|---|---|
| Property | Description |
|---|---|
| Property | Description |
|---|---|
| Name | 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 table is checked for new rows, e.g. every ten seconds.
Use Connection Variables
Tick to select saved variables; or enter the text manually for the authentication properties.
Server Instance
The address of the Azure SQL server instance.
User Name
The user name to use for authenticating the connection.
Password
The password to use for authenticating the connection.
Database
The name of the database to connect to. Once selected, the Table property will be populated with the list of available tables in the database.
Table
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.
Column
The column to use when distinguishing new rows from older rows. Ideally, the selected column should have a unique, incrementing value for each new row.
Output
The read events will be made available on this Endpoint with attributes matching those specified in the Columns To Return property.
Error
If errors are encountered during the execution of this Agent they will be published on this Endpoint.
