Local reload of qvd files

[#1]

Hi,

We have a QlikView Server installation where the data sources are globally spread with databases (Oracle) in Sweden, Singapore and the U.S. The QlikView server installation is located in Sweden.

The database content is generally loaded into qvd files, which are then used to load the user applications. The problem that we are experiencing is that is is taking a long time to update the qvd files (from the Singapore and US databases), even when using incremental load. My question is: is there any way to load the qvd files locally (on or close to the database servers) and then transfer the qvd files to Sweden using FTP or similar? Would that require additional full QV Server installations, or is there another way to accomplish it? I would prefer not to spend the license money it would take to set up parallel full QV server installations.

Thanks for any help,

Magnus

[jerrysvensson · Accepted solution]

Yes it should be possible. Create your app locally using a Personal Edition Developer, load your data and use FTP or just a shared disk and copy. I have tried it a customer site.

[#3]

Great! I guess you just use the Scheduled Tasks in Windows to schedule the reloads locally?

[jerrysvensson]

Yes. What you will miss though is status on the reload, if it fails you will never know. I suggest that you implement some errorhandling.