Teradata ODBC Connection Issue

[#1]

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

[krishnacbe · Accepted solution]

Hi,

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

[Anonymous]

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

[#4]

Hi Krishna,

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

Regards

Kumar

[#5]

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

[krishnacbe]

Great that it worked.

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

[Anonymous]

OK Kumar.

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

Regards