Is direct query for me ?

Tue, 30 Aug 2016 14:42:32 GMT

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

Re: Is direct query for me ?

Anonymous — Wed, 31 Aug 2016 03:06:39 GMT

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

Re: Is direct query for me ?

Wed, 31 Aug 2016 06:56:27 GMT

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.

topic Re: Is direct query for me ? in App Development

Is direct query for me ?

Re: Is direct query for me ?

Re: Is direct query for me ?