SAP Sybase Aleri CEP Engine

The SAP Sybase Aleri connector allows connection to the Aleri CEP engine on a real-time streaming basis. Specifically the connector allows Panopticon Designer (Desktop) to subscribe to:

• Aleri Streams

• Aleri SQL Projections, allowing parameterized streams to be subscribed against

Using SAP Sybase Aleri CEP Engine

1. When creating a new data table, select Sybase Aleri from the Connect to data dialog. The Sybase Aleri Connection dialog displays.

   

2. Enter the following:

1. • Host

   • Port

   • Username

   • Password

3. Click the Connect button.

4. Select Stream or SQL.

5. Depending on the one you selected, you can do either of the following:

1. • for Stream, select from the defined list, or

   • for SQL, enter the valid SQL describing a stream, and its filter criteria

6. Re-click the Connect button.

7. Select the ID Column.

This defines the column that uniquely identifies a row in the returned stream, and is used for processing inserts, updates and deletes.

8. Modify the Real-time limit, to vary the data throttling. 

This defaults to 1000 milliseconds.

9. Click OK.

By default only the latest data will be loaded into memory. A streaming time series window can be generated by creating a compound key with the Id Column, plus a separately specified Time ID column.

This Time ID column can be from the source dataset, or alternatively automatically generated.

If the Time Id column is selected, then a scrolling time window can be specified. As new data arrives from the subscription new time slices will automatically be added, and old ones will be deleted.

The Ignore NULL values checkbox, determines if null values when received should replace existing non-null values, or should be ignored, keeping the prior non-null value.

10. Click OK. The source table is returned in Data Prep, with the Aleri Stream title and all fields listed displayed in the Data Source Preview.

11. Click in the data source box.

The Data Source Specific Settings dialog displays with the following information:

• Host & Port

• Hot Spare Host & Port

• Username & Password

• Authentication Method

• Data Encryption Flag

• Stream or SQL Projection

• Ignore NULL values checkbox

• ID Column

• Time ID Column

• Real-time Throttling Limit (ms)

12. Click in the Data Preview area. The Datasource - Transforms dialog displays with the following information:

• Pivot

• Unpivot

• R Transform

• Python Transform

• Time Series Transform

13. Click on a field dropdown in the Data Preview area to:

• Modify the data types.

• Select which fields to include or duplicate.

• Change the display Titles.

• Clean data, modify case setting, Split values, define Substrings, Replace values, or Convert time settings

• Define the display formats for numeric fields. The default setting is: #,##0.00

• Define new auto-generated Key column, calculated column, or grouping column