Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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.