topic Qlik Sense QVD in QlikView

Qlik Sense QVD

ch_riadh — Mon, 16 May 2016 09:18:12 GMT

Hello.

With Qlik Sense Desktop, After extracting a table from a database (SQL), i store the table in a QVD and then i can use it.

but

With Qlik Sense server if i want to do the same think ! it have to be stored in the repository data base or where ?
and how the Schedule Service will do the auto reload. ?

Re: Qlik Sense QVD

Gysbert_Wassenaar — Mon, 16 May 2016 09:41:05 GMT

The qvd will be stored on the file system. While you can use absolute paths (as long as the Qlik Server has access to that path) you should use a folder connection that you added to the library:

Store * from mytable into 'lib://FolderConnection/myfile.qvd';

You can then later load date from that qvd, for example in another app, using the same library connection.

See the online help for more information: Store ‒ Qlik Sense

Re: Qlik Sense QVD

ch_riadh — Mon, 16 May 2016 09:56:50 GMT

Thank you gwassenaar

But what do you mean by library connection.
I have to create a Library from the Console management ? and then store the DVD there ?

Re: Qlik Sense QVD

ch_riadh — Mon, 16 May 2016 10:03:24 GMT

if i want to do an auto reload i think i have to use store the table in a Lib. right ?

Re: Qlik Sense QVD

Gysbert_Wassenaar — Mon, 16 May 2016 10:11:28 GMT

I have to create a Library from the Console management ?

Yes. See the Folder data connection settings section on this help page: Connect to data sources ‒ Qlik Sense

and then store the DVD there ?

I usually store my DVD's in a box along with my CD's, but you're free to store them wherever you like.

Re: Qlik Sense QVD

ch_riadh — Mon, 16 May 2016 10:21:13 GMT

and if i want to do an auto reload i think i have to use store the table in a Lib. right ?

Qlik Sense QVD

Re: Qlik Sense QVD

Gysbert_Wassenaar — Mon, 16 May 2016 10:23:50 GMT

No.The connection to the folder in which it is stored is added to the library. The qvd is stored on the file system. The qvd file is referenced using the connection from the library.

Re: Qlik Sense QVD

ch_riadh — Tue, 17 May 2016 10:17:11 GMT

so what is the differance between store the QVD in my hard Drive and Store it in the Repository Database ?

Re: Qlik Sense QVD

Gysbert_Wassenaar — Tue, 17 May 2016 11:15:35 GMT

The first is what happens and the second is what doesn't happen. QVD files are stored on the file system, not in the database.

Re: Qlik Sense QVD

ch_riadh — Tue, 17 May 2016 11:27:17 GMT

file system, you mean hard drive, like with qlikview right ?

So why i need the repository database ?

Re: Qlik Sense QVD

Gysbert_Wassenaar — Tue, 17 May 2016 11:42:23 GMT

The file system yes. In most cases that means a hard drive. The repository database stores just about everything that's needed to make Qlik Sense Enterprise run: configuration, users, authorizations, tasks etc. It does not store the app files or the qvd files the apps generate.

Re: Qlik Sense QVD

ch_riadh — Tue, 17 May 2016 12:07:31 GMT

Thank you for your help

Re: Qlik Sense QVD

hozefa413 — Tue, 02 Apr 2019 05:17:01 GMT

The repository database stores system and app meta data, while the file share stores binary application data such as, data models and app content.