An example Data Stream that demonstrates how to use this Action Agent to write event data to a MySQL database table.
This example uses the MySQL world sample database. The Input Mapping should be completed after selecting the Database Table.
Drag the MySQL Action Agent onto the canvas, link up the Input Endpoint to the test data CSV Listener and the Output Endpoint to the Event Printer Action Agent, then Save the Data Stream.
Select the Agent and click Configure.
Enter the Server details and Credentials of MySQL server.
Select a Database and Table. Click Apply and Save the Data Stream.
Select the arrow pointing toward the Input Endpoint of MySQL Action Agent and click Configure.
Map the parent Agent outputs to the City table columns. Use the Auto Map function if the parent output's name is the same as the Object's column name. Click Apply then Save.
Click Live View to view the output of the Agent. The Agent will create an output if the new City record has been successfully created.
MySQL Action Agent Example.xuc
MySQL Sample Data.csv