topic Re: How to read QVD stored on windows share? in Connectivity & Data Prep

How to read QVD stored on windows share?

mountaindude — Fri, 19 Sep 2014 15:15:00 GMT

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?

Re: How to read QVD stored on windows share?

mountaindude — Fri, 19 Sep 2014 15:23:20 GMT

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

Re: How to read QVD stored on windows share?

Giuseppe_Novello — Fri, 19 Sep 2014 15:36:45 GMT

Goran,

Check the following link that might help you:

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

Look the videos on data loading:

Sense Videos

Re: How to read QVD stored on windows share?

mountaindude — Fri, 19 Sep 2014 15:39:24 GMT

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

Re: How to read QVD stored on windows share?

Giuseppe_Novello — Fri, 19 Sep 2014 15:51:29 GMT

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/FolderDataConnection.htm?…

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

Gio

Re: How to read QVD stored on windows share?

mountaindude — Fri, 19 Sep 2014 16:16:54 GMT

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

Very strange.

Re: How to read QVD stored on windows share?

Fri, 19 Sep 2014 16:27:54 GMT

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

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

Re: How to read QVD stored on windows share?

pbr — Fri, 19 Sep 2014 17:05:23 GMT

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.

Re: How to read QVD stored on windows share?

Michael_Tarallo — Fri, 19 Sep 2014 18:07:09 GMT

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

Re: How to read QVD stored on windows share?

mountaindude — Thu, 06 Nov 2014 05:18:55 GMT

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.

Re: How to read QVD stored on windows share?

jrdunson — Mon, 06 Jun 2016 12:19:18 GMT

Late comment: these URLs are obsolete

Re: How to read QVD stored on windows share?

jrdunson — Mon, 06 Jun 2016 12:19:56 GMT

This URL is obsolete

Re: How to read QVD stored on windows share?

jrdunson — Mon, 06 Jun 2016 12:27:56 GMT

Hey all, I know this was discussed Sept 2014, but can Qlik Sense pull from a qvd...stored on another machine?

I have tried using the server address, suggested by Reuniones de Gerentes Manar above,

Load * from \\xxx.xx.xx.xx\Path\file.qvd (qvd);

But this does not work. I am using Qlik Sense Desktop... is this a limit and/or an intentional license issue? That is, can Qlik Sense pull data from other drives... other than 'Lib:\\' locations?

Any suggestions?

Re: How to read QVD stored on windows share?

VishalSingh18 — Wed, 23 Oct 2019 08:34:24 GMT

Same problem but the thing is the file shared by my client how do I connect to that remote location Data source to read the QVD

silly question but I am totally new to Qlik