Now that you have a JDBC connection in place in the server's configuration file, you can use this to join to a table. Suppose that we have an OEP application that is processing the key attributes of a customer's complaints. We may want to evaluate the important details of each complaint in real time to establish the priority of each complaint in order to provide better customer service. To do this, we will want to include a reference to the customer table in our application.
You would use the <wlevs:table>
tag to include a table within your EPN. For example:
<wlevs:table id="CUSTOMER" event-type="CustomerData" data-source="ReferenceDB"/>
Of course, you would need to define an event type with the appropriate attributes corresponding to the columns in the CUSTOMER
table.
You must then specify the table as a <wlevs:table-source>
for a processor that requires the data:
<wlevs:processor id="CustomerComplaintProcessor"> <wlevs:listener...