Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ryanfoster84
Creator
Creator

Reloading an App using a datamodel stored on another server

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

1 Solution

Accepted Solutions
prat1507
Specialist
Specialist

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

View solution in original post

5 Replies
prat1507
Specialist
Specialist

HI

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

ryanfoster84
Creator
Creator
Author

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

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

but doesn't work

techvarun
Specialist II
Specialist II

You cannot binary load a Qvd File

The script should be

LOAD * From

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

techvarun
Specialist II
Specialist II

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.


prat1507
Specialist
Specialist

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