my personal preference is multi tenant,
I wanted you to know your options as to approach.
At this time the Setup component does not support SAS. Actually the
Setup does not support more than one owner with a single db either.
see
https://localhost:8443/ofbizsetup/control/main
https://issues.apache.org/jira/browse/OFBIZ-635
https://issues.apache.org/jira/browse/OFBIZ-3908
There is no way, SAS wise, to create and connect new db's on the fly.
The easiest is to keep DB already created in the multi-tenant then
assign them as clients come on the system. Depending on your setup a
separate DB server machine or a farm of them may be in order.
also some work needs to be done to incorporate themes into setup.
or you can supply a mirad of "skins" (themes) they can select. this
would not allow for a personal logo though.
I suggest you use the host Ecommerce for sign up of SAS so it is totally
automated. this would require some customization you can change the url
and use an email to direct them so it does not get googled.
frank sent the following on 9/13/2010 6:03 PM:
Hi BJ,
Thanks for your response. So the relationship/requirement for each tenant is
autonomous (i.e. a tenant will typically be a standalone company with a
number of employees) in context of the functions and data (i.e. orders,
invoices, accounts) they access/update/view and report on including tenant
level branding (i.e. cosmetic look and feel, own company logo displayed on
accounts/order/product applications, company specific report branding etc.).
Do you think the separate Db approach might be better suited and if so your
thoughts on implementing this in a self service manner (i.e. not having to
compile software and/or apply development level config for new tenants)
would be appreciated. Conversely if you think there is another way to
achieve this?
Thanks again
frank