Hallo guys,
We have used since 2015 the QDF with QlikView. We have DEV, TEST and PROD environment in our company. Now we want to launch Sense next to QlikView. Unfortunately I have found that loading of data in Sense is not the same as in QlikView. In Sense you have to create first a connection and then use this one with the LIB command to load the data. Because each environment has a different path I have to create three connection for every environment. Is there any solution where I can handle all 3 environments with only one connection? I coundn't find anything to this issue in the QDF documentation. At this time I can imagine how can I deploy from TEST to PROD without changing the path in the connection.
Thanks for helping me in advance!
BR,
Rumen
Hi Rumen, you need three lib's, one for each environment, but you can control what lib's to use dynamically by using the variable vG.RootContainer first in the script, example:
SET vG.RootContainer=’DEV’;
$(Include=lib://$(vG.RootContainer)\InitLink.qvs);
vG.RootContainer can be "auto-fetched" by renaming the app to the current environment, like Sales_DEV and fetching the last three letters using DocumentName( )
Replying to get notified too.
We just created the connections manually and added 'Security Rules'.
Curious to hear about other ways.
Hi Rumen, you need three lib's, one for each environment, but you can control what lib's to use dynamically by using the variable vG.RootContainer first in the script, example:
SET vG.RootContainer=’DEV’;
$(Include=lib://$(vG.RootContainer)\InitLink.qvs);
vG.RootContainer can be "auto-fetched" by renaming the app to the current environment, like Sales_DEV and fetching the last three letters using DocumentName( )
Thank you for your suggestions guys. Because we don't have QMC yet, I would prefer the solution of Magnus.
BR,
Rumen