Technical Articles
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 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.
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/242. Chrome Developer Tools
As is often the case we can get further information from here. We can see the GetServerInfo is red.
Figure 5: Chrome Developer Tools, GetServerInfo
Clicking on that we can get more information from the Network tab, under response.
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].
Run Simple. Wow superb SAC team. Useful Info Ian Henry .
Wonderful ...Thanks  Ian Henry .
Wow!! Piece of cake!! ? thanks Ian Henry
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?
I recognise that face
Yes, my understanding is that we have the HAA or equivalent, maybe the HAA+ embedded into the SAC tenant.
Awesome, thanks for confirming!
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)?Â
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.
Apologies, it is 2020.20.3.
Itching to get my hands on the functionality. 🙂
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.
I will keep hunting for possible reasons why HANA Cloud is not showing up then...
Hi Martin
Are you using a Data Warehouse Cloud tenant?
I believe the release schedule could be slightly different.
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. 🙂
Some of the NEO tenant limitations are explained in this blog post
Connect Multiple SAC Environment To One SAP Cloud Connector
Thanks, I honestly didn't even realize that we are running it on NEO until today.
Happened to us early 2019 when we tried to use predictive options for Forecasting. 🙂
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
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
Hi Ian,
unfortunately the link you've provided seems to be not valid anymore. Where do I find information about the Embedded HANA Analytics Adapter? I've found Live Data Connection to SAP HANA Cloud Using a Direct Connection and SSO in the current documentation for SAC but there the HAA is still installed separately in my Subaccount.
Looking forward for your reply.
Best Regards
Gregor
Hi Gregor,
Yes, you are correct. That link is annoyingly broken.
This link should give you details of the embedded (in SAC) HAA.
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/5bd569b3f75f49f29e9ec251fd6a1386.html
Cheers, Ian.
Hi Ian,
thank you for the quick response. On that page I find this:
"You have set up the SAP HANA Info Access Service (InA). See this help page for details."
But the linked page brings me to "SAP HANA Deployment Infrastructure (DI) Administration". When I search there for "Info Access Service" or InA I find no further details how I can setup the InA Service. Hope you can provide some guidance.
Best Regards
Gregor
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
I'm interested in the same topic but haven't found anything useful. Are you able to make this kind of connection?
Greetings,
Andrea
Good news. Thanks for the update
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
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.
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
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.
Hi Ian Henry
In case of incidents using this connection, what is the process to create a support user for SAP on both SAC & Hana cloud?
Because the generated SAC support userID will not be known on hana cloud...
Hi Ian Henry , is there any further information on this question? Or is this something I should ask the community?
Hi Ian Henry
And is it still needed to configure SDI connection (with DPA) to enable linked dimensions & query blending?
Hi Jef,
These type of questions are best posted in the answers section of the site.
https://answers.sap.com/questions/ask.html
Thanks, Ian.
Ok, thank you. Logged it now there now.
Hana cloud live query blending | SAP Community