QlikiView ODBC & OLEDB connection difference

[Venkat3]

Hi Team,

Hope you are doing well!

need your suggestions/help on the below queries.

1. what is the difference between ODBC & OLEDB? which is the suitable to use? is it dependence on the server configuration & security policies to use specific one(ODBC/OLEDB)?

2. is there any query issue(in script) if we use ODBC instead of existing OLEDB connection?

Thanks in Advance!

[ramasaisaksoft · Accepted solution]

As we know that both Qlikview ODBC and OLEDB interfaces use to connect user applications to the data source. They work as query translators and so are used by many DBMS vendors who allow access to their data only through ODBC or OLEDB.

However, both connections are different from each other in some ways.

In the QlikView ODBC connection type, the application needs to establish a connection to the data source using the data source specific drive. The connection is established using Database Source Name (DSN) which in simple words, is an instruction in such a format and structure understandable to the database.

Whereas, the QlikView OLEDB does not use the DSN system to set up a connection with the data source. The OLEDB connection string can simply type in the editor of the document and it stays there in the document.

In fact, QlikView OLEDB prefers for connecting with databases by QlikView users as well. Because it is more convenient to initiate the connection (no DSN setup), it is also much faster than ODBC and a reliable source as well.