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

[ananyaghosh]

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

Thanks,

Sandip

[Levi_Turner]

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:

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

LIB CONNECT TO 'NameOfYourDataConnection';

LOAD *;

SQL *

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

[rittermd]

I setup the ODBC and the connector.

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

[Levi_Turner]

Whoops, this should work:

LOAD *;

SQL SELECT *

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

[ananyaghosh]

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]

Please give me a reply for my questions.