I also use it to add their db to the TenantDataSouces, albeit it is
loaded through the webtools. I also keep a copy of their theme. keeps
everything for a tenant in one place.
I am working on a couple of major changes that I sent to the dev mailing
list but have not had any discussion on.
subject: Step to automate Setup for entityengine.xml
using derby for setup controller
on 8/27
also see discussion on
https://issues.apache.org/jira/browse/OFBIZ-635
https://issues.apache.org/jira/browse/OFBIZ-3908
=========================
BJ Freeman <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Carsten Schinzer sent the following on 9/15/2010 5:05 AM:
Thanks so much, BJ.
You are absolutely right, the latter should avoid any conflicts on the
specialpurpose/ecommerce side.
I think I'[ll just give it a try now and start fuzzing around on a test
setup.
Regards
Carsten
2010/9/15 BJ Freeman<[email protected]>
personally I make a component for each tenant
and put all there stuff in that.
=========================
BJ Freeman<http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation<
http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com<http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
BJ Freeman sent the following on 9/14/2010 7:22 PM:
https://cwiki.apache.org/OFBIZ/multitenancy-support.html
look in the current framework/entity/config/entityengine.xml for data
bases.
if you have special data for each tenant then you would configure the
component-load.xml with :
<entity-resource type="data" reader-name="ext-tenantname" loader="main"
location="data/TenantnameProductData.xml"/>
$ java -Xmx512m -XX:MaxPermSize=128m -jar ofbiz.jar -install
-readers=ext-tenantname -delegator=default#(whatever the login is for
that tenant)
would load the special data for ext-tenantname into the db for that
tenant.
=========================
BJ Freeman<http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com<http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Carsten Schinzer sent the following on 9/14/2010 2:23 PM:
Another, related question to the Multi-Tenant experts, please:
What databases are required? - I currently assume, a core DB plus one
DB per
tenant.
Where does common seed data reside? Is sed data meant to be common at
all,
or would each database reflect a full-fletched OFBiz database and
could be
connected as a stand-alone DB as well?
* I assume, seed data us on the common core DB, while running data
reside in
the tenants DBs. *
Example:
- AccountingTypeData.xml --> to be loaded once for all tenants; -->
core DB
- Running accounting data (transactions, finAccounts) --> tenant DB
How to direct certain data to certain databases? - is there a built-in
way
by dedicated readers? Or do I need to take care that customer specific
data
files for upload are copied in/out before respective loads?
Example:
- I want to load a set of initial ProductData.xml per Tenant; I do
follow a
private naming convention like TenantnameProductData.xml
--> How do I direct this initial data into the tenant's database and
how do
I avoid the it is loaded to the other tenant's?
Ideas are:
(i) edit ofbiz-component.xml before every load attempt;
(ii) copy related Tenant files in and let the loads fail for non-existing
files;
(iii) define dedicated readers (e.g. "ext-tenantname") and limit tenant
database to loads from that reader only.
Let me know your comments.
Regards
Carsten
