Qlik® | Support Portal

Knowledge
Popular Topics
Browse Topics
Products
A complete multi-cloud solution

Our next generation data analytics platform lets people of all skill levels do more with data.

Guided Analytics

Building your own rich, guided analytics applications with a flexible, business-ready solution.
Additional Products

Qlik Analytics Platform^®

Qlik Data Catalyst^™

Qlik Core^®
Value Added Products

Qlik GeoAnalytics^®

Qlik Connectors^®

Qlik NPrinting^®

Qlik DataMarket^®

Qlik Associative Big Data Index^®
See All
Downloads

Welcome Guest

2019-08-07 ALERT: Certain QED Course Videos Access Issues Click here
2019-07-05 ALERT: Working with Qlik Support Onboarding Videos now Available! Click here
2019-04-16 ALERT: QlikView and Qlik Sense - Important Security Fix now available in new Service Releases and Patches Click here

×

Knowledge

Qlik ODBC Connector package cut long Teradata filednames to 30 characters

Article Number: 000031333 | Last Modified: 2019/01/17

Description

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

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 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.