topic Re: Is it possible to connect qlikview to teradata? in QlikView

Is it possible to connect qlikview to teradata?

udaya_kumar — Wed, 18 Jan 2012 10:11:46 GMT

hi,

i want to know whether we can connect qlikview to teradata or not.

and if yes, then how we can connect?

can anyone help me?

thanks in advance

Is it possible to connect qlikview to teradata?

Sun, 06 May 2012 11:02:08 GMT

hi Kumar,

you can download the ODBC / OLEDB connector from the teradata.com site

at: http://downloads.teradata.com/download

but as far as i could see, the performance is very poor.

a query that i ran within teradata and took up to 5 minuts, in QV i aborted it after half an hour, extracting 100k lines out of 500k i was supposed to get.

but im sure im missing somthing here.... so if you find anything else keep me updated 🙂

Is it possible to connect qlikview to teradata?

udaya_kumar — Tue, 15 May 2012 05:31:30 GMT

Hi,

i have connected to teradata from qlikview.

first, we need to create a new datasoure in the control panel->administrative tools->data source->select the teradata driver and provide the data source name,teradata server name, username and password and save it.

then go to qlikview, in edit script, click connect and select the created data source and enter username and password, then it connects to database.

just reload it and check, it shows connected.

then you can get the tables from database from select button below the connect button in edit script window.

add the tables and reload it. you have data now from database

Re: Is it possible to connect qlikview to teradata?

saumyashah90 — Mon, 20 Jan 2014 12:38:12 GMT

hey if the performance is poor. You should use QlikView Direct Discovery

Re: Is it possible to connect qlikview to teradata?

Wed, 19 Nov 2014 16:54:01 GMT

The direct discovery will make the whole model a whole lot slower... AFAIK it queries the DB after each selection in order to recover the possible values... isn't it more practical to query the whole thing and save it to Qvd instead?

EDIT: If you need to recover a large database then you may need to think in some sort of partial reload scenario but querying a slow database via Direct Discovery just sounds weird to me