topic Re: Difference between ODBC and OLE DB connectors? in QlikView

Difference between ODBC and OLE DB connectors?

Thu, 08 May 2014 12:19:18 GMT

Difference between ODBC and OLE DB connectors?

Re: Difference between ODBC and OLE DB connectors?

Thu, 08 May 2014 12:22:52 GMT

There are some advantages to using an OLE DB connection over an ODBC connection. Firstly, with OLE DB, your connection string along with credentials stays with your QlikView document, whereas with ODBC you will have to set up a User/System DSN(in ODBC Administrator Control Panel Applet) and then reference this DSN in the QlikView load script. The other advantage to OLE DB is quite simply that it is newer technology.

Re: Difference between ODBC and OLE DB connectors?

Thu, 08 May 2014 12:24:16 GMT

go through this links below

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

Re: Difference between ODBC and OLE DB connectors?

Greg_Hood — Thu, 08 May 2014 12:26:54 GMT

Ole DB is better especially if QlikView Server or Publisher will handle the reloads. They will require any ODBC connection to be set up as SYSTEM DSN connections so the services can see the connection on the host (unless the DSN user is the same account running the QDS service).

Re: Difference between ODBC and OLE DB connectors?

Thu, 08 May 2014 12:35:22 GMT

Thankyou

Re: Difference between ODBC and OLE DB connectors?

Thu, 08 May 2014 12:37:41 GMT

Thankyou

Re: Difference between ODBC and OLE DB connectors?

fkeuroglian — Thu, 08 May 2014 12:48:29 GMT

ODBC is Open Data Base Connectivity, which is a connection method to data sources and other things. It requires that you set up a data source, or what's called a DSN using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.

OLE is Object Linking and Embedding. OLEDB is partly distinguished from OLE itself, now called "automation".

OLEDB is the successor to ODBC, a set of software components that allow a QlikView to connect with a back end such as SQL Server, Oracle, DB2, mySQL etal. In many cases the OLEDB components offer much better performance than the older ODBC.

OLEDB is a different type of data provider that came about with MS's Universal Data Access in 1996 and does not require that you set up a DSN.

see this attach

Re: Difference between ODBC and OLE DB connectors?

MuraliPrasath — Fri, 09 May 2014 06:27:06 GMT

ODBC Vs OLEDB

ODBC - provides access only for relational databases (Sql Server, Oracle etc)

OLE DB –provides access for both relational and non-relational databases. (Oracle, Sql-Server, Excel, raw files, etc)

Full access to ODBC data sources and ODBC drivers

Access to data regardless of its format or location