ESP Add-In for Microsoft Excel

The SAP ESP Add-in for Microsoft Excel is a real-time data add-in for Microsoft Excel that lets you view and retrieve records from one or more running Event Stream Processor projects, as well as publish records to them.

The ESP Add-in for Microsoft Excel does not support Linux or Solaris platforms. You can run it on 32-bit and 64-bit editions of Windows, and with the 32-bit editions of Microsoft Excel 2007 and 2010.

On the display side, you can use the ESP Add-in for Microsoft Excel to select streams and view the columns within those streams. You can also filter records based on data values, and view the most recent “N” records, or the most recent “N” records that match a specified filter (where “N” is the specified number of records).

On the publication side, you can use the ESP Add-in for Microsoft Excel to automatically publish data whenever data changes in a range of cells. You can also manually publish data to Event Stream Processor by selecting a range of cells and using the Publication wizard.

• Prerequisites
  Necessary software and configuration for using the Add-In.
• Enabling Automatic Publishing with the Sybase Event Stream Processor Add-in for Microsoft Excel
  If you have installed the SAP Sybase Event Stream Processor Add-in for Microsoft Excel and want to use the Automatic Publishing feature (SybaseRTP), configure Microsoft Excel to load SybaseRTP.Rtp as an automation add-in.
• Connection Wizard
  The Connection wizard lets you simultaneously connect to one or more instances of Event Stream Processor.
• Subscription Wizard
  The Subscription wizard pane enables you to define and control one or more subscription queries, the results of which appear in the Excel worksheet.
• Publication Wizard
  The Publication wizard lets you manually publish data to a stream and graphically construct publication formulas meant for automatic publishing.
• Automatic Publishing
  Use the SybaseRTP add-in function when the data in a cell changes
• Subscription Queries
  You can save subscription queries permanently by saving the Excel worksheet containing the formula associated with the query. The next time the Excel Worksheet is opened, the query appears in the Subscription wizard.
• Applying a Query
  Apply and start a query from the Subscription Wizard pane to populate the Excel worksheet.
• Known Issues and Limitations
  The ESP Add-in for Microsoft Excel has some known issues and limitations.