How we can directly fetch the data from Database without loading it in to in memory?

[#1]

How we can directly fetch the data from Database without loading it in to in memory?

[kaushiknsolanki]

Hi,

What exactly you are trying to do.

Qlik is a in memory tool, so when data is loaded it will go to RAM only.

Regards,

Kaushik Solanki

[kkkumar82]

If I correctly get it , you mean not to use qvds rather loading data from database.

Other wise there is a concept known as Data discovery

[Kushal_Chawda]

You can use the Direct Discovery feature of QV 11.2 version. see this

Direct Discovery in Qlikview

[kkkumar82]

Direct Discovery in Qlikview

[#6]

If we are using Direct Discovery in Qlikview, Do we have any limitations for the number of tables we are fetching from DB?

[Kushal_Chawda]

There is no limitation of Number of Tables. but there is limitations of features like you will not be able to use binary loads, calculated dimensions, section access, set analysis.

[perumal_41]

refer

Re: Direct Discovery Limitations

[#9]

I was using the following script for fetching the data from my DB, But I was getting some syntax errors.

Test_Table:

DIRECT QUERY

dimension

Name1,

Name2,

Name3,

measure

Amount1,

Amount2,

Amount3;

SQL SELECT

*

FROM "_DB_Name".dbo."_Table_Name";

I would appreciate your help.

[Kushal_Chawda · Accepted solution]

ODBC CONNECT .............

DIRECT QUERY

dimension

Name1,

Name2,

Name3,

measure

Amount1,

Amount2,

Amount3;

FROM Table_Name;