Multi-Tenant Application Development.

[harbymina041]

Greetings experts,

I have been tasked with building a multi-tenant application, also known as SaaS. My understanding is that when developing and deploying the application, it is done on the provider's subaccount, in this case, mine. Upon subscription by clients, they are granted a URL for accessing and viewing the application. My specific question is as follows: Is it possible, at the time of the client's subscription, for the database schema deployment to occur on the client's BTP platform, while the frontend of my application remains on my account? I ask this because several clients have expressed their desire to have the data managed by the application entirely under their domain, especially since our application will deal with information from the FI module. I am open to any ideas or suggestions. Thank you very much.

[martinfrick]

Hi harby04,

I am not currently aware of a standard solution that facilitates the configuration of such a scenario. However, it is conceivable that you could establish dynamic connectivity to a SAP HANA Cloud database at runtime by leveraging the @sap/hana-client library.

For instance, you could potentially store the customer's SAP HANA Cloud credentials within a designated Destination within a Tenant Subaccount or employ a Credential Store to host your customer's SAP HANA Cloud Credentials.

It's important to note that this approach may not be considered ideal, and I would hesitate to wholeheartedly recommend it. Regardless, it's worth mentioning that the deployment and management of schemas in this context might present complex challenges...

Best,

Martin