Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 !