As of SAP Sybase Event Stream Processor 5.1 SP04 and SAP HANA SPS 07, you can use the SAP HANA Smart Data Access feature to access the contents of an ESP window using SQL queries.
A new Linux ODBC driver is provided to users of the SAP HANA Smart Data Access feature. This driver lets you access the contents of ESP windows through the ODBC interface. You can perform a SELECT statement on the contents of the ESP window to capture its contents.
To establish a connection, within SAP HANA, create a remote source over the ESP instance, and subsequently a virtual table over the relevant window in the ESP instance, using the smart data access syntax. For example:
CREATE REMOTE SOURCE sourcename ADAPTER "odbc" CONFIGURATION FILE 'property_esp.ini' CONFIGURATION connectionstring WITH CREDENTIAL TYPE 'PASSWORD' USING 'credentialstring' CREATE VIRTUAL TABLE virtualtablename AT sourcename."workspacename"."projectname"."windowname"
In CREATE VIRTUAL TABLE, workspacename, projectname, and windowname are the names of the Workspace, Project, and the relevant Window within the ESP instance to which SAP HANA is connecting.
Once you have created the source, you can use it as any other data source. Once you have created the virtual table, you can use it like any other virtual table in SAP HANA.
Complete documentation for the Smart Data Access feature, including information on connecting to Event Stream Processor, is provided in the SAP HANA documentation.