Skip to Content
Technical Articles
Author's profile photo Ian Henry

Connect SAP Analytics Cloud to HANA Cloud in Three Clicks

Yes, that’s right the once painful setup has now been simplified into just 3 clicks.

Pre-reqs

  • SAP Analytics Cloud, Version 2020.20 or greater
  • Cloud Foundry SAC tenant (us10, eu10, jp10) and not Neo (us1, eu1, jp1)

The official announcement is here
https://saphanajourney.com/sap-analytics-cloud/product-updates/sac-q4-2020/#liveconnect

We can check our SAC Tenant Version, System -> About

Figure%201%3A%20SAC%20Tenant%20Version

Figure 1: SAC Tenant Version, 2020.20.1

Step 1: Create Connection – this is the only step 🙂

In SAP Analytics Cloud, Connections, first click add a New Connection, choose Connect to Live Data,  SAP HANA.

Figure 2: Connect to Live Data

Second Click we specify the Connection Type, “SAP HANA Cloud”

Figure 3: New HANA Cloud Live Connection

Complete the required fields, hostname would be the HANA Cloud endpoint without the port.

Figure 4: Connection Details

Third and final click – Click OK

It really is that simple, great job from the SAP Analytic Cloud team to deliver the simplified HANA Cloud Connection. No more HANA Analytics Adapter, no more troubleshooting incorrect yaml configurations.

Troubleshooting

Just incase your connection does not work there are a couple of things to check.

1. Advanced HANA Cloud Setting for Allowed Connections.

If you are “only allowing specific IP addresses” then you should add the egress IPs for your SAC tenants region as shown on this SAP Note 2459838. Which refers us to this link for Cloud Foundry tenants.

https://help.sap.com/viewer/3504ec5ef16548778610c7e89cc0eac3/Cloud/en-US/350356d1dc314d3199dca15bd2ab9b0e.html

Refer to the column “NAT IPs (egress, IPs for requests from a Cloud Foundry app)”.
I added the following to my Allowed IP addresses in HANA Cloud.

52.59.128.222/24
52.28.241.88/24
18.184.81.94/24

2. Chrome Developer Tools

As is often the case we can get further information from here. We can see the GetServerInfo is red.

Figure%205%3A%20Chrome%20Developer%20Tools%2C%20GetServerInfo

Figure 5: Chrome Developer Tools, GetServerInfo

Clicking on that we can get more information from the Network tab, under response.

Figure%206%3A%20Get%20ServerInfo%20Response%20details

Figure 6: Get ServerInfo Response details

Expanding that long text show me the following details. I can then confirm if my hostname is the correct one.

Failed to retrieve remote response with external exception: com.google.common.util.concurrent.UncheckedExecutionException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: SAP DBTech JDBC: Cannot connect to jdbc:sap://This-is-not-the-HC-You-Are-Looking-For.com:443 [Unknown host This-is-not-the-HC-You-Are-Looking-For.com [This-is-not-the-HC-You-Are-Looking-For.com: Name or service not known], -709].

Assigned tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Venkateswara Y Guptha
      Venkateswara Y Guptha

      Run Simple. Wow superb SAC team. Useful Info Ian Henry .

      Author's profile photo Aby Jacob
      Aby Jacob

      Wonderful  ...Thanks  Ian Henry .

      Author's profile photo Enio Terra
      Enio Terra

      Wow!! Piece of cake!! ? thanks Ian Henry

      Author's profile photo Henrique Pinto
      Henrique Pinto

      This is awesome, Ian! And funny in so many ways. 🙂

      Is this a JDBC connection, or is it going to leverage the OLAP capabilities of HANA (e.g. you still see all cube-enabled Calc Views as analytical models, dimensions/measures etc)? e.g. is it embedding HAA directly on SAC?

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      I recognise that face ?

      Yes, my understanding is that we have the HAA or equivalent, maybe the HAA+ embedded into the SAC tenant.

      Author's profile photo Henrique Pinto
      Henrique Pinto

      Awesome, thanks for confirming!

      Author's profile photo Martin Stenzig
      Martin Stenzig

      This looks great and we waited for this for a while.

      We are on version 2020.03 but the HANA Cloud entry is not showing up in the SAC drop down? Do we have to have the Hana Cloud entitlement in the same sub account?

      Second question: Does it only work for live data or also Data acquisition (i.e. import and export)? 

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      Hi Martin,

      Is your version 2020.20.03 or just 2020.03?

      it needs to be release 20 which is 2020.20.

      There’s no relationship to SCP accounts as you are providing the hostname.

      I haven’t tried for data acquisition yet.

      Cheers, Ian.

      Author's profile photo Martin Stenzig
      Martin Stenzig

      Apologies, it is 2020.20.3.

      Itching to get my hands on the functionality. 🙂

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      I checked a tenant on 2020.20.3 and I do see the same HANA Cloud entry after first selecting Connect Live to Data. As per Figure 1&2 above.

      Author's profile photo Martin Stenzig
      Martin Stenzig

      I will keep hunting for possible reasons why HANA Cloud is not showing up then...

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      Hi Martin

      Are you using a Data Warehouse Cloud tenant?

      I believe the release schedule could be slightly different.

      Author's profile photo Martin Stenzig
      Martin Stenzig

      Ian, I finally had a chance to dig back into this and when I read the fine print in the documentation I realized what's going on. We are running our Analytics Cloud tenant on a NEO stack and there, the HANA Cloud options does not show up in the drop down... something else to move to CF in the new year. 🙂

      Author's profile photo Debjit Singha
      Debjit Singha

      Some of the NEO tenant limitations are explained in this blog post
      Connect Multiple SAC Environment To One SAP Cloud Connector

      Author's profile photo Martin Stenzig
      Martin Stenzig

      Thanks, I honestly didn't even realize that we are running it on NEO until today.

      Author's profile photo Debjit Singha
      Debjit Singha

      Happened to us early 2019 when we tried to use predictive options for Forecasting. 🙂

      Author's profile photo Haaris Ahmed
      Haaris Ahmed

      Hi Ian,

       

      Is it a good idea to have a direct JDBC/SQL connection to HANA Cloud compared to the INA Adapter?

      Also we have SSO via SAML configured for SAC and SAP CP (INA). What are SSO possibilities when doing a direct connection?

       

      Regards,

      Haaris

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      Hi Haaris,

      This new connection is also InA. There is a JDBC connection from the embedded HAA to HC, but then SAC will connect to the embedded HAA with InA.

      Yes, SAML SSO is also supported with this new live HANA Cloud connection.

      Details of this configuration can be found here

      https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2020.20/en-US/5bd569b3f75f49f29e9ec251fd6a1386.html

      Author's profile photo Andrea Bisconti
      Andrea Bisconti

      Hi Ian,

      thank you for the article, is very useful!

       

      I read the comment where you say you haven't tried the Data Acquisition (Import), but do you know a way to create an Acquire Data connection to Hana Cloud, without using OData?

      Regards,

      Andrea

      Author's profile photo Andrea Montagna
      Andrea Montagna

      I'm interested in the same topic but haven't found anything useful. Are you able to make this kind of connection?

      Greetings,
      Andrea

      Author's profile photo Murali Shanmugham
      Murali Shanmugham

      Good news. Thanks for the update

      Author's profile photo Ivan Yin
      Ivan Yin

      Thanks Ian!

       

      Just one thing. These nouns are confusing me now... Is this "HANA Cloud" the same as "HANA 2.0 on SCP CF"?

       

      Regards,

      Ivan

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      Hi Ivan,

      I was actually referring to HANA Cloud which is the successor to HANA as a Service (HaaS), aka HANA 2.0 in SCP.  The connectivity is JDBC to the embedded HAA, I would expect it could work with any version of HANA. I haven't tested that though.

      Regards, Ian.

      Author's profile photo Marcus Kats
      Marcus Kats

      Thank you for the guide!

       

      I have one question. If you have several HDI containers say for instance if we share the HANA Service between development and test. Can we configure which HDI-container a specific connection from SAC will be using?

      Best regards

      Marcus

      Author's profile photo Ian Henry
      Ian Henry
      Blog Post Author

      Hi Marcus,

      No, not really. When you are using the HANA Cloud connection you only define the hostname and authentication, either technical user or SAML SSO for that connection.  The HDI container and Calc View/Column View is contained within the SAC model metadata.

      You can change the datasource in this model to refer to different HDI containers.