Creating a QlikView Recovery Load

Hi,

Recently I created a series of videos on Qlik User Interface (UI) design techniques and I was really pleased with the positive response I got from everyone here and on the Qlik Community.

Carrying on the same idea I’m putting together a series of videos focusing on loading data into QlikView and will include various techniques I’ve developed and seen others use other the years.

 

This video continues with the series and shows how the script is modified to create a recovery load, the next video in the series shows how the same script is then finalised into an incremental load.

 

https://www.youtube.com/watch?v=n5k51d33f1U

 

 

QlikView Data Extraction Process

QlikView Data Extraction Process

 

 

 

 

 

2 responses to “Creating a QlikView Recovery Load

  1. I have really enjoyed your youTube channel so far, it has opened my mind to new possibilities. I am currently working on alternative data loads, validation of data, and recovery process improvements. Hopefully you can assist in my question below.

    In your example you have one file extracting data into several QVD files. Do you have any insight into a recovery process that has multiple data files (20+ files) being extracted into several QVD files?

    Like

    • Hi Chris. Thanks for your nice words.

      I often build in a recovery process. That is by changing the start and end dates on the reload.

      In one company I worked for I created one qvw, that looked at several sources and extracted the data into multiple qvd files.

      I used publisher to send a variable to the qvw to tell it what to do, is daily loads, weekly loads, recovery, etc.

      The one file went to a control table which it looped through. Much in the same way as we loop though dates here. The file held data on what to connect to and where to put it. That way the same qvw can complete many takes. My loads then where simple * loads as they were views I’d set up in the database although I could have held a string of fields in a variable taken from the control sheet if I wished.

      I hope this helps.
      Rich

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s