Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator 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

5 Replies
Levi_Turner
Employee
Employee

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
Master
Master

I setup the ODBC and the connector.

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

Capture.PNG

Levi_Turner
Employee
Employee

Whoops, this should work:

LOAD *;

SQL SELECT *

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

ananyaghosh
Creator III
Creator III
Author

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
Creator III
Creator III
Author

Please give me a reply for my questions.