Using QsAppMetadataConnector to connect to multiple apps with a single data connection

[Nicole-Smith]

I've successfully set up Qlik Sense Document Analyzer on our server and can run it against a single report.  

There are certain metrics within the Document Analyzer that we want to pull into our own reporting.  However, I want to pull the metrics for all apps on the server into the app I am creating.   Is there any way to use QsAppMetadataConnector to connect to all apps on the server instead of needing to set up an individual connection for each app?

@rwunderlich looking for your guidance here.  Posted as a thread on the community since I figured it may help others as well.

[rwunderlich · Accepted solution]

Yes it's possible with the 1.7 connector.  You must configure the connection for the server setup, but you can vary the app in the select statement.  An optional appid prefix may be added to the tablename. If omitted, the app configured in the connection is used. So:

SELECT * FROM agjs--33-45.ObjectDimensions;

The connector has an AppIdentifier table that will list the Appnames and Appids on the server. You can use that to map names or titles to appids.  In QSDA, see the "FindAppId" Sub for an example.

IMPORTANT: If you code up a loop to process multiple apps, do not repeat the  "LIB CONNECT TO..".  Try to use one CONNECT for your entire script.  Each CONNECT will consume a license slot and you will run out after 5. 

Also, if you are going to select multiple QsAppMetaConnector tables per app, code your loop to do all tables for each app. That is, loop by app, not by table. This is more efficient. 

If you find QSDA or the connector useful I'd love to hear about it!

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[Nicole-Smith]

Thank you for the guidance @rwunderlich.  I may have additional questions as I start to dig in more.  Will post to this thread so others can follow along.

[saikiranrao]

Hi Smith, Did you find a solution for this issue?

[Nicole-Smith]

Unfortunately, no.  We had issues with getting the connection to work on our deployment of Qlik Sense.  Thinking it was probably just our deployment and not an issue with the connector itself.

[rwunderlich]

You can make the connector work in a loop. But...as @Nicole-Smith experienced, there can be issues with getting the connector to install and work correctly in some environments.  I am deprecating the QVF based QS Document Analyzer in favor of QSDA Pro.  Take a look at QSDA Pro to see if it fulfills your requirement and if not reach out to me with what you need. 

-Rob