Bigcapital is a smart and open-source accounting and inventory software, Bigcapital keeps all business finances in right place and automates accounting processes to give the business powerful and intelligent financial statements and reports to help in making decisions.
Bigcapital is built with a multi-tenancy architecture that allows multiple organizations to use the same software while keeping their data separate from each other. This means that every organization that uses the software has its own database that is isolated from other organizations’ databases. At the same time there’s a master or system database mutual between all tenants.
Every organization that signs up for the software is given a unique identifier (Tenant ID). When an organization logs in, the server retrieves the organization’s tenant ID from the login request and uses it to identify the organization’s database.
All database operations performed by the organization’s users are performed on their own database.
The server instance acts as a middleware between the client-side application and the database, and it routes all requests to the appropriate database based on the tenant ID.
Github release here.
Documentation here.
