2 Replies Latest reply: Aug 31, 2016 2:56 AM by Damien Aiello RSS

    Is direct query for me ?

    Damien Aiello

      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