Struggling on how to divide our ERP according to the Compary regional offices may someone help.

[dumbaclassics]

Hello Family.

We have been developing in django for 2years now. Our company recently migrated from a manual system to an ERP and we opted for Django. We have a nice working ERP  with accounting, inventory, hr, crm and scheduling modules.

The problem is that the Company has got regional branches and now they would want us to come with a solution where the Head Office has access to summary data an all its branches, branches managing their own affairs without them stumbling on one another. We have been researching on solutions and django_tenants did come up when it comes to seperation of databases by schemas but still we dont see how then the Company head office can have an overall access to its branches at the same time offer service based on utilising the System Modules. 

Any suggestion would be much appreciated

Thanks

Sent from my Samsung Galaxy smartphone.

[Ishwor Khanal]

Here is the deal, go for semi isolation approach that is separate schema for each tenant and public schema for global database (tenant information, reports or any other table) it is quite easy to maintain and scale as well. If you would like to dive into depth follow micro architecture pattern i.e. db per app means if you have HR module in your system create one app named app_hr and db_app_hr, further down follow the semi-isolation schema approach in each app as well.

Ask me anything you would like to discuss in detail. Happy to discuss about architecture as we have been working one heavy educational project based on multi-tenant SAAS using python, python-jango, python-django tenant-schema, postgres.....

Thank you

Regards

Ishwor

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/i80aomak4baf6ivi8choq8xy.1582455839916%40email.android.com.

[maninder singh Kumar]

The branch offices could be a separate organization unit

Maninder Kumar about.me/maninder.s.kumar

--