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
