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 table is checked for new rows, e.g. every ten seconds. |
Visit Collections and Stream Hosts to understand more about Collections.
Server
| Property | Description |
|---|---|
Use Connection Variables | Tick to select saved variables; or enter the text manually for the authentication properties. |
Server Instance | The address of the SQL Server server instance. |
User Name | The user name to use for authenticating the connection. |
Use SQL Server Authentication | Tick to use SQL Server Authentication instead of Windows Authentication. This will allow you to specify the Password for authentication of the connection. |
Password | The password to use for authenticating the connection. |
Once all the Server properties are entered, the Agent will attempt to open a connection with the database server. If successful, then the Database field will be populated with a list of available databases to select.
Database
| Property | Description |
|---|---|
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. |
Table | The name of the table to connect to. Once selected, the Columns To Return field 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. |
Timestamp
| Property | Description |
|---|---|
Column | The column or attribute of the input payload to use when distinguishing new rows from older rows. Ideally, the selected column should have a unique, incrementing value for each new row. |
Endpoints
| Name | Description |
|---|---|
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. |
Last updated
