Example
Last updated
Last updated
An example Data Stream that demonstrates how to use this Action Agent to write event data to a table in a SQL Server database.
Drag the SQL Server Writer Action Agent onto the canvas.
Rename the Agent and link the input endpoint to the event data.
Save the Data Stream.
Select the Agent and click Configure.
In this case, keep the default Collection.
Enter the Authentication details of the SQL database to which you want to connect: Server Instance, User Name, and Password.
Select the Database.
Select the Table
Select Command. In this case, keep the default insert command.
Apply the changes and save the Data Stream,
Select the SQL Server Writer Action Agent's input arrow.
Click Configure.
Map one of the parent Agent's output attributes to each input attribute, which is fetched from the SQL table.
Apply the changes and save the Data Stream,
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.
Data Stream
C0mp|ex123
See the article for steps to import a Data Stream.