topic Save previous reload without using QVDs in QlikView

Save previous reload without using QVDs

ali_hijazi — Wed, 02 May 2012 13:34:40 GMT

Dear

I got a QVW document

the reload is successful and now I got a schema with 2 tables table1 and table2

on the next reload I want to check if there exists rows in table1 and table2

it seems that reload will start from scratch;

is there a way to keep previously loaded tables for the next reload without using QVDs?

Save previous reload without using QVDs

jonathandienst — Wed, 02 May 2012 14:44:44 GMT

If you don't want to save and reload from QVD's then your best option could be to use a binary load.

But why not save the data into QVD's - they are fast, compact and simple?

Regards

Jonathan

Save previous reload without using QVDs

ali_hijazi — Wed, 02 May 2012 14:58:05 GMT

Because qvds will contain sensitive data

and I don't want the QlikView server administrator to see this data

for he can download qlikview client for free and read data from the qvds

I'm actually saving the data in a qvw with section access then the qvw that will contain charts binary loads from that qvw

Save previous reload without using QVDs

Wed, 02 May 2012 20:15:01 GMT

Another option is to perform a partial load. The existing tables will not be dropped during the reload but you will need to modify your load scripts to use ADD or REPLACE in your load statements.

Save previous reload without using QVDs

danielrozental — Wed, 02 May 2012 22:29:04 GMT

Why are you trying to reinvent the wheel? Use QVDs, make sure all loads are optimized so the reload time is minimal.

Re: Save previous reload without using QVDs

jonathandienst — Thu, 03 May 2012 10:28:26 GMT

My suggestion would then be to give the responsibility of the reloads to a user account that can be given access to the sensitive data (eg a trusted user or a service account under the control of a trusted user), and store the data in a QVD that is saved to a folder properly secured using AD access control so that only the trusted account can read the QVDs.

Regards

Jonathan