Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ori
Contributor III
Contributor III

Using a connection string instead of lib connect to

Hi,

We're trying to find a method to reduce the time/effort in app creation for new clients.

one of things we're attempting is connecting to a database via a connection string instead of having to create a connection for each client.

Our initial thought was to set a string variable to hold the database name (they're all kept on the same postgres server, different database name for each client), and to connect by a string that will hold this variable to instruct the script which database to use.

From what i understand this method was available in prior versions using "CONNECT TO" but it isn't available unless we move the server to legacy mode, which may have other undesired implications.

Our Qlik version is the initial 2023 release.

Thanks in advance 🙂

Labels (2)
1 Solution

Accepted Solutions
Jay_Brown
Support
Support

Hello @Ori , your findings are correct.  You will need to use Legacy mode or stick with LIB CONNECT TO.

Please refer to the help here for limitations:
https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/LoadData/file-system-acce... 

Hope that helps!

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.

View solution in original post

1 Reply
Jay_Brown
Support
Support

Hello @Ori , your findings are correct.  You will need to use Legacy mode or stick with LIB CONNECT TO.

Please refer to the help here for limitations:
https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/LoadData/file-system-acce... 

Hope that helps!

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.