Using a connection string instead of lib connect to

[Ori]

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 🙂

[Jay_Brown · Accepted solution]

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!