mORMot Open Source

We develop an ERP application that's currently deployed on-premises. It consists of a thin-client and a monolithic backend, which we are looking to upgrade (and probably convert to microservices) with mORMot or another REST solution. A next step would be to make the backend multi-tenant, so one backend server can handle sessions for users of multiple customers. Each customer has his own database (and several users).

Because the server is stateless (and the request specifies which tenants it belongs to), each request must get a database-connection for the database for this tenant. For services defined via interfaces we can switch the database-connection ourselves, but how would that work for the ORM? All examples I've seen already bind the database before using the ORM.

Another question: because we want to serve multiple tenants with one backend, our users would have to authenticate with company/user/password. The examples I've seen all authenticate with only user and password. Can we use your default authentication with the added "company"?

How do other companies with multi-tenant solutions tackle these issues, what are the best practices?

Thanks for your help!