topic Re: SQL Connection in QlikView

SQL Connection

evansabres — Fri, 20 Oct 2017 17:19:38 GMT

I have an application for which the data is a SQL connection. The data feed is refreshed from the source every fifteen minutes. After I have placed the application on the AccessPoint, what refresh frequency do I need to set the application to if any? The data does not seem to be refreshing automatically as I assumed it would due to the SQL connection.

Re: SQL Connection

vishsaggi — Fri, 20 Oct 2017 17:26:47 GMT

you can create a trigger from QMC for this qvw file and set what ever frequency you want.

Re: SQL Connection

evansabres — Fri, 20 Oct 2017 17:27:54 GMT

How do you create a trigger?

Re: SQL Connection

krishnacbe — Fri, 20 Oct 2017 17:43:04 GMT

Hi,

If you are expecting to refresh application once the SQL refresh is done, then you need to try EDX option or else you need to refresh the dashboard in multiple frequencies in QMC. Using Task Triggers as mentioned by Viswarath.

Hope you would have created task to deploy to User documents folder. Edit the task and create Triggers.

Re: SQL Connection

vishsaggi — Fri, 20 Oct 2017 17:44:20 GMT

Do you have access to QMC the Console. First when you move your qvw file from your dev/QA server to PROD.

Assuming you have done the below steps:

1. You create a folder on PROD QV server in SourceDocuments folder. You copy your qvw file here.

2. Once you copy you can see your qvw file on QMC SourceDocuments folder. Like below:

Follow these steps Click Ok after the configure trigger and click apply then a task will be created. Just run that task.

Change the Task name accordingly.