Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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

 

1 Reply
Highlighted
Partner
Partner

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