Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ian_Henry
Product and Topic Expert
Product and Topic Expert
9,499
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.

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

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 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].
33 Comments