Hi Hammad, First of all, whether to have separate databases per tenant or having tenant separation within one database is an architectural choice. Both have their pros and cons.
Currently, the default setup regarding the tenant database(s) is very straight forward: 2 are necessary, and if using the default derby setup these will be created. When using external rdbms solutions, like mysql, postgresql, oracle or mssql, more effort is required. A one time configuration setup, and then creating the 2 databases in the rdbms). But with a little effort applied it can even be made to use 1 database per tenant. Re: the document (linked) It can be done a lot easier. Just use the ./ant create-tenant command to establish the tenants databases and populate these. Best regards, Pierre Smits *OFBiz Extensions Marketplace* http://oem.ofbizci.net/oci-2/ On Tue, Nov 10, 2015 at 11:01 PM, Hammad Afridi < [email protected]> wrote: > Hello everyone,I have been looking into the multitenancy support in ofbiz. > It seems the architecture is based on having a separate database for each > tenant rather than using one single db with differentiating tenant data > based on 'tenantId'. > There are some configuration steps as set in the following url to enable > multitenancy : > > https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support#Multitenancysupport-Settingtheecommerceapp.touseanspecificTenantDatabase > > And it seems it is all manual to add a new tenant. My question here is, is > there any way to add multiple tenant in an automated way? So that whenever > a new tenant signup for a new account we can do it dynamically from the > website? Please suggest. Thanks. > Regards, > Hammad Ali Khan Afridi Skype hammad.afridi > >
