Only connect! Qlik and ODBC

[Jennell_McIntire]

It’s a simple but profound statement to say that QlikView has worked with ODBC connectors for many years. Even our new product, Qlik Sense, has worked with ODBC connectors since its creation. But what are the implications of working with ODBC connectors?

ODBC was created to solve a simple problem: how to extract data from different databases in a fast and standardized way? Nowadays, most database vendors supply ODBC drivers or OLE DB providers and there’s even a thriving market of driver providers. If your application supports ODBC, you have a huge range of databases to connect to. This means that there are many, many databases you can connect QlikView and Qlik Sense to.

I got bored one day and started to list the ODBC databases QlikView and Qlik Sense connect to. You can see my list to the right, not including different versions of the same driver.

Now if you need something more, then you can always use an existing 3rd party custom connector or create one using the Qlik QVX SDK.  So there are always options and ways that your data can be loaded into a QlikView or Qlik Sense application.  The options are endless.

Do you know of more databases you can connect to with the Qlik ODBC connectors?

[jim_chan]

Hello Steve,

Yes, i have created a profile, then i have managed to download it and installed. Then, i was following the steps provided on this URL link. -How to Setup ODBC Connection to SAS Datasets.doc

but, i got this error when i wanted to test it out on my qilkview desktop.

[stevedark]

That error is being passed straight through from SAS.  You will probably get more joy looking for a solution on the SAS forums than the QlikView ones.  It would appear to be an issue in the configuration of the driver.

Steve

[jim_chan]

Thanks Steve

[Anonymous]

Thanks Jannel for a great list of available connections. We developed some new ODBC drivers for Cloud services which are compatible with QlikView. So, with our drivers, you can connect QlikView with Magento, Salesforce, FreshBooks, QuickBooks, NetSuite, MailChimp, DynamicsCRM, SugarCRM, ZohoCRM, BigCommerce.

You can check the info about the drivers here 32/64 ODBC drivers for Linux, Mac OS and Windows to access databases

[JonnyPoole]

check out EasyMorph for some possible SAS connectivity options

EasyMorph | Data transformation and analysis tool