Example

This example Data Stream demonstrates how to use the Action Agent to write event data to a table in an Azure SQL database.

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

Step 1: Add the Agent

Drag the Azure SQL Action Agent onto the canvas and link the input endpoint to the event data. Rename the Agent and save the Data Stream.

Step 2: Configure General

Select the Agent and click Configure. In this case, keep the default Collection.

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 and command. In this case, keep the default insert command.

Step 5: Input Mapping

Select the Azure SQL Action Agent's input arrow and click Configure. Map one of the parent Agent's output attributes to each input attribute, which is fetched from the Azure SQL table.

Step 6: Results

Apply the changes and save the Data Stream.

Click Publish.

Let's look at the Live Data View. Observe the event data is printed, as well as written to the Event table in the Azure SQL database.

Files

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

Last updated