Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Highlighted
adhudson
Contributor II

ODBC performance!

Hi,

     Have you tried using OLEDB mechanism to connect?

     I think OLEDB will be better than ODBC.

Regards

Andrew Hudson

Partner
Partner

ODBC performance!

Hi salman12.

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

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.