Switching SQL Database connection string from one environment to another in Qlik Sense

[Rdhanikonda79]

Hi All,

Please let me know the steps involved in swicthing SQL Database connection string from one environment to another in Qlik Sense.

In Qlikview , we used to go to connection string in Script Editor and replace the Dev with Test or PROD. Is the same way works in Qliksense or differently.

Thanks

Revanth

[paoloderegibus]

You should create 3 different data connections in QMC (if you have Qlik Sense Enterprise) or 3 different data connections in your app if you have Qlik Sense Desktop and use the right one as you were doing with QlikView:

IF '$(env)'='PROD' THEN

LIB CONNECT TO MY_SQL_PROD;

ELSEIF '$(env)'='TEST' THEN

LIB CONNECT TO MY_SQL_TEST;

ELSE

LIB CONNECT TO MY_SQL_DEV;

ENDIF