Comment on page


This example Data Stream demonstrates how to use this Action Agent to write city data to an Oracle database table.
Refer to configuration to understand all configuration options of this Agent.

Step 1: Add the Agent

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.

Step 2: Configure General

Select the Agent and click Configure. Keep the default Collection.

Step 3: Configure Server

Enter the authentication details: host, port, service name, user name, and password.

Step 4: Configure Query

Select the Oracle table where the data should be inserted. In this case, set the table to CITY.

Step 5: Results

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.


Security Key
Data Stream
Oracle Action Agent Example.xuc
Sample Data
Oracle Sample Data.csv
See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.