Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How is data stored on qlikview server

Hi all, can anyone point me out on info on how do qvws that I put on QlikView server access the original data source?

the original data source is a MySQL DB

thanks

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The QVW does not access the source DB at all, except when the load script is executed.  The data you load into the qvw remains static until you reload -- that is, run the script again.  Allo loaded data is stored within the QVW file itself.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Anonymous
Not applicable
Author

So, the server will have the odbc connection and I can send a reload instruction every day ?

thanks

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can schedule the reload from the QlikView Management Console (QMC).

If the script database connection is ODBC, the ODBC DSN and drivers must be defined on the server.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Anonymous
Not applicable
Author

Thanks All !