Skip to Content
avatar image
Former Member

How to integrate Smart data streaming in SAP HANA using Node.js?

Is there any way i can integrate smart data streaming in SAP HANA in a Node.js project? If yes, what are the steps to be followed?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 30, 2017 at 06:56 PM

    There are several ways in which a web application, whether using node.js or any other framework, can interact with an SDS project. Both REST and Websockets can be used to publish data into an SDS project. Websockets can be used to subscribe to pushed output from an SDS project. We also provide OData output adapters if you are looking to have the SDS output call an OData service.

    Can you provide more detail on what you looking to implement?

    Add comment
    10|10000 characters needed characters exceeded

    • How are the event records being inserted into HANA? Could they be published directly to SDS, either to SDS first for processing before being stored in HANA, or to SDS in parallel to being inserted into HANA?

      How would you be using the event records in the streaming project?

      • SDS provides a HANA Reference element that does event driven look ups against a HANA table. If you wanted to combine the data from the HANA table with other event records being processed by SDS, then joining to a Reference element would let you include the latest value(s) from the HANA table in your stream processing
      • The DB Input adapter can be configured to poll a database for input. This is not event driven but rather schedule driven and would let you pull the changed data into the streaming project at the configured interval

      What we don't have at the moment is the ability for HANA to push new or changed records to SDS, for example through a trigger on the table.

      As a starting point for using REST to publish data to SDS, take a look at this tutorial:

      Publish events to SDS via the REST interface

      If you also need instructions on configuring the Streaming Web Service, then you can refer to this tutorial:

      Using the Streaming Web Service (SP11)