Variable sql db name or schema name

Wed, 06 May 2015 09:46:02 GMT

We are planning on setting up a centralised Qlikview environment for different clients, at first this will be run centrally, but this whole idea is still on the drawing board.

1. How do I implement a variable database name or a schema name? We are still looking at which of the two we will be using. My idea would be to have a model per client with a variable in the connection string. As we want to use the same model for all clients we might need to look at a text or excel file, or else a central database table with the variables. I am not sure though how to implement it, other that having the path name of the model giving an indication of the client..

2. The idea the others in my team have, most do not have Qlikview experience, is having one model which you reload as needed for any of the clients. Personally i can't see how this would work, I may be wrong in thinking there is not a way of doing this. I personally think the rest of the guys think Reporting services where you can just add a dropdown list to select the database or schema name.

Is there any way of doing option 2? If now how would you do option 1.

Re: Variable sql db name or schema name

datanibbler — Wed, 06 May 2015 09:53:30 GMT

Hi,

I have never done such a thing - in our company, there is only one database per plant - so there are several, but we have one loading_script per database - but I cannot imagine a reason why this should not work (your option 1).

The connection string, after all, is just a text string. You should be able to use variables for that. You can

- create a listbox (from an Inline_table) on the GUI of your app to select a database

- Based on that selection, you fill a variable

- add a button to trigger a regular reload

=> The value of that variable can be used in the connection string.

For this option, you need more than one way to reload the script, but that too is doable if you use conditional_execution (an IF_THEN bracket)

HTH

topic Variable sql db name or schema name in QlikView

Variable sql db name or schema name

Re: Variable sql db name or schema name