topic ODBC performance! in QlikView

ODBC performance!

Fri, 27 Apr 2012 08:55:50 GMT

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

ODBC performance!

adhudson — Fri, 27 Apr 2012 09:17:36 GMT

Hi,

Have you tried using OLEDB mechanism to connect?

I think OLEDB will be better than ODBC.

Regards

Andrew Hudson

ODBC performance!

magavi_framsteg — Fri, 27 Apr 2012 11:54:45 GMT

Hi salman12.

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

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.