Example

An example Data Stream that demonstrates how to use this Listener to return data readings from a SQL Server database table.

Refer to configuration to understand all configuration options of this Agent.

Drag the SQL Server Listener onto the canvas, link up the Output Endpoint to the Event Printer Action Agent, then Save the Data Stream.

Select the Agent and click Configure.

Enter the the Polling Interval, in seconds, for the Listener.

Enter the Authentication details of the SQL Server to connect to.

From the Database dropdown, select the database to connect to.

From the Table dropdown, select the table to connect to.

Select which columns should be returned.

Select the column to use as the timestamp property.

Click Apply and Save the Data Stream.

Click Publish.

Click Live View to view the output of the Agent. The Agent will check the table at the configured polling interval and return any new rows that have been added to the table since the last poll.

Files

See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.

Last updated