topic Re: Connecting Qlikview to data stored in Denodo in Connectivity & Data Prep

Connecting Qlikview to data stored in Denodo

cdarling1 — Fri, 02 Apr 2021 08:14:29 GMT

Hi All

Anybody have any experience in connecting Qlikview to a data virtualisation platform, i.e. Denodo? I'm trying via odbc and jdbc but not having any luck.

Thanks

Re: Connecting Qlikview to data stored in Denodo

petter — Thu, 11 Jan 2018 15:13:49 GMT

Denodo offers regular ODBC drivers and QlikView is tuned very well for using ODBC. So could you tell us where it stops for you? Do you get any error messages? Have you downloaded Denodo ODBC driver from their website and installed it?

Re: Connecting Qlikview to data stored in Denodo

cdarling1 — Fri, 12 Jan 2018 09:23:38 GMT

Hi Petter

Many thanks for your reply - I managed to configure the ODBC connector so it does connect successfully (or without errors anyway) but it does not return any tables for me to be able to select the fields from. I have connected to the Denodo source from Excel and been able to pull the info without issue, so I am just wondering what am I missing when it comes to the Denodo connection. I downloaded the ODBC driver from the Denodo site as well.

Re: Connecting Qlikview to data stored in Denodo

Anonymous — Tue, 30 Jan 2018 23:48:17 GMT

Initially I had issues w/ Denodo ODBC, but after reviewing the doc on denodo's site I was able to resolve. Are you getting an error when using:

'ODBC CONNECT TO ?Datasource?'

Load * ;

SQL SELECT

column1, column2

from ?Datasource?.table/view;

Check out the documentation here: Knowledge Base | Denodo

Re: Connecting Qlikview to data stored in Denodo

aghabdurauf — Fri, 26 Jul 2019 06:14:42 GMT

Can you give the link of Denodo website where ODBC driver is available