Hi Mallah, Thanks a lot of information, I didn't know about this possibility! As far as intercompany management is concerned, you are certainly right, it is not worth making such a big rework. In my experience, however, I had that problem in the case of clients with different companies. I'm talking about a single customer with many companies. They were accustomed with other ERPs to a single table and all the management of consolidated financial statements and business intelligence systems was based on individual tables. Consider that having multicompany structures with the same shared account plan managed on the same table has many advantages that you can hardly achieve with different schemes. You just need the example of the chart of accounts, which can be managed identical for all the companies in the group (therefore without duplicating it in N schema), in this case the id of the company is zero, so the same chart of accounts is valid for all companies. I guarantee you that in certain environments accustomed to SAP or JDE a multidatabase structure could be a serious constraint. Regards N
Il giorno gio 17 ott 2019 alle ore 08:25 Rajesh Mallah < [email protected]> ha scritto: > Hi Nicola , > > Many advanced databases like postgresql and oracle (possibly mysql) > Allow the feature of "schemas" which are namespaces within same database. > > OFBiz already allows specification of schema in entityengine.xml. > interschema SQL queries are already allowed. > > Hence creating a DB for each tenant is also a matter of choice. > The DB permission structure around schemas allows implementation > of access control. > > >> It would be an > >> interesting feature to make ofbiz multicompany but it would imply a > heavy > >> revision of the data model. > > I think it is not worth , also it will make customers jittery to remain in > shared tables. > > regds > mallah. > > > > > On Thu, Oct 17, 2019 at 11:16 AM Nicola Mazzoni <[email protected] > > > wrote: > > > Hi, > > The multitenant structure is ootb in ofbiz and is based on multiple db. > In > > practice, each tenant uses a different database. Other ERPs have the > > company id in the pk of all tables, so it is possible to use multiple > > companies with a single database, this is very useful in intercompany > > management. However, having separate databases allows a clearer > > segregation of data but greater management difficulties. It would be an > > interesting feature to make ofbiz multicompany but it would imply a heavy > > revision of the data model. > > Best regards > > Nm > > > > > > Il mer 2 ott 2019, 12:04 Suraj Khurana <[email protected]> ha > > scritto: > > > > > Hello Sridharreddy, > > > > > > Yes, OFBiz support multi-tenancy. This document might help you: > > > > > > https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support > > > > > > -- > > > Kind Regards, > > > Suraj Khurana > > > Technical Consultant > > > HotWax Systems > > > Enterprise open source experts > > > http://www.hotwaxsystems.com > > > > > > > > > > > > > > > > > > > > > On Wed, Oct 2, 2019 at 3:29 PM sridharreddy u <[email protected] > > > > > wrote: > > > > > > > Dear Support, > > > > > > > > We sell SAAS software to Financial Organisation. Each Organisation > > needs > > > > their own ERP for account management. So, we are evaluating OFBIZ to > > use > > > > this purpose. We will integrate our application with OFBIZ (as > plugin) > > > and > > > > each organisation will have their own view of accounting. > > > > > > > > Does OFBIZ support multi tenancy model where I deploy OFBIZ (with > > single > > > > instance in scalable mode) in CLOUD and each organisation will be > able > > to > > > > access their own data. > > > > > > > > If not, do you have any suggestion on how to USE OFBIZ for multi > > tenancy > > > > purpose. > > > > > > > > > > > > BR, > > > > Sridhar Reddy U > > > > > > > > > > -- Nicola Mazzoni *Mp Styl**e Srl* via Meucci, 37 41019 Limidi di Soliera (MO) T 059/684916 M 347/9905529 www.mpstyle.it
