topic Re: direct link using SQL in QlikView

direct link using SQL

Wed, 25 Nov 2020 16:16:04 GMT

Can you use this file below to connect to and have it refresh from the dashboard?

Microsoft Excel ODBC Query File (.dqy)

Re: direct link using SQL

oknotsen — Fri, 10 Jun 2016 14:58:35 GMT

Not possible.

However, you can probably use Direct Discovery to achieve the same thing instead. Depends on what you are trying to achieve of course.

Re: direct link using SQL

Fri, 10 Jun 2016 15:42:14 GMT

direct discovery? not sure how to use that ?

Re: direct link using SQL

Colin-Albert — Fri, 10 Jun 2016 15:49:10 GMT

No, but if you can get the SQL connection details and SQL query, then you can use the SQL query to load the data into QlikView.

The DQY file contains the connection string & SQL query.

See here for more details https://support.microsoft.com/en-us/kb/164729

Re: direct link using SQL

oknotsen — Fri, 10 Jun 2016 19:21:18 GMT

See here for a lot of information about it:

Direct Discovery ‒ QlikView

Question is:

What is it that you want to achieve? If you want one table to be real-time data, Direct Discovery might be the answer.

Be sure to set the cache time-out for direct discovery to a short period of time; default is 30 minutes. I don't recall the name of the variable to set for it at the moment, but it is set in seconds.