topic Re: Using QsAppMetadataConnector to connect to multiple apps with a single data connection in Connectivity & Data Prep

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

Nicole-Smith — Fri, 10 Dec 2021 20:26:56 GMT

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.

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

rwunderlich — Fri, 10 Jul 2020 19:35:20 GMT

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

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

Nicole-Smith — Fri, 10 Jul 2020 20:17:19 GMT

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.

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

saikiranrao — Thu, 26 Aug 2021 04:20:09 GMT

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

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

Nicole-Smith — Fri, 27 Aug 2021 03:07:11 GMT

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.

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

rwunderlich — Fri, 27 Aug 2021 19:29:45 GMT

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