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

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



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?  




Labels (1)
  • SaaS

0 Replies