Example

An example Data Stream that demonstrates how to use this Context Provider to return contextual data from a SQL Server database table can be found below.

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

Drag the SQL Server Context Provider 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 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.

Click Apply and Save the Data Stream.

Click Publish.

Click Live View to view the output of the Agent. The Agent will produce an output if the configured table contains data.

Files

File	Link	Security Key
Data Stream	SQL Server CP Example.xuc	C0mp|ex123

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