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

[MMK]

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.

[Chanty4u]

Try this 

LET vConn =

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

LIB CONNECT TO '$(vConn)';