cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
knvsiddarth Visitor
Visitor

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 .

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

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

Yes, you would use Query Parameters to do this.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


thanosd Member
Member

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

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 2
Super User
Super User

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

Yes, you would use Query Parameters to do this.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


thanosd Member
Member

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

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