topic Re: Teradata ODBC Connection Issue in QlikView

Teradata ODBC Connection Issue

Wed, 18 Jan 2017 14:51:41 GMT

Good Morning users,

I need some help on connecting QlikView to Teradata via an ODBC connection.

Looks like my ODBC connecting is working but when I use the "Select" button to get into the "Create Select Statement" box, I can't see any Database tables at all (Screenshot attached).

Can someone please help me understand what I am missing here?

Thanks for your help in advance!

Regards

Kumar

Re: Teradata ODBC Connection Issue

krishnacbe — Wed, 18 Jan 2017 15:17:38 GMT

Hi,

Instead of using wizard, try writing the query manually. Reload the file and check.

Re: Teradata ODBC Connection Issue

Anonymous — Wed, 18 Jan 2017 15:29:53 GMT

have you try to change the owner? maybe the actual owner don´t have access,tell us what happend if you find the answer for you case.

Regards

Re: Teradata ODBC Connection Issue

Wed, 18 Jan 2017 19:17:50 GMT

Hi Krishna,

Thanks for your response.Writing the Query manually worked. Still not sure why the other approach is not working though.

Regards

Kumar

Re: Teradata ODBC Connection Issue

Wed, 18 Jan 2017 19:25:51 GMT

Hi Enrique,

Thanks for your response. The owner does have access. I tried writing the query manually and it worked. Still not sure why the other approach did not work but I have what I needed for now. Maybe I will do a deep dive later to figure out what needs to be happen to make the "Select" button option work.

Regards

Kumar

Re: Teradata ODBC Connection Issue

krishnacbe — Wed, 18 Jan 2017 19:35:40 GMT

Great that it worked.

Please mark the answer as Helpful or close the thread by marking the correct answer.

Re: Teradata ODBC Connection Issue

Anonymous — Thu, 19 Jan 2017 23:32:13 GMT

OK Kumar.

I hope that you find the answer and you can share with us.

Regards