There are many reasons why you might want to connect to your Qlik Sense repository. For example, you may want to create a Qlik Sense application that lists all the applications and objects, along with current publication status.
It is quite easy to connect as it is hosted, by default, in a PostgreSQL database.
First thing that you will need is the download of the PostgreSQL ODBC drivers from: http://www.postgresql.org/ftp/odbc/versions/msi/ - there are both 32 bit and 64 bit versions available.
Once you have installed the driver, you can configure the ODBC connection:
The things that you will need to know are:
Database - QSR
Server - wherever the repository database is installed.
Port - 4432 (not the default of 5432)
User Name - postgres
Password - the password that you provided on installation.
That should be good to go.
For a good tool to browse the database, pgAdmin III is a winner: http://www.pgadmin.org/
Stephen Redmond is author of QlikView Server and Publisher and the QlikView for Developer's Cookbook
He is CTO of CapricornVentis a
QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond
the connection went well, but after that the qlik sense show me the tables but not de dataReplyDelete
did'nt work in my test environment :-(ReplyDelete
Works very well for me. Thanks!ReplyDelete