Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC VS OLEDB Connectivity

Generally which type of connectivity is recommended when you connect a qlikview application to a database:


Note: The necessary setup for both are available.

1. Whcih would give a better performance and provides a secured mechanism for extracting?

2. What are the advantages and disadvantages of both?

1 Reply


If OLE DB driver is available it should be used ahead of an ODBC connection.The use of OLE DB negates the need for setting up an ODBC connection. OLE DB simply requires one setup step within QlikView.

ODBC is Open Data Base Connectivity, which is a connection method to data sources.It requires that you set up a data source ( DSN) using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.So it is user friendly

But OLEDB is the successor to ODBC, a set of software components that allow a "front end" such as GUI based on VB, C++, Access or whatever to connect with a back endsuch as SQL Server, Oracle, DB2, mySQL etc. OLEDB components offer much better performance than the older ODBC.