Don't have: Add HANA Service in SAP HANA Streaming Data Service

[Former Member]

Hi,

I wanted to start using the real-time machine learning with SAP HANA SDS (SDS version: 1.0.12.v201604281303, SAP HANA STUDIO version: 2.3.5). I was also using SAP ESP (5.1.110.00/20151206.1/SP11), but because of machine learning, I transefered into SAP SDS.

Because there is no local cluster(), I had to start my own one. I used the one that is installed with SAP ESP, so I started a new cluster.

I added this server into SAP HANA SDS and succesfully connected it.

Problem is, that I don't have option: Add HANA Service to be able to do real-time machine learning.

Could you please help me to start a cluster that will be able to do that?

Thank you,

Jan

[RobertWaywell · Accepted solution]

Hi Jan,

There seems to be some confusion between the development tools and the servers for both SAP HANA Smart Data Streaming ("SDS") and SAP Event Stream Processor ("ESP"). SDS and ESP are both server products with supporting development and testing tools. For SDS the standard development environment is HANA Studio and the SDS plugin for HANA Studio provides the SAP HANA Streaming Development and SAP HANA Streaming Run-Test perspectives. For ESP the standard development environment is ESP Studio which provides the equivalent perspectives for ESP.

In the screenshots that you have provided you show that you are connecting to an ESP server from HANA Studio. This is supported by the development tooling in order to simplify the developer experience when working with both SDS and ESP servers. As part of that support, the development tools are able to recognize what streaming server they are connecting to and only expose functionality that is supported by the backend server. Since you are connecting to an ESP server instead of an SDS server, the machine learning algorithms and functionality is not available. Similarly, the HANA Service option is not available to you under the Data Services tab in the SAP HANA Streaming Development perspective because that service type is specific to SDS which runs as part of a HANA system.

In order to use the machine learning capabilities in HANA Smart Data Streaming you will need to install and configure a HANA system including the SDS component. From HANA Studio you would then connect to the SDS server as opposed to the ESP server that you are currently connecting to.

Thanks

Rob

[Former Member]

Hi,

thank you for your replies. I thought that I hadn't understood it completely, so thank you for your explanation.

Since which version you can use machine learning with streaming data? Is it SPS11? SAP HANA Academy - Smart Data Streaming: What's New in SPS11 Overview - YouTube

How can I find on Software Downloads | SAP Support Portal which version is SPS11? I installed SAP HANA Studion and SAP HANA Smart Data Streaming plugin in version: Revision 120 (SP12). Is that SPS12? It is little bit confusing for me.

We have SAP HANA version installed: 102, which is probably SPS10, so we have to upgrade our HANA system?

Thanks,

Jan

[remi_astier]

Yes, upgrade to SP 11 or 12 and install SDS.

SDS can only run on the same host as HANA in dev. For production, you will need to dedicate a host, not necessarily certified hardware, but a host or a VM.

[RobertWaywell]

Hi Jan,

A couple more answers for you:

1) Yes the machine learning algorithms were introduced for SDS in SP11.

2) When reading the Revision #s the first 2 digits represent the SP with the 3rd digit being the revision within the SP. So your current install version of 102 is indeed SP10 and it is revision 2 within SP10. Similarly version 120 is the first release of SP12 so it is revision 0 within SP12.

[remi_astier]

I'm afraid you can't use machine learning in ESP using a HANA instance, it has to be SDS.

You can still connect by adding an ODBC service and ticking the box "is Hana database"

remi

[Former Member]

I don't use ESP. I'm using SDS, but I had to use remote cluster from installation of ESP. Just to be sure I add two videos:

There you can see that they are doing that. I have to add models which I can't with ODBC as same as in video.

Thank you,

Jan

[JWootton]

Jan - I'm not sure if meant to say "SDS" in this statement, or if there is some confusion here...

You said:  "I don't use ESP. I'm using SDS, but I had to use remote cluster from installation of ESP."

We need to be clear:  SDS is different from ESP.  SDS runs as a server on a HANA system and must be installed on a HANA system.  The streaming plugin for HANA studio is the set of design time tools that work with an SDS server on a HANA system.

If you really set up a remote cluster from the ESP download, that is an ESP server, not an SDS server.  It will not have the SDS machine learning capabilities.

See this tutorial on installing SDS on your HANA System:  SAP HANA Academy - Smart Data Streaming: Installation [SPS 09] - YouTube  - this was done for SP09, but I don't think it's changed much, if at all.

Now if you are using the latest version of HANA Studio, with the SDS plugin installed,  and you are connecting to an SDS server installed on a HANA system (either SPS11 or SPS12), then you will be able to use the CCL machine learning functions.

If you are connecting to an ESP remote cluster, you will not be able to use machine learning.  Those features aren't available on ESP, even if you are connecting your ESP project to a HANA database.