topic Re: Reload data from source automatically in QlikView

Reload data from source automatically

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I'm a total newbie to deployment, and i need help reloading from source?

Thanks

Re: Reload data from source automatically

sujeetsingh — Tue, 11 Dec 2012 07:05:24 GMT

Just create atask and shedule it to a required time of reloade and duration...

Re: Reload data from source automatically

Anonymous — Tue, 11 Dec 2012 07:07:27 GMT

Thanks for the quick response, but how do i link it to the data source now that the decument is on the server?

Re: Reload data from source automatically

sujeetsingh — Tue, 11 Dec 2012 07:11:53 GMT

In server there are setings for all datasourses...and yes the cinnetion string will do it...

Re: Reload data from source automatically

Peter_Cammaert — Tue, 11 Dec 2012 10:43:46 GMT

On the server, you have to recreate all connections to the data sources you are loading from. Just like the original model designer did in the QV Desktop. For instance:

OLEDB: install the driver for your RDBMS on the server, and make sure the DB server can be reached. The connection string will do the rest.
ODBC: use WIndows ODBC manager to create the necessary DSNs that you use in your script. This requires a bigger effort if you're not into that sort of thing.
Excel and other table files: make sure that those files can be reached via the path specifications in your LOAD statements. Drive letters may get you a few surprises here.

Pay attention to authorizations: the QVS is running under another account than the designer of the document. Possibly this account is not authorized to access network, DBs or other required sources. I would suggest to ask a system administrator for help.

Best,

Peter

Re: Reload data from source automatically

Peter_Cammaert — Tue, 11 Dec 2012 14:35:56 GMT

Ooops, the last few exchanges in this thread have disappeared. I'll post again if you need further clarification.

Peter

Re: Reload data from source automatically

Anonymous — Tue, 11 Dec 2012 14:58:32 GMT

Sorry about that, i would really appreciate further clarification.

Thanks

Re: Reload data from source automatically

Peter_Cammaert — Tue, 11 Dec 2012 15:33:31 GMT

Well, you asked me where in the QMC you can manage your data source connections. There is no such place. You'll have to configure your server envrionment so that it corresponds to the data source specs inside the load script. The 3 tasks in my previous reply are to be executed in the Windows environment. For example, if you specify in your script something like

LOAD A, B, C FROM N:\data\Transactions.xls (...);

then before publishing this model on your server you'll have to make sure that the service account that runs QVS/QVP on the server knows about drive N:, can access the network and has permissions to open the Excel file.

When reloading, QVS/QMC/QVP cannot change anything that is hardcoded in your script (except by passing values in variables). So you either adapt your load script so that it changes data access methods when running in a different environment (for example by way of an $(Include) that insert platform-specific data access parameters) or you change your server environment so that is replicates the data source availability of your development environment.

Best,

Peter

Re: Reload data from source automatically

Anonymous — Tue, 11 Dec 2012 15:48:23 GMT

So then I have to move the data source unto the server and change the directory in the scripts, right? suppose they are excels in a folder.

Re: Reload data from source automatically

Peter_Cammaert — Tue, 11 Dec 2012 15:56:34 GMT

Not necessarily.

If the folder containing your excels is shared - on a file server for example - you can leave them where they are. Grant the service account access to this shared folder and QVS can access it like you do in your development environment.

If the Excels reside on your own development PC, then you better move them to a file server.

LOAD statements should contain paths to data sources that work on all platforms, like \\Fileserver\data\Transactions.xls. If you move your QlikView document to the server, no script changes are needed.

Best,

Peter

Re: Reload data from source automatically

Anonymous — Tue, 11 Dec 2012 17:17:38 GMT

Exactly and now when i do a schedule reload in QMC, it should work just fine right?

Re: Reload data from source automatically

Peter_Cammaert — Tue, 11 Dec 2012 23:36:45 GMT

That's our goal, yes.

Of course, it all depends on your actual situation. However, the general idea stays the same.

Goo luck,

Peter

Re: Reload data from source automatically

Anonymous — Wed, 12 Dec 2012 05:46:14 GMT

Great!, Thank you Peter once again