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

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

kaushiknsolanki — Thu, 21 Apr 2016 08:58:37 GMT

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

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

kkkumar82 — Thu, 21 Apr 2016 08:59:48 GMT

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

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

Kushal_Chawda — Thu, 21 Apr 2016 09:00:05 GMT

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

Direct Discovery in Qlikview

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

kkkumar82 — Thu, 21 Apr 2016 09:01:12 GMT

Direct Discovery in Qlikview

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

Thu, 21 Apr 2016 09:04:15 GMT

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

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

Kushal_Chawda — Thu, 21 Apr 2016 09:10:03 GMT

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.

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

perumal_41 — Thu, 21 Apr 2016 09:13:07 GMT

refer

Re: Direct Discovery Limitations

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

Thu, 21 Apr 2016 09:33:20 GMT

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.

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

Kushal_Chawda — Thu, 21 Apr 2016 10:44:10 GMT

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

DIRECT QUERY

dimension

Name1,

Name2,

Name3,

measure

Amount1,

Amount2,

Amount3;

FROM Table_Name;

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

Thu, 21 Apr 2016 12:04:26 GMT

Thank you 🙂

But a small change in the above script, I guess We don't need to provide semi colon after "Amount3"(I mean last field).

Since it was showing some error.

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

Kushal_Chawda — Thu, 21 Apr 2016 12:59:50 GMT

Yeah u r correct..