Le 22/02/2020 à 18:51, Alaa Murad a écrit :
Thanks a lot for all replies, one important feature that we need is to be able to run unlimited companies (with Chinese Walls between them) , do we
really need to have a new DB for each company ?
According to
https://www.experts-exchange.com/articles/6539/Multi-tenant-Database-Shared-Database-Separate-Schema-in-SQL-Server.html
There are mostly 3 ways to implement multitenant Separate Databases Shared
Database, Separate Schemas Shared Database, Shared Schema
OFBiz uses the 1st. So with this way you will have as much as *tenant* DBs as
you introduce *tenants*. Pro and cons are explained in the document above.
how that will even work, one risk that caching (from JDBC driver, or Ofbiz itself) maybe a problem , i.e. this is not PHP were each call is 100%
hitting the db, in Java we cache many stuff in JVM memory ! unless this will result in a new ofbiz instance (in JVM) in this case running ofbiz as
SaaS will be very expensive.
Our POS system is a SaaS and we may have 100s or 1000s of clients/companies and
we don't want to spin a new ofbiz instance for each one !
There should not be worries with caching. Because with "multitenant Separate Databases" you run only one OFBiz instance with a DB per tenant but,
thanks to the delegator concept, OFBiz knows what data belong to what tenant.
This said currently there is no mechanism to automatically create tenants DBs on fly in OFBiz. So you would need to implement that. For 100s to 1000s
client it's at the limit of reasonable. I worked for a client who hoped for much more (up to millions). Then OFBIz is hardly suitable and a solution
based on OFBiz in this case demands a lot of code change.
I'm confused a bit about "2 tenants" and that we need to have 2 databases for
each !
I hope the article above helps.
HTH
Jacques
Thanks in advance !
On 2/20/20 2:09 PM, Jacques Le Roux wrote:
Hi,
Inline completing Pierre's answer as much as possible
Le 20/02/2020 à 08:37, Pierre Smits a écrit :
On Thu, Feb 20, 2020 at 2:15 AM Alaa Murad <[email protected]> wrote:
2. We are planning to use ofbiz for few different companies, they all
100% independent, can we have one ofbiz instance for all of them ?how ?
In this scenario I would advice to set up 2 tenants to ensure having
Chinese Walls between the 2 companies. Each tenant would have its own
database, and can have different plugins in play.
BTW, you may have as most as tenants you need
3. How easy to sync/push products, invoices , payments , etc. from our
POS --> ofbiz (i.e. can we insert invoice via APIs)
You may follow one of the suggested ways here:
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
Be sure to compare with the other different possible ways documented in the children pages of this page and pick the one (or several) which best
fit/s your needs.
5. I do see Arabic support implemented to some degree, but is it full
support, for example currency format, RTL (both web and PDF)
RTL is supported in Web, I don't think it is in PDF. Currency is supported in both. Since we are using NotoSans font by default you can use a very
large set of characters in PDF.
You may have a look at
https://demo-trunk.ofbiz.apache.org/example/control/fonts.pdf
6. Finally, how stable/active is ofbiz ? I see 30-40 emails per month
only in the mailing list, this make me very worry !
OFBiz was born in 2001, became a Top Level Project (TLP) in Apache Software
Foundation (ASF) in 2006 and was mature around 2010.
So yes it's pretty stable and safe (security). Since OFBiz is mature the
activity as decreased with a pick around 2016 as you can see here:
https://ofbiz.markmail.org/
HTH
Jacques
