Forum Discussion
How can we connect to data bases in different Servers dynamically based on the selection
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 .
Yes, you would use Query Parameters to do this.
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
2 Replies
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
Community Champion
Yes, you would use Query Parameters to do this.