Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
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
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";

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";

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

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.