topic Data manager and changing LIB with environments in Connectivity & Data Prep

Data manager and changing LIB with environments

Michiel_QV_Fan — Fri, 31 Mar 2023 13:32:09 GMT

we have 3 environments, DEV, TEST and PROD.

Each has its own LIB connection, like: lib://qlikview@dwh_load@test

We have to use a variable based on the file name to determine which environment to load from (dev, test, prod).

But,

when using Data Manager this variable cannot be set without unlocking the script. And I want to use data manager as script editor.

Is there a solution for this to get the variable lib in the table extraction in data manager?

Re: Data manager and changing LIB with environments

molinaantonio — Tue, 11 Apr 2023 16:21:55 GMT

Hello @Michiel_QV_Fan

Crazy Idea over here 😁 (kind of old approach)

Try to have a file (like csv):

e.g. (pasted an inline version in attachment)

Server, Environment, Lib

node1, dev, lib-de

node2, dev, lib-dev

node1, test, lib-test

node2, test, lib-test

node1, prod, lib-prod

node2, prod, lib-prod

Having a file like this you can drag & drop it to the data manager to use it alog with in the script the function ComputerName() (has to match with the column Server of the csv file to work properly)

Hope it helps you 😀

Rgds,

Toni

Re: Data manager and changing LIB with environments

Michiel_QV_Fan — Wed, 12 Apr 2023 05:28:28 GMT

Thanks. But still, the LIB cannot be changed in Data manager. That is fixed and locked.

Re: Data manager and changing LIB with environments

molinaantonio — Wed, 19 Apr 2023 16:04:48 GMT

Question, are you looking to modify directly there because the app has old data and you want somehow modify the values?

If so, maybe you can store all the tables inside the app into csv. Delete the one that is bothering you with old data and follow the approach mentioned in my prior entry :).

Rgds,

Toni