Example
Last updated
Last updated
This example Data Stream demonstrates how to use the Context Provider to return contextual data from an Azure SQL database table.
Refer to configuration to understand all configuration options of this Agent.
Drag the Azure SQL Context Provider onto the canvas, link the output endpoint to the printer, and save the Data Stream.
Select the Agent and click Configure. In this case, keep the default Collection and polling interval.
Enter the Authentication details of the Azure SQL database to which you want to connect: server instance, user name, and password.
Select the database.
Select the table.
Select which columns should be returned.
Apply the changes and save the Data Stream.
Click Publish.
Let's look at the Live Data View. Observe that all rows from the Azure SQL table are printed.
See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.
Data Stream
C0mp|ex123