You can reference RDB data from complex event processing provided by BDCEP.
Setting up the system to use a cache enables data to be referenced at a higher speed than when accessing a relational database each time. Essentially, the key and result of a query that has been referenced once are saved in the cache, and when the relational database is subsequently referenced using the same key, the data is obtained from the stored cache.
The following example references the data in a relational database, joins the referenced data to input events, and passes it to the output adapter.
Figure 2.7 Example of RDB collaboration
Refer to "4.4.4 Setup of RDB Collaboration" for information on how to set up RDB collaboration.
Refer to "5.4.4.4.2 Specifying RDB referencing in complex event processing rules" for information on how to reference the data in a relational database.
Note
If there is a large volume of data stored in the cache, memory usage also increases. Set a cache retention period according to memory usage. Refer to "3.3.1 Estimating Memory Usage" for information on how to estimate the amount of memory to be used by RDB referencing.
RDB collaboration uses JDBC drivers provided by various RDB products. BDCEP operations are confirmed for the following JDBC drivers:
JDBC driver of Symfoware Server V10.1.0A
JDBC driver of Symfoware Server (Open Interface) V12.0
PostgreSQL JDBC Driver Version 9.3-1100 (JDBC 4)
