Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

How to do the ODBC Connection Just to read the data.

I have a ODBC connection from where the data is now being imported into the qlikview. It's  getting the data size increased and also the complete information is also getting download in the QVD file. I need Qlikview to just read the data from the ODBC connection and not to download the data. Is there some process available in doing it. Kindly advice.

2 Replies
lironbaram
Honored Contributor II

Re: How to do the ODBC Connection Just to read the data.

hi

if you load the full table straight via the odbc

the data will be only stored in the qlikview model , so anyone want to interact with the data will need qlikview

other option is working with direct discovery where you only load the dimension from the table

the downside of this approach  is that you loose the quick answers because every selection is translated to a query

that is being sent to the db to get the answers.

have a look at this link

Direct Discovery in Qlikview

Not applicable

Re: How to do the ODBC Connection Just to read the data.

Thanks!. Liron For sharing it. To use the Direct Query and connect to the ODBC tables. Should there need to be minimum size of the table. Since I am not getting the measure populating in the chart I am preparing. I am facing the error as "Database Connection Failed". Kindly assist

Community Browser