topic Re: How to Get Database Name which we have connected to? in QlikView

How to Get Database Name which we have connected to?

swapnil_kumbhar — Wed, 28 Jan 2015 13:03:14 GMT

Hi,

Is there any function available in Qlikview which gives us currently connected Database name?

Attached herewith screenshot for reference. I want to store these values in Variable.

Regards,

Swapnil

Re: How to Get Database Name which we have connected to?

Gysbert_Wassenaar — Wed, 28 Jan 2015 13:16:58 GMT

When a user interacts with a Qlikview document there is no connection with a database. Only when the document is reloading will there be a connection with a database. If you want you can create variables in the script containing the connection information, but you have to set the values yourself. You could then use the variables in the CONNECT statement too. What some developers do is create files for small script snippets for connection statements and use the include or must_include variables to insert these script files in the script.

Re: How to Get Database Name which we have connected to?

Anonymous — Wed, 28 Jan 2015 13:24:45 GMT

Most of my data sources are Oracle databases and I often need to extract the Oracle User Name and include it as a field in the QlikView table. Which I do using this SQL.

SELECT user FROM dual ;

Re: How to Get Database Name which we have connected to?

swapnil_kumbhar — Wed, 28 Jan 2015 13:25:51 GMT

So for that Variable i need to insert connection information manually. I will not get it automatically.

Is it right?

Re: How to Get Database Name which we have connected to?

Gysbert_Wassenaar — Wed, 28 Jan 2015 13:27:53 GMT

That's correct.

Re: How to Get Database Name which we have connected to?

Gysbert_Wassenaar — Wed, 28 Jan 2015 13:30:15 GMT

Well, yes, you can get all sorts of metadata from a dbms too. But if you first specify you want to connect to database foo as user bar and you then want this values available as variables as well, why not create them as variables in the first place and then reuse those variables in the connect statement?

Re: How to Get Database Name which we have connected to?

Anonymous — Wed, 28 Jan 2015 13:32:57 GMT

Yup - there is more than one way to skin a cat.