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 > JDBC > Configure the module for deployment
Create the event store
You need to create the event store in the database before the adapter can process inbound events. You can set triggers on user tables as needed to populate the event table.
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
- Create the event store. Sample scripts are provided to create the event store for the IBM DB2 , IBM DB2 for z/OS , Oracle, or Microsoft SQL Server database, as follows:
- scripts_db2.sql
- scripts_db2_zOS.sql
- scripts_oracle.sql
- scripts_mssql.sql
Before you run the scripts_db2_zOS.sql script, ensure that the storage group JDDBSTO exists.
These files are in the IID_installation_dir/ResourceAdapters/JDBC_ version/Scripts directory, where IID_installation_dir is the installation directory for IBM Integration Designer, and version identifies the version of the adapter.
- If necessary, set up triggers on user tables so that changes to the user tables can automatically generate events that are stored in the event store. The sample scripts contain examples of how to create triggers to populate your event store.
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: