QlikView: Help with Teradata Connectivity using ODBC Driver

[#1]

Hi All,

I have created a 'System DSN' to connect to Teradata. I'm able to connect successfully to Teradata through SQL assistant. I'm also able to successfully test the connection to that Teradata source through ODBC.

The issue is when I click on 'Select' I'm not able to view any Database or Tables to select.

It will be really helpful if anyone of you could provide insights to the issue.

I have attached screenshot for reference.

Thanks,

Preethi

[sushil353]

Hi,

Check with the administrator if you have access to the database..

[#3]

Hi Sushil,

I do have access to the Database. I'm able to log into 'Teradata SQL Assistant' through that connection and view all the tables and fire query on the same.

Thanks,

Preethi

[sushil353]

Hi Preethi,

Can you check while checking the option for "Force 32 Bit" option

[#5]

Hi Sushil,

I have tried checking the option for 'Force 32 Bit' but still not able to view the Database/Tables.

I have tried with 'OLEDB' Database also the connection test succeeds but not able to view the Database/Tables.

Thanks,

Preethi

[sushil353]

This is bit strange..

are you using any specific user for qlikview ?

just a common advice. to restart your system and check again.. or check with your database administrator

[#7]

Hi Sushil,

It is the same User ID and Pwd for while logging into 'Teradata SQL Assistant' and Qlikview.

I have restarted my machine and tested.

Thanks,

Preethi

[sushil353]

See if this can help you : Is it possible to connect qlikview to teradata?

[#9]

Hi Sushil,

I have tried to connect with the steps as mentioned as in the above link using ODBC Driver.

Is it required to install Connector as mentioned in the below link ? Is it possible to download QVX_TPTConnector.exe as stated in below link with the normal credentials other than registered customer or partner account ?

https://help.qlik.com/en-US/connectors/Subsystems/Teradata_QV_Connector_help/Content/1.0/Introductio...

Thanks,

Preethi