IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Configure the module for deployment

Create the event store

You need to create the event store in the Oracle database before the adapter can process inbound events. You can set triggers on user tables as needed to populate the event store. For Oracle E-Business Suite, you need to configure the Oracle Business Event System and Concurrent Program to capture the event.

Perform this task only if you need inbound processing of events. Create the event store in the database that contains the tables for which events are reported.


Procedure

  1. Create the event store. Sample scripts are provided to create the event store for the Oracle database, as follows:

    • ibm_websphere_event_table_create.sql

    These files are in the IID_installation_dir/ResourceAdapters/OracleEBS_ version/scripts directory, where IID_installation_dir is the installation directory for IBM Integration Designer, and version identifies the version of the adapter, for example, 7.5.

  2. For Oracle database, set up triggers on user tables so that the changes to the user tables can automatically generate events that is stored in the event store. If using triggers is not an option, then you can populate the event store by using custom SQL code or stored procedures that are not started through triggers. Instead, the triggers can be started through a batch program that runs periodically or that you run manually. For Oracle E-Business Suite, it is recommended that you configure the Oracle Business Event System and Concurrent Programs to define the events and automatically capture the events. The Concurrent Programs can be scheduled to run periodically or run manually when required.


Results

The event store is available for event processing.

Configure the module for deployment


Previous topic: Roadmap for configuring the module


Next topic: Create an authentication alias


Related concepts:

Event store