Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jmcy2408
Contributor III
Contributor III

Can i dynamically asign a database name to an existing SQL Server /lib connection whose logins/server is the same?

Hi,

 

I have an existing SQL Server connection setup using the Data Gateway and pointing  and authenticating to a singular database however the same server also has a number of other databases (different company name) but with identical table names.

 

I could create a new connection to each database but i was wondering if there is a way, perhaps via "WITH CONNECTION" where i can specify the database name utilizing the same connection details but pointing to a the different database names?  If so what that syntax should look like and if not is there another way?  

 

Thanks

John 

Labels (1)
  • SaaS

0 Replies