How can we connect to data bases in different Servers dynamically based on the selection

[knvsiddarth]

Hi when you have two companies A & B where the data achitecture is as below .

Company A 

DatabaseName: dataA

Server: ServerA

Compnay B

DatabaseName: dataB

Server: ServerB

is there a way to paramertize selection of data source based on the selection of the company so that we can access the serverB when company B is selected .

In this case the database is SQL Server 2014 and both Databases contain exactly same database objects .

[Greg_Deckler · Accepted solution]

Yes, you would use Query Parameters to do this.

[Anonymous · Accepted solution]

Hi @knvsiddarth,

I have written a blog Post about templating in a multitenant environment.

in there you can find some useful things about setting parameters, updating datasources and credentials.

Hope it helps.

Thanos

[Greg_Deckler · Accepted solution]

Yes, you would use Query Parameters to do this.