Create a custom Qlikview page on Qlikview server to reload applications

[nstefaniuk]

Hello,

I am not fond of all the existing solutions allowing user reload through server:

- I don't like to trigger a .exe or a .bat or a command line on user's side through my web application

- I don't like to have a macro that launches a web service in http with clear credentials (so unsecured)

- I don't like to grant admin access to users on Qlikview Management Console because I can't reduce their rights to just refresh 1 application

- I don't know any other solution, for example an action in application that triggers an action server-side through Qlikview own protocol, using existing user authentication.

So, according to the fact that there is no secure way to authorize an user's refresh, I would prefer to have a public, unsecurized, link which launch the refresh. So anyone could refresh the application... and so what? Where is the risk? A group of dangerous berserks link-hitters who chain-refresh the application? Far better than having credentials in clear in network.

So does anyone knows how to develop my own page, without any security (maybe it could be possible to add security later), hosted and executed by Qlikview server or Qlikview Webserver, that will launch command on server side.

A workaround could be creating a really simple application on an IIS on Qlikview server that do this part, but I would like to use the Qlikview server.

Thanks a lot.

[marcus_sommer]

Maybe this is helpful: http://community.qlik.com/search.jspa?q=EDX&type=document

- Marcus

[nstefaniuk]

Unfortunately not enough. I mean : I have already done this kind of research and I didn't find what I was looking for. EDX is meanly designed to allow external programs and ETL to run tasks.

The closest thing I have found is this CallEdxFromAjax extension and especially its server side page: QlikView Extension - Call EDX Tasks from Ajax-/Web-Client - Home

My requirements (which are in fact more "production team's requirements) could be summarized as:

- allow admins choosing which applications can be reloaded by users

- allow any user to run a "user-allowed task"

- Don't execute anything on client's side, at least no .exe and no .bat and no command line. Macro in Qlikview application are allowed as a workaround.

- Don't expose any credential (of user or of a service account on Qlikview server)

Can this be achieved with EDX ? As far as I know, it's not possible, but maybe it's possible with an ajax extension, a specific settings, a task without password and no credential given in the call.

Thanks

[marcus_sommer · Accepted solution]

Maybe you could use these extensions to trigger your reloads with your requirements:

http://community.qlik.com/docs/DOC-5970

http://community.qlik.com/docs/DOC-3615

- Marcus

[nstefaniuk]

Touché !

The 2nd link is what I was searching for, thanks a lot.