Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC performance!

Hello Everyone,

I want to ask Is there any other way of loading data into QlikView by Avoiding the ODBC connection to the Database. Because when we use ODBC ,we have to write queries to load data into Qlikview and it takes some time or in some cases Bottle neck is created  and the process is slow. Is it possible to directly load data from network sharing? Is that a more faster way ? Which method is Better.? Share your Experience guys... how you do it.

Best REgards,

Salman

2 Replies
adhudson
Creator II
Creator II

Hi,

     Have you tried using OLEDB mechanism to connect?

     I think OLEDB will be better than ODBC.

Regards

Andrew Hudson

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi salman12.

My great experience has shown that OLEDB connections run faster than ODBC.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.