How to query qlikview via a RESTFUL API

[#1]

Hi

I have been contracted to a company that is using qlik-view to aggregate their data. I have an external system that needs to be able to query the data stored in qlik-view so therefor:

1. Is this possible?

2. If this is possible is there either a REST or SOAP connector.

Thank you

[jerrysvensson]

Download QlikRESTConnector. It is free and will probably have everything you need.

Search forum for download link.

[#3]

Thanks for replying @Jerry Svensson. Apologies if I sound silly for checking, I have never used qlik view before. QlikRESTConnector is only for qlik sense according to QlikRESTConnector install page.

I asked the guy who deals with it here and he said we only have qlik view and not qlik sense and after some of my own research it appears qlik view can only post data.

I want to create an endpoint in qlikview that I can hit.

For example qlikview contains aggregated client data from multiple systems and in qlikview we have created this aggregated client entity.

I want an endpoint like qlikview/client that when hit should return this client object to the calling web service.

[Joaquin_Lazaro]

Hello DH

If I understand you right, you want to read QlikView data using other software, well I think this is no available software for doing it,

But I will follow this post because it's a interesting question

Regards

Joaquín

[jerrysvensson]

Ah, my bad. Read it the other way..

You could store the data as qvd files using textformat. If that solves your problem.

[#6]

Hi Jerry, thanks for following up, so we discussed that option and just for the start of integration we are going to have qlikview produce a csv which our system will consume.

We are not so happy with this option and we were hoping that there was some way for our system to access the qlikview data store directly. Either through opening the end point as I have suggested above or some other mechanism.

Just a note, this is an investigation to see if this is possible with qlik view. But we do need to report our finding by tomorrow.

Thank you for the help

[#7]

Hi  joaquinlr

Yes you are right, qlik view basically contains all the data our external system needs and we want to read directly from it.

Thanks for your input

[Joaquin_Lazaro]

Hi DH:

There are two products QlikView OCX and QlikView Workbench for using your data and charts in your company web or business software ... but you must buy both of them.

Joaquín

[Anil_Babu_Samineni]

DH,

Before moving please confirm me.

1) Yes, It's possible

2) Might be you are new to QlikView - So, How do you contact to another company to get the data. Is there any key to release the BRD.

3) If Yes, Let me know what they are thoughts.

- Anil

[#10]

Hi Joaquín

Do you mean that QlikView OCX and QlikView Workbench can be used to extract the data?

Just to give some more info I am a software dev. So with a team we are creating a new front and back end system for the client. We are writing the backend in C#. Reading through the workbench docs it looks like you have to add qlik view components on your web site.

This indicates to me that there is a .dll  which contains code that has the ability to query qlik view for data. Basically I would just like  to access those functions without having to include a qlik view component on my site.

We are creating custom site and therefor will manipulating the data and displaying it on the website with our custom components and graphs.

Please if anything I have said is unclear I will explain further .