topic Re: Connection in Qlikview in QlikView

Connection in Qlikview

Anonymous — Thu, 01 May 2014 06:13:10 GMT

Hello All,

Just need a small help from you guys...

When we are creating connection with SQL Server then which data source we will use?

ODBC or OLEDB?

In which scenario ODBC & OLEDB are useful?

Regards,

Balraj

Re: Connection in Qlikview

MK_QSL — Thu, 01 May 2014 06:21:14 GMT

OLE DB...

Update : If you are on 64 Bit System Driver, tick Force 32 Bit.

Re: Connection in Qlikview

Thu, 01 May 2014 06:22:19 GMT

Hi Balraj,

For Connecting with SQL Server database you please go with OLEDB Connection.

Regards

Deepak

Re: Connection in Qlikview

Thu, 01 May 2014 06:29:24 GMT

When connecting to SQL server, there is not such big difference between OLE DB and ODBC, because OLE DB uses ODBC when accessing SQL server. Generally speaking, OLE DB is abstracted data connection model of ODBC, meaning OLE DB is easier to understand for human than ODBC.

One practical difference between them is, as my understanding, detail setting is available for ODBC.

See the web site below, you can find a good data accessing flow image.

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

Re: Connection in Qlikview

Anonymous — Thu, 01 May 2014 06:29:32 GMT

Deepak,

I came to know from one of my friend and as per his input, he told me that when it comes to Sql Server you can connect to it with ODBC only...

Is it so?

Regards,

Balraj

Re: Connection in Qlikview

Roop — Thu, 01 May 2014 14:00:43 GMT

I would always use OLE DB as it is simpler and integrated into the application.

With OLE DB you do not need to perform an additional step to set up an ODBC connection.

Re: Connection in Qlikview

ThornOfCrowns — Thu, 01 May 2014 14:07:40 GMT

All you need to know, straight from the source:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/10/odbc-confusion

Re: Connection in Qlikview

maxgro — Thu, 01 May 2014 14:31:58 GMT

I doubt you can see performance difference getting data from your sql using odbc or oledb; so choose what you want, the simpler to use, the more recent, oledb, odbc or a mix (oledb on odbc); more detail in the attachment

Re: Connection in Qlikview

fkeuroglian — Thu, 01 May 2014 14:34:12 GMT

Hi,

I recommend you to try both of them and see the difference

it is really important and big difference, i absolutely recommend OLEDB

It is a newer driver connection and allow you to connect with more different and faster tipe of connection

good luck

Fernando