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
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.
Second Click we specify the Connection Type, “SAP HANA Cloud”
Complete the required fields, hostname would be the HANA Cloud endpoint without the port.
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.
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.
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.
126.96.36.199/24 188.8.131.52/24 184.108.40.206/24
Chrome Developer Tools
As is often the case we can get further information from here. We can see the GetServerInfo is red.
Clicking on that we can get more information from the Network tab, under response.
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].