Customers with multiple tenants #6263

pablo@ccalp.net created one year ago

ABP Framework version: v7.4.0
UI Type: Angular
Database System: EF Core (SQL Server)

Hello, Is the following scenario possible to accomplish within the framework? How? We are implementing a Database Per Tenant multitenancy architecture. Our customers have multiple facilities and they need to create reports across those facilities, so we need to do cross-database queries, we are hosting in Azure so I don't want to do cross-database queries but be able to host the tenant facilities in a single database so that it is easier to query across the facility tenants.

Is it possible to have a multiple hybrid approach? for example:

Customer-A Customer-A-DB (SQL Database) Facility-a (TenantId: xxxx-xxxxx-xxxx) Facility-b (TenantId: xxxx-xxxxx-xxxx) Facility-c (TenantId: xxxx-xxxxx-xxxx)

Customer-B Customer-B-DB (SQL Database) Facility-a (TenantId: xxxx-xxxxx-xxxx) Facility-b (TenantId: xxxx-xxxxx-xxxx) Facility-c (TenantId: xxxx-xxxxx-xxxx)

Customer-C Customer-C-DB (SQL Database) Facility-a (TenantId: xxxx-xxxxx-xxxx) Facility-b (TenantId: xxxx-xxxxx-xxxx) Facility-c (TenantId: xxxx-xxxxx-xxxx)

TIA.

liangshiwei created one year ago

Support Team Fullstack Developer

Hi,

As I understand, a customer is a tenant. a facility can belong to multiple customers.

Just an idea:

The Facility entity should not implement the IMultiTenant interface, so It will be in the host database.

public class Facility: ...
{
    public List<Guid> TenantIds {get; set;}
}

public class TestAppService:....
{
    private readonly IRepository<Facility, Guid> _reopsitory;
    .....    
 
    public async Task GetReportAsync()
    {
        var currentTenantId = CurrentTenant.GetId();
        //Switch to host
        using(CurrentTenant.Change(null))
        {
          var result = await  _reopsitory.GetListAsync(x => x.TenantIds.Contains(currentTenantId));
        }
        
    }
}

pablo@ccalp.net created one year ago

Thanks for your prompt response, maybe I didn't explain well the scenario, hopefully, this diagram will help. I need to implement multiple Hybrid architectures where some tenants share a single database while some tenants may have their own database.

liangshiwei created one year ago

Support Team Fullstack Developer

Hi,

I need to implement multiple Hybrid architectures where some tenants share a single database while some tenants may have their own database.

Yes, it's possible, but I still don't know what's blocked you.

pablo@ccalp.net created one year ago

I need some guidance on how to accomplish it, it is not clear in the documentation for creating tenants, that's my block.

Update: I created 3 tenants with the same connection-string. When creating the first one, the database was created, then I created the two additional tenants with the same connection but the admin user and role records were not created.

liangshiwei created one year ago

Support Team Fullstack Developer

When creating the first one, the database was created, then I created the two additional tenants with the same connection but the admin user and role records were not created.

Could you share the steps to reproduce? I will check it out. thanks