Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a business critical issue? Please Contact us by phone. Click here to view phone numbers by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
- ALERT: Qlik Product Download Page Click here
- ALERT: Support Alert Click here
Knowledge
Qlik ODBC Connector package cut long Teradata filednames to 30 characters
Article Number: 000031333 | Last Modified: 2019/01/17Description
When using Teradata connector in Qlik ODBC Connector Package to connect to a Teradata database, filed names which are longer than 30 characters will be shorten to 30 first characters. As a result, Data preview and reload fails with error "Column <shortened name> not found".
Cause
This is a known limitation of Qlik ODBC Connector Package, which is currently investigated in bug QVXODBC-744
Resolution
Consider the following work-around solutions:
- Modify filed names in the database to make sure imported field names are shorter than 30 chars
- Use SELECT * instead of SELECT <fields> in the reload script. Note: this will load all data from the table, which will increase traffic between QlikView/ Qlik Sense and Teradata. Unnecessary fields may need to be removed later by resident loading and dropping the temp table. This solution should only be applied for small data tables.
- Configure a generic ODBC connection using official Teradata ODBC driver instead of Qlik ODBC Connector package. Teradata ODBC driver can be downloaded at http://downloads.teradata.com/download/connectivity/odbc-driver/windows
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.