Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
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";

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

Highlighted
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.