direct link using SQL

[#1]

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

Microsoft Excel ODBC Query File (.dqy)

[oknotsen]

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.

[#3]

direct discovery?   not sure how to use that ?

[Colin-Albert]

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

[oknotsen · Accepted solution]

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.