Open a command window and change directory to <edgeserver_home>\edge\sql, where edgeserver_home is the folder in which the Sensor Edge Server is installed. Log in to SQL*Plus as system user by issuing the following command:

sqlplus system/<password for system>

Execute the script create_edg_user.sql. This script creates the user edge and assigns privileges to that user.
You are prompted to enter a password for the user edge. In this example, the password is edgepwd.

Connect as the new user and run the scripts edg_create_streams.sql and edg_create_sdh.sql.

edg_create_streams.sql: This script creates the internal queues, ruleset, and streams-related schema. Streams Dispatcher uses the queues to propagate messages to the relevant application.

edg_create_sdh.sql: This script creates the Sensor Data Hub schema. The Sensor Data Hub is a single repository that provides a global view of all sensor information.

Exit SQL*Plus.

Open the edgeserver.xml file that is in the <edgeserver_home>\edge\config folder. Observe the various tags, of which the following are the most important:

<EdgeServer>: Is the root element. It contains tags to set various tuneable parameters

<DispatcherList>: Specifies all the dispatchers that are uploaded to the system. It contains an array
of <Dispatcher>, which defines all uploaded dispatchers. There can only be only one <DispatcherList> in the <EdgeServer> node.

<CurrentDispatcher>: Defines which dispatcher to use and its parameters

<DeviceGroups>: Contains the actual device and filter instances to load at run time

Most of the tags in the edgeserver.xml configuration file require you to define a unique identifier so that they can be referenced by other tags. The identifier is defined in the attribute ID and must be unique across the file (although they do not have to be consecutive).

Look for the <Dispatcher> tag for Streams Dispatcher and examine the attributes and parameters tag. Observe that there are three parameters for Streams Dispatcher: url, username, and password. Make a note of the value in the ID attribute of the <Dispatcher> tag.

Examine the <CurrentDispatcher> tag.

Note that the dispatcher is set to NullDispatcher with reference 3.

Set the dispatcher to Streams Dispatcher and change the value of the reference attribute to the value you noted in
step 1. For each parameter defined in the Streams Dispatcher extension, you should have a <ParameterInst> entry in your current dispatcher. You have already observed that there are three parameters in the Streams Dispatcher extension: url, username, and password. Provide values for all three parameters, as shown in the following screenshot:
Note: Download and save the sample.xml file on your hard disk. You can copy and paste the <CurrentDispatcher> tag from this file.

Change the database SID in the value for the parameter called url. In this example, the SID used is ping.

Save the edgeserver.xml file.

If you add a device to the Sensor Edge Server, it picks up the events from the device. Add an internal simulator to the Sensor Edge Server. In the edgeserver.xml file, search for the edge simulator driver and observe that the ID is 43. Also note that the simulator has one parameter with the ID 45 and name FileName.

Search for device groups in the XML file. Observe that there are currently no devices in the <DeviceList>. The tag is therefore closed.

Modify the file to add the device, as shown in the following screenshot. Then save the file.
Note: You can copy and paste the <DeviceList> tag from the sample.xml file that you downloaded in step 3.

Start the OC4J server. Switch to the command prompt, change the directory to <edgeserver_home>\j2ee\home, and issue the following command:

java -jar oc4j.jar

Each time you start your server, it begins dropping events. An edge*.log file must be created in the following location: <edgeserver_home>\edge\log. Open the file and verify the events that are being dispatched.

Open another command prompt and log in to SQL*Plus as edge user. Execute the following query:

SELECT count(*) FROM SDH_EVENTS;