Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
ananyaghosh
Contributor III

how to export the list of data connection to excel sheet from qmc?

For the above list I have to export all the details to excel. Please advise what to do now?

Thanks,

Sandip

Tags (1)
5 Replies
Highlighted
Employee
Employee

Re: how to export the list of data connection to excel sheet from qmc?

Use this PostgreSQL ODBC driver on the server to establish a connection to the underlying Qlik Sense Repository Database:  https://www.postgresql.org/ftp/odbc/versions/msi/

Configure the DSN:

6RwuvAB.png

Create a data connection in Sense, then use it like this:

LIB CONNECT TO 'NameOfYourDataConnection';

LOAD *;

SQL *

FROM "QSR"."public"."DataConnections";

Highlighted
rittermd
Honored Contributor

Re: how to export the list of data connection to excel sheet from qmc?

I setup the ODBC and the connector.

When I try to execute your code I get the following error

Capture.PNG

Employee
Employee

Re: how to export the list of data connection to excel sheet from qmc?

Whoops, this should work:

LOAD *;

SQL SELECT *

FROM "QSR"."public"."DataConnections";

Highlighted
ananyaghosh
Contributor III

Re: how to export the list of data connection to excel sheet from qmc?

Hi,

Is I have to make a data connections at QMC? or I have to create a data connections at Qlik Sense Hub?

Actually I created data connection in QMC of SQL Server 2014. So is it will help this ? also is I have to create a .QVF file at QlikSense Hub?  and use that SQL in that QVF file? Please suggest what I have to do?

Thanks,

Sandip

Highlighted
ananyaghosh
Contributor III

Re: how to export the list of data connection to excel sheet from qmc?

Please give me a reply for my questions.