How to Create Oracle database connection by passing parameter through script in Qlik Sense

MMK — Fri, 09 Jan 2026 11:49:47 GMT

Hi All,

I want create a oracle database connection by passing user name/Password through script.

We tried creating connection by using

LIB CONNECT TO 'Connection_name(User name=$(vUser), Password=$(vPassword))';

But it not working to me. Also we tried creating data connection using (Create new connection option) without passing username and password to connection. But unable to create it.

Could you please help us is there any solution to achieve this.

Re: How to Create Oracle database connection by passing parameter through script in Qlik Sense

Chanty4u — Mon, 12 Jan 2026 16:43:23 GMT

Try this

LET vConn =

IF('$(vEnv)' = 'PROD', 'Oracle_Prod', 'Oracle_Dev');

LIB CONNECT TO '$(vConn)';

topic How to Create Oracle database connection by passing parameter through script in Qlik Sense in Connectivity & Data Prep

How to Create Oracle database connection by passing parameter through script in Qlik Sense

Re: How to Create Oracle database connection by passing parameter through script in Qlik Sense