Using a connection string instead of lib connect to

Ori — Fri, 15 Nov 2024 21:43:55 GMT

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 🙂

Re: Using a connection string instead of lib connect to

Jay_Brown — Fri, 23 Jun 2023 18:48:08 GMT

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-access-restriction.htm

Hope that helps!

topic Using a connection string instead of lib connect to in Connectivity & Data Prep

Using a connection string instead of lib connect to

Re: Using a connection string instead of lib connect to