An example Data Stream that demonstrates how to use this Listener to return data readings from a SQL Server database table.
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 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.
SQL Server Listener Example.xuc