Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Rights to remotely refresh QlikView files

I have a .Net application that remotely runs a QVD generator and refreshes 2 QlikView files.  It runs fine, but only if the user running it is in the Local Server Admins group on our QlikView Server.  Is there a way / a command line parameter I can use so that a user does not need to be in this group?

8 Replies
vivientexier
Contributor II

Re: Rights to remotely refresh QlikView files

He needs to be in QlikView administrator, if not it is not allowed.

Not applicable

Re: Rights to remotely refresh QlikView files

Is this the only way?  The purpose of this application is to give a select group of users the ability to refresh certain QVD generators and QlikView files ahead of the standard schedule we have already implemented.  This group of people may run this once a week / month, whatever, but it more than likely will not be a frequent happening.  I would be very apprehensive to make these people administrators and thus opening them up to being able to do anything within QlikView just for the ability to run this one application.

mov
Esteemed Contributor III

Re: Rights to remotely refresh QlikView files

Robert,

You can use EDX reload.  In this case your users should be members of the "QlikView EDX" group, no need to give them admin level.

Regards,

Michael

Employee
Employee

Re: Rights to remotely refresh QlikView files

If you put the QVW on a QV Server you can make the users Document Administrators.  They would then have the ability to kick off a reload job but not access other areas of the QMC.

Note I'm assuming you can put the QVW on a QV Server.

sterligov
New Contributor II

Re: Rights to remotely refresh QlikView files

HI

I would have done: created QVW file it describes the required data load and store the result in a QVD. QVW published on the server and set up the auto-update. That's all, do not give anyone access - the system will update all on schedule

Not applicable

Re: Rights to remotely refresh QlikView files

We have the QlikView files and QVD Generators running on set schedules.  However when certain departments update Excel files used in the Generators they want to be able to see the new data without having to wait until the next scheduled refresh, thus my current situation.

Not applicable

Re: Rights to remotely refresh QlikView files

I've not used this before.  From my initial research on this it appears as though I would go into the QlikView server and select the particular elements to refresh based off of external tasks.  Would this create an issue if these same elements are set up to run at scheduled times?  We want the ability for both, to be refreshed as per our desired schedule, as well as 'manually' refreshed if say a person updates one of the Excel files that is used for a QVD.

The application I have written to perform this task is written in VB .Net 2010, a Windows Form app.  As I mentioned, it runs fine if the user running it is a QlikView Admin (for security reasons the route of putting anyone who may run this as QlikView Admin is not an option).  I briefly saw an article making reference to the QlikView API and using a web service.  Would this sound like the correct approach to setting my app up as an EDX?

dvasseur
Contributor II

Re: Rights to remotely refresh QlikView files

Il you have Publisher you can create two tasks: one scheduled and another one triggered by external event (EDX). Without Publisher, you can't have both (well, you can cheat and schedule the task using for example Windows tasks service and so always use EDX ;-)).

Indeed you can use the Qlikview API with a web service. This way, only the account used by the web service needs to be a Qlikview Admin (Qlikview EDX group would be enough BTW). But you have to somehow "secure" the call to this web service, for example to launch only one specific task.

Community Browser