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

1. Drag the Azure SQL Action Agent onto the canvas.

2. Rename the Agent and link the input endpoint to the event data.

3. Save the Data Stream.

Step 2: Configure General

1. Select the Agent and click Configure.

2. 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

1. Select the Database.

2. Select the Table

3. Select Command. In this case, keep the default insert command.

4. Apply the changes and save the Data Stream,

Step 5: Input Mapping

1. Select the Azure SQL Action Agent's input arrow.

2. Click Configure.

3. Map one of the parent Agent's output attributes to each input attribute, which is fetched from the Azure SQL table.

4. Apply the changes and save the Data Stream,

Step 6: Results

Publish it. 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

File	Link	Security Key
Data Stream	Azure SQL Action Agent Example.xuc	C0mp|ex123

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