Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mgsrinivasmurth
Partner - Contributor III
Partner - Contributor III

Is there a way to know what Data Connections in QMC are not used?

Is there a way to know if all the data connections listed in the QMC are being used or not? We want to identify only list of data connections that are being used and cleanup anything that are not used.Considering there are several streams and apps manullay checking is not an option. As the Data Connections only shows what users has access to and not necessariily what APPS are attached to this? Is there a way we can find out this information. Any help on this is appreciated

2 Solutions

Accepted Solutions
bwisealiahmad
Partner - Specialist
Partner - Specialist

Hi,

Well under data connections you could turn on more fields by clicking the column selector right next to the actions button up right. There you can add connection string and type and that will give you mor einfo for what they are beign used for.

I have used this before to do some controlling of connections.

Otherwise you might find some help in the Operations Monitor application under your Monitor Applications and see if there is a field or column you can use there to identify this.

Best,

Ali A

View solution in original post

lucienorrin
Creator
Creator

7 Replies
biob_stein
Creator
Creator

I am also interested in this topic!

asparagus
Contributor II
Contributor II

One way is to enter the "Engine API Explorer" (http://<your QS Server URL>/dev-hub/engine-api-explorer

Connect to the Engine, Select an App and run "GetConnections" on the document.

This will generate a JSON list of all connections.

To do this programatically in a loop you could write small C# or (Engima) JavaScript.

bwisealiahmad
Partner - Specialist
Partner - Specialist

Hi,

Well under data connections you could turn on more fields by clicking the column selector right next to the actions button up right. There you can add connection string and type and that will give you mor einfo for what they are beign used for.

I have used this before to do some controlling of connections.

Otherwise you might find some help in the Operations Monitor application under your Monitor Applications and see if there is a field or column you can use there to identify this.

Best,

Ali A

mgsrinivasmurth
Partner - Contributor III
Partner - Contributor III
Author

Hi Bwusealiahmad,

 

Pretty nice solution.Sorry was away from forums from quite some time. Many thanks for the solution this should enable us to get the required information.

 

Thanks

Srini

mgsrinivasmurth
Partner - Contributor III
Partner - Contributor III
Author

It seems like the solution you suggested is just listing the data connections unfortunatley it is not listing the data connnections to the App that has been selected. Am I doing something wrong. I connected to the App and did the Get Connection and Get Connections method either it returns no data or returns the entire set of data connections we have on the server.

lucienorrin
Creator
Creator

For anyone else who stumbles on this post:

 

https://github.com/eapowertools/qs-data-connection-analyzer

mgsrinivasmurth
Partner - Contributor III
Partner - Contributor III
Author

Thanks for this. this is exactly what I was after. Will have a look at the App today. 🙂