topic WHy QVSource Service is used ?? in Qlik Learning Discussions

WHy QVSource Service is used ??

nikhilgarg — Mon, 01 Sep 2014 10:46:17 GMT

WHy QVSource Service is used ??

Re: WHy QVSource Service is used ??

Tue, 02 Sep 2014 14:45:27 GMT

Hi Nikhil

QVSource needs to be running at the time the QlikView script is reloaded. This is normally not a problem when you are developing the QlikView app but when it is moved to a QlikView server it won't. The QVSource service will run in the background on the server and so will always be available when QlikView Server reloads an application.

Regards

Matt

Re: WHy QVSource Service is used ??

nikhilgarg — Wed, 03 Sep 2014 04:56:58 GMT

HEy MAtthew.

So you want to say that if i am not using Qlikview Server and Publisher. If i am using only Qlikview Desktop and QVSource , then in that case when i manually reload from qlikview application then QV source will run.

But,

If i moved my application to Qlikview Server and now if i manually reload my qlikview application then now QV Source will not run rather "QVSourceService" is run to execute the Qlikview Script. IS it so ??

Re: WHy QVSource Service is used ??

Wed, 03 Sep 2014 07:45:28 GMT

Hey Nikhil

Kind of, when using QlikView Desktop then you just need to remember to start QVSource before you reload any applications that make use of data from it.

On a QV Server you would install the service and then there is no need to run QVSource, the service takes care of all the requests instead.

Regards

Matt

Re: WHy QVSource Service is used ??

nikhilgarg — Wed, 03 Sep 2014 07:49:00 GMT

THanx but i need to run QVSource atleast for authenticating and ol. For updating i need QVSource Service. Right

Re: WHy QVSource Service is used ??

Wed, 03 Sep 2014 09:04:47 GMT

Yes, even with the service installed you still run QVSource in order to configure it.

Re: WHy QVSource Service is used ??

nikhilgarg — Wed, 03 Sep 2014 09:11:37 GMT

Hey thanx mathew.

Can you also tell me :

WHat is QVD??? HOw they are produced ?? How they are loaded in QLikview ??

Please help.

Thanx

Re: WHy QVSource Service is used ??

Wed, 03 Sep 2014 09:14:24 GMT

Give this a read. It covers everything you asked... http://www.quickintelligence.co.uk/qlikview-qvd-files/

Re: WHy QVSource Service is used ??

Agis-Kalogiannis — Wed, 03 Sep 2014 10:24:28 GMT

Hi Nikhil

A QVD file is a QlikView native file format and can be created and read only by qlikview.

It contains only ONE table per file in a very compressed and optimized way.

We use QVD files mainly for two reasons:

1. Their speed

2. Reduce workload on the actual databases

In order to create a qvd file, we need to load our table and use the STORE command to create the file:

STORE TableName INTO FIlename.qvd

We can load them in Qlikview in exactly the same way as any other table file, by clicking on the Table Files button in our script editor.

Agis

Re: WHy QVSource Service is used ??

nikhilgarg — Wed, 03 Sep 2014 10:52:48 GMT

THanx a lot but does publisher also used to load these qvd into qlikview ??

Re: WHy QVSource Service is used ??

Agis-Kalogiannis — Wed, 03 Sep 2014 11:11:45 GMT

No nikhil.

It's the script's job to load the qvd files, exactly the same way as any other datasource. So the script will import any data included into the QVD file during a reload.

The publisher, among other things, can just execute these scheduled reloads.

Re: WHy QVSource Service is used ??

Agis-Kalogiannis — Wed, 03 Sep 2014 11:30:16 GMT

Yeap... this one will help indeed!!!

Nice one Matthew!