Skip to Content
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.

To use this connection option requires SAP Analytics Cloud, Version 2020.20 or greater.
The official announcement is here https://www.sapanalytics.cloud/product_updates/release-2020-20/#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 then tells us to check 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

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].
15 Comments
You must be Logged on to comment or reply to a post.