I am trying to build an Multitarget application (MTA) application using multitenancy, I understand SAP recommends to use separate schema approach for multitenancy however I want to know how can we combine separate schema and multiple db instance approach in one Multitarget application (MTA) application. So whenever we have a customer who wants a new db instance then they should be able to subscribe to new instance and another customer wants db sharing then our application to should be able to serve with schema separation.
Many Thanks,
Manasa