Integrating SAP Multitenant SaaS with SAP Analytics Cloud for Enhanced UI5 Fiori Experience in BTP

[Ratneshtoday1]

We've developed a Multitenant SaaS application using SAP CAPM, and we now have a requirement to display specific screens in UI5 from SAP Analytics Cloud (SAC) after establishing a connection to the tenant database. In our dedicated setup, we have successfully showcased these screens on the SAP UI5 Fiori interface.

Presently,

We maintain a separate SAC Tenant, establish a database connection, create stories, and integrate these stories onto the SAP UI5 Fiori Screen. However, in the context of Multitenancy, we've noticed that SAC is available in SAP Business Technology Platform (BTP). We are seeking guidance on leveraging the SAC SaaS solution within this framework to achieve our desired outcome. Any recommendations on how to effectively utilize SAC SaaS in this context would be greatly appreciated.

[shubham_gupta21]

Hi Ratnesh,

I am also currently trying to achieve the same scenario. Can you please share the solution if you achieve it.

Br,

Shubham

[gregorw]

I would suggest that you also add the SAC tag to your question.

[martinfrick]

Hi ratneshtoday1,

interesting question which we also stumbled upon when creating our multitenant SaaS sample scenario. Unfortunately, I am not aware of a standard solution in a multitenant context. Maybe gregorw has further insights based on his experience (seeing his name in some of the related blog posts and questions).

I can imagine that you might "somehow" be able to leverage the existing HANA Analytics Adapter (but probably not SOTA anymore) and connect to the tenant specific database containers leveraging a "Service Manager - Container" Service instance bound to the Analytics Adapter...

https://help.sap.com/docs/SAC_EMBEDDED_EDITION/8c9fe042688a4354876cc536267d442f/0bbb9d2ab76842359a69...

A similar demand has already been raised some time ago. Also check the respective question here:

https://answers.sap.com/questions/13480636/sap-hana-analytics-adapter-haa-in-a-multitenancy-c.html

The following blog post highlights a configuration option related to "multitenancy" using the Analytics Adapter:

https://blogs.sap.com/2020/05/05/connecting-sac-to-hana-cloud-the-easy-way-using-application-studio-...

Please let us know in case you find a solution to this requirement.

Best,

Martin