Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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