Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

nikhilgarg
Contributor III

WHy QVSource Service is used ??

WHy QVSource Service is used ??

11 Replies
Not applicable

Re: WHy QVSource Service is used ??

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

nikhilgarg
Contributor III

Re: WHy QVSource Service is used ??

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 ??

Not applicable

Re: WHy QVSource Service is used ??

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

nikhilgarg
Contributor III

Re: WHy QVSource Service is used ??

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

Not applicable

Re: WHy QVSource Service is used ??

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

nikhilgarg
Contributor III

Re: WHy QVSource Service is used ??

Hey thanx mathew.

Can you also tell me :

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

Please help.

Thanx

Not applicable

Re: WHy QVSource Service is used ??

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

Employee
Employee

Re: WHy QVSource Service is used ??

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

nikhilgarg
Contributor III

Re: WHy QVSource Service is used ??

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

Community Browser