Open Closed

Question on the setup of tenant separated databases #1837


0
balessi75 created
  • ABP Framework version: v4.4.0 (Commercial)
  • UI type: Blazor Server
  • DB provider: EF Core
  • Tiered (MVC) or Identity Server Separated (Angular): no
  • Exception message and stack trace: N/A
  • Steps to reproduce the issue: N/A

Hello, We are new to ABP Commercial and have the following requirements with regards to multi-tenancy. Any information on whether these requirements can be accommodated by the framework would be appreciated. We have read through quite a few resources online, but haven't seen anyone implement our exact scenario. Any implementation details/resources that you can direct me too would be much appreciated.

Requirements:

  • Separate DB per tenant needed
  • Host related tables only in the default host database and not in each tenant DB
  • Each tenant needs to two separate databases accessible within one module. 
    • Does ABP commercial support this configuration? We noticed that the tenant management UI only allows for one separate connection string to be defined per tenant.
    • How would  we implement the ability for a tenant to be able to query between two tenant specific databases specific to them?

Thank you in advance. balessi75


1 Answer(s)
  • 0
    maliming created
    Support Team

    hi

    • √ Separate DB per tenant needed
    • √ Host related tables only in the default host database and not in each tenant DB

    Each tenant needs to two separate databases accessible within one module.

    Not supported by default, maybe you can try to customize MultiTenantConnectionStringResolver service.

    How would we implement the ability for a tenant to be able to query between two tenant specific databases specific to them?

    The connection string will automatically change When the tenant changes. https://docs.abp.io/en/abp/latest/Multi-Tenancy#change-the-current-tenant