Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense publish app connect to my database server

Hi All,

How to Qlik sense publish app connect to my server database (SQL server) and how to pick charts real time data from database ?

Is it possible please explain ?


Ankit Singh

4 Replies

Hi Ankit

Do you have Qlik Sense Desktop or Qlik Sense Enterprise?



Not applicable

Hi A,

I have Qlik Sense Enterprise. Can you please explain Qlik Sense Enterprise and Qlik Management Console is similar or different to each other. If they are differ then what is the difference between QSE and QMC ?





I am assuming you've created a SQL Server connector while you've developed your application.... This connector is usually created with the creator's Name (see #1 below) so it's recommended that you will make it anonymous (see #2 below) .

Screen Shot 2017-03-20 at 2.51.30 PM.png

You can do it in QMC (which is just a tool to manage your Server environment)...

Just select your connector in the list of available connectors and remove the creator's name from it.

You just need make sure the connector can be accessed by Qlik's Server account (the one is used to reload your data).

It's usually done by default (since the system account has a Security Admin and/or Content Admin roles set for it).

Once you've check all the above, your published app will be loading the data the same way the DEV version does...



P.S. When applicable, please mark this answer Correct or Helpful.


Hi Ankit,

Qlik Sense Enterprise  consists of two parts - Qlik Sense Hub (QSH) and Qlik Management Concole (QMC). If in whole, then QSH is designed to develop and use applications (creating load scripts, worksheets, charts, etc.). QMC is intended primarily for administration of applications and the operating environment Qlik Sense (management of applications, threads, users, licenses, etc.).

For example, your initial load task can be solved as follows:

1. First at QSH you connect to SQL server (see Vladimir answer below)

2. Then at QMC you tune the task of periodically loading data from SQL server by previously created connection.