How to read QVD stored on windows share?

[mountaindude]

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. Z:).

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?

[mountaindude]

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

[Giuseppe_Novello]

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

[mountaindude]

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

[Giuseppe_Novello]

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

[mountaindude]

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

Very strange.

[#7]

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

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

[pbr]

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.

[Michael_Tarallo · Accepted solution]

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

[mountaindude]

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.