Qlik Community

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Generating List Of Data Connections For Each App

Hi guys

I'm looking to put together a java script extension (or any method) whereby I can generate a list of all data connections used by an app on Qlik Sense.

I've only been looking at the use of API's briefly but from what I understand, the only way to generate such a list is to

1. go through each and every app on a server

2. pull the script value

3. parse the script result where it uses 'LIB CONNECT TO' (I'm only interested in OLEDB and ODBC)

I have a sample script that will iterate through every app on a server. I'm thinking that I will need to use the GetScript method when iterating through each app and store the result (qScript) into an array. I'll need to parse out the piece of the script that uses the LIB CONNECT string.

I will also need a list of all connections on the server to join up to. I was going to use the GetConnections method to achieve this. Similar to the above, I'll parse the results and pull the values I want (type, connection string).

Can anyone give me some pointers if I'm

a) on the right track or if there's an easier way of doing this

b) how to use the data retrieved in the javascript - can I export to a delimited file or even a QVD or should I just look to map the data within the javascript code?

Any help is appreciated.


1 Reply

even that is not conclusive: you are ignoring the include and must_include lines.

Interesting to understand from Qlik how to approach a project like this.

Kind Regards,