topic Re: Reloading an App using a datamodel stored on another server in QlikView

Reloading an App using a datamodel stored on another server

ryanfoster84 — Fri, 03 Nov 2017 10:54:35 GMT

Hi,

Looking some help we have configured out new environment and have the following set up:

Server 1

Qlikview Server

Qlikview Web Server

Qlikview Directory Service Connector

Server 2

Qlikview Distribution Server

Qlikview QMC

So we will have our apps on server 1 and on server two will have the qvds,extract scripts and data models.

Currently our applications have the following line of code to reload from the datamodels that are all sorted on the same server:

Binary [..\datamodels\Market_Liquidity_Datamodel.qvw];

So does anyone know the correct syntax to use so it knows to go to server 2? the directory is the following:

smd1prtbqlk0004\D:\Qlikview\Datamodels\dvt_datamodel.qvw

Re: Reloading an App using a datamodel stored on another server

prat1507 — Fri, 03 Nov 2017 11:08:38 GMT

Please create a sharing network path for the folder where you're storing all your QVDs. Check if you can access the sharing path on the other server and then you can provide your access.

Binary [ShareFolder\*.qvd]

Regards
Pratyush

Re: Reloading an App using a datamodel stored on another server

ryanfoster84 — Fri, 03 Nov 2017 11:34:08 GMT

I made the folder shared on the other server and used this:

Binary [\\SMD1PRTBQLK0004\Datamodels\*.qvd];

but doesn't work

Re: Reloading an App using a datamodel stored on another server

techvarun — Fri, 03 Nov 2017 11:38:54 GMT

You cannot binary load a Qvd File

The script should be



LOAD * From
[\\SMD1PRTBQLK0004\Datamodels\*.qvd] (qvd);

Re: Reloading an App using a datamodel stored on another server

techvarun — Fri, 03 Nov 2017 11:43:03 GMT

If you still want to load Binary Load

Create a Application_Backend.QVW File in \\SMD1PRTBQLK0004\Datamodels folder

Load all the Qvd files into Application_Backend.QVW File

Save the the file and do Binary load like below

Binary [\\SMD1PRTBQLK0004\Datamodels\Application_Backend.QVW];

Only one binary load allowed per qvw.

Re: Reloading an App using a datamodel stored on another server

prat1507 — Fri, 03 Nov 2017 11:43:46 GMT

Sorry to have missed out on this, you can't load QVDs using this

Please use something like this:

BINARY [\\SharingFolder\dvt_datamodel.qvw];

Regards

Pratyush