Load Data from server Via ODBC automaticcaly

[theboss-123]

Hello ,

please should be informed that i set up Qlikview Server i publish succefully my QVD,but i have  a question 

does it is possible to schedule load of data without intervention manually so when data will be updated on the database source the result could be displayedautomatically on the broweser.

thanks in advancy

[Chip_Matejowsky · Accepted solution]

Hi @theboss-123,

Yes you can set up unattended, scheduled tasks with QlikView Server. 

A prerequisite would be to ensure that the account performing the data reload, the QlikView service account running all the QV services, has the appropriate permissions on the database side to access/read the data.  Another option would be setup account'/password to the database in the load script of the app.

The next question for you is if you have QlikView Publisher license applied or not?  If you do have Publisher enabled, follow the steps listed in Section 3 Installing and Configuring QlikView Publisher in the attached A Simple Installation.docx file. This is an older Qlik Support document, but it still applies to your question.

If you don't have Publisher enabled, then you'll be using the QlikView Server Reload Engine.  In QlikView Management Console (QMC) > Documents > User Documents, highlight the QVW file you want to schedule the reload.  Then click the Reload tab on the right, and configure your desired schedule.

[theboss-123]

Hi Matejowsky thank you very much

please should be informed that your solution work perfectly, i forced the qlikiew to use ODBC system DSN