SAP Knowledge Base Article - Public

2497096 - Live Data connection to a multitenant HANA database using SAP Analytics Cloud

Symptom

You are connecting successfully to HANA using live connections. However, when trying to connect to a tenant in a multitenant Database container, you receive the error:Error connecting to the system;

Environment

  • SAP Analytics Cloud 2017
  • SAP multimenant HANA

Reproducing the Issue

You configured reverse proxy using Web Dispatcher or Apache to connect to SAP HANA.

Creating a Live connection to HANA throws the error: Error connecting to the system;

Cause

SAP Analytics Cloud live connections with HANA requires SAP HANA Info Access Service (InA). This is a HTTP service, if your tenants don't have a specific URL, SAP Analytics Cloud will not be able to connect to it.

Resolution

To enable Web-based applications to send HTTP(S) requests to multitenant database containers via the SAP HANA XS classic server, the internal SAP Web Dispatcher must be configured so it knows which requests to dispatch to which database on the basis of DNS alias host names. You do this by specifying the public URL of every tenant database in thexsengine.ini configuration file.

This is the documentation with the required steps:

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/2fb0d4e5bcf249d9a86e74ffb0a04f6e.html


 

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0