Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Is direct query for me ?

Hi there,

I am new to QlikSense and I created an application, with a ODBC link to a MySQL database.

For now it's a proof of concept but I would like to go further by getting fresh datas each time I open the application without having to manually reload the datas. In the future the application will be connected to a massive database, the manual refresh won't be possible.

I read some articles about direct query, but I can't achieve anything.

What would be the first steps knowing that I load my datas with the following script :

LIB CONNECT TO 'Bench_Table_Centrale (qsense_edai7800)';

[METRIQUES]:

SQL SELECT

  VERSION_NUMERO,

  VERSION_REFERENCE_NUMERO,

  APPLICATION_NUMERO,

  PERIODE_NUMERO,

  PERIODE_REFERENCE_NUMERO,

  METRIQUE_LIBELLE,

  METRIQUE_UNITE,

  METRIQUE_VALEUR,

  METRIQUE_VALEUR_REFERENCE,

  METRIQUE_CATEGORIE,

  METRIQUE_SOUS_CATEGORIE,

  METRIQUE_FONCTION_OBTENTION,

  METRIQUE_SOURCE,

  METRIQUE_ATTRIBUT_1,

  METRIQUE_ATTRIBUT_2,

  METRIQUE_ATTRIBUT_3

FROM table_centrale.METRIQUES;

[PERIODES]:

SQL SELECT

  PERIODE_NUMERO,

  PERIODE_LIBELLE,

  PERIODE_DEBUT,

  PERIODE_FIN

FROM table_centrale.PERIODES;

[PERIODES_REFERENCE]:

SQL SELECT

  PERIODE_REFERENCE_NUMERO,

  PERIODE_REFERENCE_LIBELLE,

  PERIODE_REFERENCE_DEBUT,

  PERIODE_REFERENCE_FIN

FROM table_centrale.PERIODES_REFERENCE;

[APPLICATIONS]:

SQL SELECT

  APPLICATION_NUMERO,

  APPLICATION_LIBELLE

FROM table_centrale.APPLICATIONS;

[VERSIONS]:

SQL SELECT

  VERSION_NUMERO,

  VERSION_LIBELLE

FROM table_centrale.VERSIONS;

[VERSIONS_REFERENCE]:

SQL SELECT

  VERSION_REFERENCE_NUMERO,

  VERSION_REFERENCE_LIBELLE

FROM table_centrale.VERSIONS_REFERENCE;

[ETUDES_PERIODES]:

SQL SELECT

  ETUDE_PERIODE_NUMERO,

  ETUDE_PERIODE_PERIODE_NUMERO,

  ETUDE_PERIODE_PERIODE_REFERENCE_NUMERO,

  ETUDE_PERIODE_CONTENU,

  ETUDE_PERIODE_STATUT,

  ETUDE_PERIODE_CATEGORIE

FROM table_centrale.ETUDES_PERIODES;

[ETUDES_VERSIONS]:

SQL SELECT

  ETUDE_VERSION_NUMERO,

  ETUDE_VERSION_VERSION_NUMERO,

  ETUDE_VERSION_VERSION_REFERENCE_NUMERO,

  ETUDE_VERSION_CONTENU,

  ETUDE_VERSION_STATUT

FROM table_centrale.ETUDES_VERSIONS;

Is Direct Query the solution ?

Damien

2 Replies
datalakeyu
Not applicable

Re: Is direct query for me ?

Do you use Qlik server? If so, you could schedule the data loading at Qlik server.

Not applicable

Re: Is direct query for me ?

Yes, we are using Qlik Server, but we can't do it like that, the database will be too big and we will spend our time loading the datas.