SAC Cloud and SAP HANA DB Connectivity

[SAPSupport]

Hello Team,
we are exploring SAC Cloud Connection to SAP HANA DB for adding Dataset which help to create story and next step would be Dashboards preparation.

We are using SAC Cloud account and SAP HANA DB (Cloud foundry environment). We managed to create data connection with SAP HANA DB but not able to use that connection for creating dataset in SAC Cloud.

Please provide solution & guidance on
1. recommended approach and best practices for connecting SAC Cloud to SAP HANA DB & dashboard preparation.
2. how to embed these dashboards in web application

thanks & regards,
Sandeep

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[sandeep_sarvankar]

Just quick reminder.

[SAPSupport · Accepted solution]

Hi

1. To connect SAC to Hana, you can choose import connection or live connection type.
   You can refer to below help document on how to setup import connection or live connection
   https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/61f2f4c1bc6f447985191...
   https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/cc03773d7f554c4ebc9e2...
2. Please refer to below SAP Analytics Cloud URL API help guide, The SAP Analytics Cloud URL API allows you to directly open stories via a URL. This may be used when embedding stories in external applications.
   https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/a4406994704e4af5a8559a640b496468/f0827b68d24548448060c...

SAP's help guide has detail information on how to hands on/use SAC product, suggest you refer to it or search with keyword for the information you want.

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/1fb1f4ce92f44fc983debc25a...

Best regards
Emily

[test1023 · Accepted solution]

Hi Experts,

can someone help me to connect SAP hana cloud DB within SAP CPI. I have created cloud hana db instance within BTP and created datasource for the same. but when I am trying to use the same datasource , I am getting below errors.

Failed to obtain JDBC Connection; nested exception is java.lang.IllegalStateException: DataSource returned null from getConnection():