topic Is it possible to refresh qvd's daily in QlikView

Is it possible to refresh qvd's daily

Thu, 29 Aug 2013 13:02:36 GMT

Hi,

Is it possible to refresh qvd's daily , with out connecting to DB every time and reloading ?

Actually now i am reloading qvd generator daily ..instead of reloading every time is there any way to refresh qvd's with respect to changes in ETL automatically ..

Can any one please let me know is that possible ?

Below is one of the solution but please let me know how to achieve it ,

To reflect ETL changes or refresh the qvds you need to reload the qvd generator.

Now, instead of manual reload you can have the QVD generator reload scheduled for a particular time (may be after ETL changes are over in DB side). This way you will not have to worry about the manually reloading the file (qvd generator) and the data will get refreshed automatically. Moreover the file will connect to DB only while pulling the data during reload and not all the time.

Thanks & Regards,

Re: Is it possible to refresh qvd's daily

Miguel_Angel_Baeyens — Thu, 29 Aug 2013 13:24:45 GMT

Hi,

Indeed, you can store historic data into QVD files and reload from the DB only when there is new data, so you always have the most update information along with the historic information in your QlikView file. This kind of incremental reload is done like this:

Data:
LOAD *; // this loads data only from today
SQL SELECT *
FROM Customers
WHERE Date = Today(); // or whatever the syntax is for today in your RDBM
CONCATENATE LOAD *
FROM Customers.qvd (qvd); // this file already exists and stores all data loaded previously

// This stores new data along with historic in the same file, for the next day reload
STORE Data INTO Customers.qvd (qvd);

Hope that helps.

Miguel

Re: Is it possible to refresh qvd's daily

rajeshvaswani77 — Thu, 29 Aug 2013 13:25:17 GMT

Hi Sh,

Firstly I suppose that you are using a Incremetal load. The incremental load would normally take a couple of second or minutes to refresh the data in the QVDs. Since only the changed data will be appended.

Secondly you must have scheduled a publisher job that will automatically connect and refresh from the database at the scheduled time, and I suppose that you know a guarenteed time when the ETL job would have completed.

Lastly I am aware that there can be a flag set to check if the ETL job is ready and completed, a very high level check, this will be one more step in your refresh job on success of which the actual refresh happens. This is somethign I know that it can be done. Do not have it right away at the momnent. However you could think on these lines and the community can add to this as well.

thanks,

Rajesh Vaswani