Building a Simple Project

Walk through this hands-on tutorial to create a simple project in the Visual editor.

The sample project demonstrates how you can easily define event streams and windows by attaching a previously configured adapter and discovering its schema, or by manually defining a window and its schema. It shows you how to define continuous queries—aggregations, joins, and more—using the visual tools.

Begin by reviewing background information that helps you understand the project. Then complete the tasks to build the project.

  1. Reviewing Concepts
    Begin the tutorial by reading a description of the sample project, and concepts applied in it.
  2. Creating the Sample Project
    Use the SAP Sybase Event Stream Processor Studio to define a new set of processing instructions for event data.
  3. Editing a Project Diagram
    Edit projects in the Visual editor by adding shapes from the Palette to the project diagram, connecting them, and completing the configuration of each shape.
  4. Adding an Input Adapter
    Attach an adapter by inserting it in the diagram, connecting it to a stream or window, and setting properties.
  5. Discovering a Schema
    Use the Schema Discovery button in the Adapter shape to discover and automatically create a schema based on the format of the data from the adapter.
  6. Adding an Input Window Manually
    Add an input window to the diagram in the sample my_portfolio_valuation project.
  7. Creating an Aggregate as a Simple Query
    Add to the sample diagram an Aggregate simple query to create a volume weighted average price (VWAP).
  8. Creating a Join as a Simple Query
    Add a join to the sample project. A join combines events from two or more inputs to create a single stream or window. It is similar to a join in SQL.
  9. Completing the Sample Project
    Add a new aggregate, and clean up the diagram by removing unused elements.