Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
udaya_kumar
Valued Contributor

Is it possible to connect qlikview to teradata?

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

Tags (2)
1 Solution

Accepted Solutions
udaya_kumar
Valued Contributor

Is it possible to connect qlikview to teradata?

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

4 Replies
Not applicable

Is it possible to connect qlikview to teradata?

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 :-)

udaya_kumar
Valued Contributor

Is it possible to connect qlikview to teradata?

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

saumyashah90
Valued Contributor

Re: Is it possible to connect qlikview to teradata?

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

Not applicable

Re: Is it possible to connect qlikview to teradata?

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

Community Browser