Example

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.

Files

File	Link	Security Key
Data Stream	Oracle Action Agent Example.xuc	C0mp|ex123
Sample Data	Oracle Sample Data.csv

See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.