topic Re: Loading date from remote database in QlikView

Loading date from remote database

Mon, 26 Jan 2026 18:19:17 GMT

Hi all!

I have the QV Small Business server on premise in the USA.

I need to pull data from other databases that reside in other countries.

I can ODBC connect into their servers but the data pulls too slowly. It takes me 4.5 hours to pull this one table but they can pull this same table in 3 minutes.

What is the best solution where I can schedule to run their data from my local QV Small Business server but the load is actually executed on their side, and then the final QVW gets updated on my local QV server for publishing?

Thanks!

Re: Loading date from remote database

alexandros17 — Thu, 18 Dec 2014 16:42:57 GMT

... you could install qlik on the remote db server, extract data and store it in a qvd then (via FTP?) obtain the qvd and load it in your document ....

only an idea ...

Re: Loading date from remote database

Gysbert_Wassenaar — Thu, 18 Dec 2014 16:43:40 GMT

Have the remote sites load the data from the ODBC source and store the tables in qvd files. Then on your end load the qvd files.

Re: Loading date from remote database

jjordaan — Thu, 18 Dec 2014 17:03:43 GMT

Do you try to load / fetch the whole table?

And are you fetching incremently?

A lot of customers where I work for have stores in different countries and all that data I load through remote connection. But I only need a few columns per table nad where it is possible I perform an incremental load.

Re: Loading date from remote database

rajeshvaswani77 — Thu, 18 Dec 2014 17:09:24 GMT

Hi Mark,

You can store it as CSV and set up FTP's to consolidate them to a single location, then read from QV.

thanks,

Rajesh Vaswani

Re: Loading date from remote database

Thu, 18 Dec 2014 17:21:56 GMT

These are all good suggestions for getting the data to my server. But is there a way I can schedule their QVW generator to load from my QV SB server? Or are they stuck manually reloading their own QVDs?

Re: Loading date from remote database

Thu, 18 Dec 2014 17:22:50 GMT

Yes, I can incrementally load but that is still to slow, I was looking for other options if this process was still to slow.

Re: Loading date from remote database

jjordaan — Thu, 18 Dec 2014 17:24:56 GMT

You can use batch file and schedule that batch in the Windows Schedular

Re: Loading date from remote database

Thu, 18 Dec 2014 18:25:18 GMT

Thanks everyone. I'll have the countries create a csv file (so they will be doing the full and incremental loads themselves via SSIS) of the data and store the data in a shared folder sitting on my QV server.