Multi-tenant legacy database connection

Multi-tenant legacy database connection


We have a multi-tenant eSpace that must access a legacy database. We have created an extension where we declare all entities of this legacy database.

The problem is that we have several instances of this legacy database, and each tenant should access a different instance.

We could create several Database Connections (in Service Center), pointing to diferent instances of the legacy database, but we could not find how to associate the DbConnections with the their tenants (it seems the relationship can only be declared between the EXTENSION (not eSpace/tenant) and the DBCONNECTION).

Well, I don´t know if I could make me undarstand, but in short: each TENANT should access its own LEGACY DATABASE. Is there any way to do that ? Does anyone has any sugestion to handle these "multi-tenant legacy databases" ?