This example Data Stream demonstrates how to use the Action Agent to write event data to a table in an Azure SQL database.
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.
Select the Agent and click Configure. In this case, keep the default Collection.
Enter the Authentication details of the Azure SQL database to which you want to connect: server instance, user name, and password.
Select the database.
Select the table and command. In this case, keep the default insert command.
elect which columns should be returned.
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.
Apply the changes and save the Data Stream.
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.
Azure SQL Action Agent Example.xuc