Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Luminary
Luminary

How to read QVD stored on windows share?

There has to be a really simple answer to this... but I just cannot get it to work.

- I create a QVD on server A, and store it in a folder that is shared as a standard, hidden Windows share.

- I then want to access (read) that QVD from server B.

I have tried mapping the share on server B, making available as a local drive (e.g. ZSmiley Happy.

The error message given by Sense 1.0 is "LOAD statement only works with lib:// paths in this script mode", which doesn't really tell me much. Nothing to be found in Sense help (at least I haven't found anything).

I've tried using a UNC path in the load statement on server B, i.e. Load <fields> from \\server\share\directory\file.qvd

No luck.

What's a lib:// path in this context?

Any pointers to how this should be done in Sense?

1 Solution

Accepted Solutions
Employee
Employee

Re: How to read QVD stored on windows share?

Goran - just a note - if you are using the Qlik Sense Platform - and not Qlik Sense Desktop - you need to make sure that the user account that is running the Qlik Sense services - has access to the network share.

I cover that in this video here:

Qlik Sense Platform - Create Your First App - Part 2 - Creating Data Connections

Let us know how you do

Mike

Regards,
Mike Tarallo
Qlik
12 Replies
Luminary
Luminary

Re: How to read QVD stored on windows share?

Found it - sort of

Seems the data connector cannot use mapped drives (Z: in this example) or UNC paths to folders.

By design or a bug - not sure.

Kind of limiting not being able to read files from other servers though..

Employee
Employee

Re: How to read QVD stored on windows share?

Goran,


Check the following link that might help you:

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/LoadData/Conne...New to Qlik

Look the videos on data loading:

Sense Videos

Giuseppe Novello
Qlik's Principal Technical Support Engineer
Luminary
Luminary

Re: How to read QVD stored on windows share?

Yup, those are the instructions I have followed.

UNC paths are supposed to work, but it seems they don't.

Have tried setting up new shares on server A, with fully open access rights, Sense still cannot map them

Employee
Employee

Re: How to read QVD stored on windows share?

Goran,

Okay I just tested and it works, here is to create the path but it seems UNC would work better:https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/LoadData/Folde...

the loading a QVD file:https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/LoadData/Selec...

Gio

Giuseppe Novello
Qlik's Principal Technical Support Engineer
Luminary
Luminary

Re: How to read QVD stored on windows share?

Strange... UNC paths isn't really anything new, used them countless times... so why aren't these working?

Very strange.

Not applicable

Re: How to read QVD stored on windows share?

Type the server address and not the server name, in the UNC

Ex: \\19x.xxx.xxx.xxx\share\file.qvd

Employee
Employee

Re: How to read QVD stored on windows share?

What does the script look like? There might be something else that isn't allowing it?

You can see the QVDs in the Data Connections on the right if you hit the icon next to the pencil (with the check mark)?

I tested on a mapped drive to another server and was fine pulling in a QVD.

Employee
Employee

Re: How to read QVD stored on windows share?

Goran - just a note - if you are using the Qlik Sense Platform - and not Qlik Sense Desktop - you need to make sure that the user account that is running the Qlik Sense services - has access to the network share.

I cover that in this video here:

Qlik Sense Platform - Create Your First App - Part 2 - Creating Data Connections

Let us know how you do

Mike

Regards,
Mike Tarallo
Qlik
Luminary
Luminary

Re: How to read QVD stored on windows share?

Fwiw, here's a late, late reply... This was resolved the same day the previous posts were written, lost in inbox since..

Yup, that was it. I was totally sure I had given the Qlik Sense server user rights to the windows share in question, but I guess I must have missed pressing the Apply button... Once I did everything worked as it should, of course.

Community Browser