Example
This example Data Stream demonstrates how to use the Listener to return data readings from an Azure SQL database table.
Refer to configuration to understand all configuration options of this Agent.
Step 1: Add the Agent
Drag the Azure SQL Listener onto the canvas, link the output endpoint to the printer, and save the Data Stream.
Step 2: Configure General
Select the Agent and click Configure. In this case, keep the default Collection and polling interval.
Step 3: Configure Server
Enter the Authentication details of the Azure SQL database to which you want to connect: server instance, user name, and password.
Step 4: Configure Database
Select the database.
Select the table.
Select which columns should be returned.
Step 5: Configure Timestamp
Select the column that is used to determine which rows are new since the last poll.
Step 6: Results
Apply the changes and save the Data Stream.
Click Publish.
Let's look at the Live Data View. Observe that the table is checked at the configured polling interval and any new rows added to the table since the last poll are printed.
Files
See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.
Last updated