This example Data Stream demonstrates how to use this Action Agent to write city data to an Oracle database table.
Drag the Oracle Action Agent onto the canvas, link the input endpoint to the city data, the output to the printer. Renamed the Agent and save the Data Stream.
Select the Agent and click Configure. Keep the default Collection.
Enter the authentication details: host, port, service name, user name, and password.
Select the Oracle table where the data should be inserted. In this case, set the table to CITY.
Apply the changes, save the Data Stream and publish it.
Let's look at the Live Data View. This shows that the CSV Simulator sends the city data to the Oracle Agent. It posts the data to the Oracle database and does not print the events.
Observe that when the Oracle SQL query is refreshed, the new row has been added to the City table.
Oracle Action Agent Example.xuc
Oracle Sample Data.csv