https://community.qlik.com/t5/App-Development/Can-i-dynamically-asign-a-database-name-to-an-existing-SQL/m-p/2078471#M88465 <P>Hi,</P> <P>&nbsp;</P> <P>I have an existing SQL Server connection setup using the Data Gateway and pointing&nbsp; 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.</P> <P>&nbsp;</P> <P>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?&nbsp; If so what that syntax should look like and if not is there another way?&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>Thanks</P> <P>John&nbsp;</P> Wed, 31 May 2023 15:05:27 GMT jmcy2408 2023-05-31T15:05:27Z https://community.qlik.com/t5/App-Development/Can-i-dynamically-asign-a-database-name-to-an-existing-SQL/m-p/2078471#M88465 <P>Hi,</P> <P>&nbsp;</P> <P>I have an existing SQL Server connection setup using the Data Gateway and pointing&nbsp; 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.</P> <P>&nbsp;</P> <P>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?&nbsp; If so what that syntax should look like and if not is there another way?&nbsp;&nbsp;</P> <P>&nbsp;</P> <P>Thanks</P> <P>John&nbsp;</P> Wed, 31 May 2023 15:05:27 GMT https://community.qlik.com/t5/App-Development/Can-i-dynamically-asign-a-database-name-to-an-existing-SQL/m-p/2078471#M88465 jmcy2408 2023-05-31T15:05:27Z