Redirect the Information Link connection between Spotfire Sites

We are using two different sites in two different regions (Region A and Region B).

The Spotfire database is replicated and synchronized in the two regions.

When an information link has been created in site A, a url is produced with the site A server (e.g. tibcospotfire:server:http\://SpotfireServerInSiteA.domain.com/:informationlink:e1250c34-ecec-472b-ba27-c275b059095e).

Since we are using two sites, we would initially need the library items to produce two urls.

With the assumption that one Spotfire server is used per site, the above requirement would produce the following information link urls:

ulr1: tibcospotfire:server:http\://SpotfireServerInSiteA.domain.com/:informationlink:e1250c34-ecec-472b-ba27-c275b059095e)

url2: tibcospotfire:server:http\://SpotfireServerInSiteB.domain.com/:informationlink:e1250c34-ecec-472b-ba27-c275b059095e)

Then, when the Information Link loads data, it should redirect the DB connection url based on the site (i.e. when SpotfireServerInSiteB is used, the connection should be with the pre-configured DB instance in region B)

As an idea, the configuration could be in the "datasource configuration" with the option to associate Spotfire Servers with a "loading DB connection url":

Spotfire ServerA: connection url pointing to DB instance in region A

Spotfire ServerB: connection url pointing to DB instance in region B

The above enhancement would help us to minimize latency between the regions.

Thanks.