Example

An example Data Stream that demonstrates how to use this Action Agent to write event data to a table in a SQL Server database.

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

Step 1: Add the Agent

1. Drag the SQL Server Writer 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 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 SQL Server Writer 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 SQL table.

4. Apply the changes and save the Data Stream,

elect which columns should be returned.

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 SQL database.

Files

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

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