SQL Connection

[evansabres]

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.

[vishsaggi]

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

[evansabres]

How do you create a trigger?

[krishnacbe]

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.

[vishsaggi]

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.