Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qliksense: Load Data Into QVD

I am currently using the Qliksense platform and not Qliksense Desktop.

I am new to this tool and attempting to load date from our MSSQL database to QVD, however I do not understand why I cannot store it into a Directory or Lib? What is the Lib path. There seems to be a lack of documentation and I cannot seem to find a way to load this data.

Also what would be the best approach. Would I have one app just dedicated to loading all data? i.E if I wanted to perform data refresh nightly?

Here is my current script:

DailyInventory:

LOAD

InventoryKey,

OwnedQty,

Warehouse,

WarehouseKey,

Date;

SQL SELECT

InventoryKey,

OwnedQty,

Warehouse,

WarehouseKey,

Date

FROM RentalworksDW.dbo.DailyInventoryStatus;

STORE DailyInventory INTO [lib://QlikSenseQVDFiles\DailyInventory.qvd](QVD);

What is this lib:\\path?

I tried C:\QlikSenseQVDFiles\DailyInventory.qvd](QVD) that did not seem to work either.

1 Solution

Accepted Solutions
reddy-s
Master II
Master II

Hi A Sma,

The mistake you are making here is you are not providing the entire library connection name.

it has to be 'lib://QlikQVDs(xxxxxxxx)/warehouse.qvd'

You user name is default suffixed to the connection you create. Hence you need to add that as well. If you want to get rid of the suffix, you need to do it from QMC->Connections.

Thanks,

Sangram.

View solution in original post

9 Replies
Not applicable
Author

The "folder" name that appears after the lib:// is the name of your "connection".  Look on the right side of your screen in the area labeled "Connections".  You can add a connection that defines the path to your desired folder. Remember, the path must be accessible by the Qlik server. Create a connection named QlikSenseQVDFiles. Configure with the path to your file folder. Then in the load script place the connection name after lib://

Example:  Store DailyInventory into [lib://QlikSenseQVDFiles/DailyInventory.qvd](qvd);

Not applicable
Author

To answer "Also what would be the best approach. Would I have one app just dedicated to loading all data? i.E if I wanted to perform data refresh nightly?"  You can have one app that loads the data from the MSSQL database and then stores the data as a QVD file. Set this app up for a daily refresh in QMC Tasks.  Then, other apps can load the saved QVD file. You would also set up QMC Tasks to load the saved data(QVD) for each of those apps.

reddy-s
Master II
Master II

Hi Asma,

The [LIB:\\<Connection Name>\...] refers to the connection you created in the connections pane. Its basically like an alias to the entire file path.

So the store command creates a QVD file and stores it to the location you have created in the data Connections.

Thanks,

Sangram.

Not applicable
Author

Hi Sangram. Thanks for the detailed explanation. I tried creating the connection folder. And then tried to store data into it and I get the following error. I am not entirely sure why. Are there any other permissions that may be missing? Please take a look at the screenshot below. Screen Shot 2016-02-07 at 10.33.57 PM.png

reddy-s
Master II
Master II

Hi A Sma,

The mistake you are making here is you are not providing the entire library connection name.

it has to be 'lib://QlikQVDs(xxxxxxxx)/warehouse.qvd'

You user name is default suffixed to the connection you create. Hence you need to add that as well. If you want to get rid of the suffix, you need to do it from QMC->Connections.

Thanks,

Sangram.

undergrinder
Specialist II
Specialist II

Hi ASma,

I guess it's caused due to he connection name.

Your connection name is not only "QlikQVD" , but "QlikQVD (username)".

You can change the connection name in QMC, or try insert a table through this connection, and observe what connection string will be inserted in the script.

G.

Not applicable
Author

Thank you This worked.

oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer. If not, please make clear what part of your question you still need help with.

May you live in interesting times!
reddy-s
Master II
Master II

Always Welcome!