Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simon_jensen
Partner - Contributor
Partner - Contributor

Overview of data sources in all apps

Hi,

Does anyone know if it is possible to get a list of data connections / data sources for each app in Qlik Sense ?

In my organization we have developed many apps over time, and we now try to streamline the data sources. So that we don't have several QVD-files with the same purpose.

I would like to create an app with a tabel in this format:

App NameData Connection
App 1SQL Database Connection 1

App 1

SQL Database Connection 2
App 1QVD-file X
App 2SQL Databse Connection 1
App 2QVD-file X
App 2QVD-file Y
App 2QVD-file Z
App 2Web connector 1
App 2REST API Connection 1
App 3SQL Database Connection 2
App 3Attached Excel
App 3QVD-file X
App 3QVD-file Y
App 3QVD-file Z

Please don't hesiate if you have any ideas on how to solve this.

Thanks.

2 Replies
Pheaxx
Contributor III
Contributor III

Hi,

One way you could do it. Is to load the script logs and just filter on the parts that show the connection.Another way is to do it via the api, get all apps, then loop through the list to get the scripts and then extract the connections that way.

I used the first method so see what the developers loaded just to know what was happening. because of this method iI could also find out the duration of the load on a specific source. which can also help in performance.

You just need to make sure each RIM node have access to all the script folders in a multi node setup. this due to the fact that the script logs of rim nodes are not synced to the archived folder, only the script logs from the scheduler are synced.

 

Aravindvunnam
Contributor II
Contributor II

Hi @Pheaxx ,

we are to trying to develop a app where we can view all Data Connections or Views used in each app in one place 

can you help me how to load script logs in the app , that will helps a lot .

Thanks in advance ,

Thanks & regards;

Aravind