I had earlier posted a blog which shows how to use Remote Data Sync service on HCP to have bi-directional synchronization of data between many remote databases at the edge and SAP HANA cloud database at the center. This is perfect for occasionally connected devices. In this blog series, I wanted to take a different approach and use some of the services in HCP to capture event streams in real-time, process the data and apply predictive analytics to predict future outcomes.
There are three services I will use to achieve this – Smart Data Streaming, IoT Services & Predictive Services.
In the initial part of the blog series, I will focus on Smart Data Streaming and IoT concepts and will later cover Predictive services.
The objective of this blog series is to show how one could use Smart Data Streaming (SDS) to capture and filter sensor messages from an IoT device and later apply predictive analytics to gain some insights.
Smart Data Streaming (SDS) service processes high-velocity, high-volume event streams in real-time. It allows you to capture data arriving continuously from devices and applications, watch for trends & pattern and can generate notification and alerts accordingly.
Here are some popular use cases
Once your HANA DB and SDS is provisioned, you will need to setup users. Navigate to the SAP HANA Cockpit and create two users.
SDSADMIN - Use this database user to perform policy administration functions, such as granting and revoking privileges.
HANAUSER1 - Use this database user to connect to any web service or use streaming in HANA Studio
You will need to download and install some components on your laptop to connect to the SDS service on HCP. You will need to install the below two items.
More information on how to install the client package and HANA Studio plugin can be found in SAP Help.
In your environment variables, set Streaming home to the directory where Streaming client package is installed
set STREAMING_HOME=<streaming-client-directory>
Assign the below roles to the SDSUSER.
You need to grant permissions to HANAUSER1 user before it can connect to any web services or use streaming in SAP HANA studio.
Start streamingclusteradmin in interactive mode for your SAP HANA instance and issue the below commands
$STREAMING_HOME/bin/streamingclusteradmin --uri=https://<https://<hana-instance-name>wsp<HCP-account-name>.<landscape-name>.hana.ondemand.com:443 --username=SDSADMIN --password=<password>
grant perm all on all to user HANAUSER1
You can now login to SAP HANA Cockpit as SDSADMIN user and verify the permissions. Once you are in the HANA Cockpit, click on the Streaming permissions tile
Notice that I have permission "all" against privileges/resource types for the HANAUSER1.
In the next part, I will create a Streaming Project using HANA Studio.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |