Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the difference between ''ODBC and 'OLEDB' connection?which one we prefer?

what is the difference between ''ODBC and 'OLEDB' connection?which one we prefer?

thans in advance

9 Replies
ThornOfCrowns
Specialist II
Specialist II

fkeuroglian
Partner - Master
Partner - Master

Hi

i attached some interesting link and a image to undestand the difference

Differences between OLE DB provider and ODBC data source connections - Excel - Office.com

oledb - what is the difference between OLE DB and ODBC data sources? - Stack Overflow

* If the user wants to access data independent of the SQL language , you should migrate to OLE DB . As noted , the connectors are linked to ODBC SQL language.

* If the user's problem can solve directly manipulating tables , it is best to use OLE DB .

* If the user wishes to multidimensional data parallel interfaces , OLE DB is recommended as it is the only standard for data and models with these characteristics, and reduces the required amount of code and execution time.

* If the user requires access to different databases (local, shared , IOM, etc. ) from a single application , use OLE DB , otherwise you will be using separate routes for each access method code. This is also based on the idea that the OLE DB connectors reduce the differences between drivers , SQL and DBMS dialects have been problems between the ODBC settings.

* If the user need is to run concurrent updates , the OLE DB architecture is the best choice . To update records using an ODBC driver , the user must generate SQL UPDATE statements that are basically oriented batch updates . There is no concept of records in an ODBC block model.

The OLE DB architecture accommodates various models allowing the management of data from many more applications.

It is for this that QlikView for developing complex models that depend on multiple databases , you should use OLE DB connections instead of ODBC connections.

Good luck

Fernando

Not applicable
Author

At Qlikview we can use both ODBC or OLEDB, basically the ODBC driver DataSources are used to OLEDB drivers to access Data. Also OLEDB can access XML Files, Directory services and Exchange Servers too.

db-full-diagram.png

In terms of performance, any database layer will increase access time at least 40% in comparative with native access.

At Qlikview  we made a two or three steps architecture to gain performance. Just Like any ETL  process, extract all the data from your database and store it in QVD files, after that, Transform the data from QVD to your application. Qlikview QVD files are extremmally optimized to gain performance,

regards

Mahesh

Not applicable
Author

Hi Manoj,

ODBC ,OLEDB andJDBC | Qlik Community

chek the link..

regards

Mahesh t

Anonymous
Not applicable
Author

If you use SQL Server, consider ODBC for future compatibility. Though Microsoft was the architect of the OLE DB standard, they're moving on.

SQL Server Native Client OLE DB Provider Will Not Ship after SQL Server 2012

hic
Former Employee
Former Employee

All of the above is true: OLE DB is more modern and has a richer interface.

However, it very rarely matters which you choose. Bot work fine, and modern ODBC drivers are often just as fast as OLE DB. Pick one connection type that works, and don't spend time on optimizing something that doesn't matter.

HIC

Not applicable
Author

Thanks Henric.

Not applicable
Author

Thanks to all for your valuable feedback.

Not applicable
Author

This above diagram was very helpful. Thank you mahesh