topic Re: Is it a bad idea to use Qlik Sense API? in Integration, Extension & APIs

Is it a bad idea to use Qlik Sense API?

mananshah — Wed, 22 Jun 2022 19:41:51 GMT

My organisation is planning to use data from Qlik Sense in other applications.

Is it a good idea to develop api that connects directly to Qlik engine using #enigmaJs or is there a better solution

In general is using qlik as a repo a good practice?

Re: Is it a bad idea to use Qlik Sense API?

rwunderlich — Wed, 22 Jun 2022 20:00:09 GMT

If your goal is to reuse the Qlik data tables, a simple and clean method to do this is use the script STORE statement to write the tables as CSV files in your load script. You can then consume the CSV files in other applications.

-Rob

Re: Is it a bad idea to use Qlik Sense API?

oz_moyal — Wed, 22 Jun 2022 21:47:15 GMT

HI,
I have written API service using ASP .Net and QLIK .net sdk, to connect to qlik, to a model and get data to other services.

(data that has lots of calcualutions and that the BI developer did in a model, so we didn't want to redo all this calucaltions)

There is things that u need to consider, like, not opening too many connection to qlik, as u have limit of open connections for the same user.
You can avoid that by keeping the connection in application variable.

Or you can cache the data on the API for X hours, so u don't need to connect to qlik each tiem u get a request.
You also need to be caution when using some filters, in case u access the data with same user on same time.

So taking all considerations u can decide if it will fit your requirements.