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