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