Page Comparison

Introduction

This sample demonstrates how to use external time windows for a fraud detection use-case. In this sample, we look for two or more transactions done within a very short period of time and send an alert immediately when such an occurrence is detected.

The query used in this sample is as follows:

...

The second query looks for the condition where more than one transaction has taken place for a specific card and sends an alert. 

Prerequisites

See Prerequisites in CEP Samples Setup page.

Before starting the server, you need to add the MySQL JDBC driver  Download it and place the jar inside <CEP_HOME>/repository/components/lib. You also need to have MySQL installed and running before executing this sample. Create a new database in MySQL which is to be used when creating the cepSampleDataSource below.

Start the server normally and create a new data source named 'cepSampleDataSource' using the Configure --> Data Sources page in the management console. for more information on adding a datasource see Adding Datasources. Once this is done, shutdown the server. (Here cepSampleDataSource ponits to  the newly created or already existing database)

Building the sample

Start the WSO2 CEP server with the sample configuration numbered 01090114. For instructions, see Starting sample CEP configurations. This sample configuration does the following:

• Creates <CEP_HOME>/repository/conf/data-bridge/stream-definitions.xml file, which is used to create the stream definitions for the sample.
• Points the default Axis2 repo to <CEP_HOME>/sample/artifacts/01090114 (by default, the Axis2 repo is <CEP_HOME>/repository/deployment/server).

Executing the sample

1. Open a terminal, go to <CEP_HOME>/samples/consumersproducers/wso2-event and run ant from there.
   It builds the sample wso2event consumer and executes it.

   Info
   Do not close this terminal. It is required to keep the server running and receiving events.

   Open another terminal, go to <CEP_HOME>/samples/producers/pizza-shop and run the following command:

   Code Block
   ant pizzaPublisherClient-DstreamId=org.wso2.sample.atm.transactions:1.0.0 -Dsn=0114

   It builds and runs the wso2event producer, which sends sample pizza orders and delivery data ATM transaction events to the CEP server.

2. From the terminal opened in step 2, see the details of the events sent. Note that it takes around 30 seconds to complete sending the events as we do time-based analysis in this sample. 

   Info
   To configure host, port, username, password and No. of events use -Dhost=xxxx -Dport=xxxx -Dusername=xxxx -Dpassword=xxxx -Devents=xx. For example : ant -Devents=10

   For example

3. After sending events, you can see the outputs from the CEP console (the outputs are logged by the logger which we use for this sample), given below is part of the console output of the consumer logger when sending events from the producer.
   

   Image Removed

...

1. Image Added