Retrieve Schema from Teradata

One Star

Retrieve Schema from Teradata

When retrieving a teradata Table schema, Talend seems to scramble the native ordering of the schema.  I have also noticed it also references some very oddly named one or two character data types which I am not aware of existing in teradata.    For example  I and VC.  The I is probably an integer but there are numerous others that dont make logical sense.


I tried this with the latest driver available under both teradata versions 15.10 and 16.20.


Has anyone else seen these issues?

Seven Stars JGM
Seven Stars

Re: Retrieve Schema from Teradata

I havnt seen Talend "scramble" the schema columns in the past -- what version of talend are you working with?


While I cant help with the first part of your question, you can change the teradata datatype mappings if the defaults are not to your liking.


To change the datatype mappings, go to Window->Preferences, then navigate to Talend->Specific Settings->Metadata of TalendType

Here, you should see a list of XML files, one for each database type:




Hit Edit and open that XML up. There you will find two mappings defined:

talendToDbTypes -- These will be used when mapping java datatypes to database datatypes

dbToTalendTypes -- These will be used when mapping database datatypes to java datatypes -- you'll want to change the mappings here to change what Retrieve Schema maps columns to. 



One Star

Re: Retrieve Schema from Teradata


I am using talend Real-Time Big Data Platform 6.5


Re: Retrieve Schema from Teradata


Could you please show us your trouble screenshots about this kind of "scramble" issue?

Please refer to this online documentation about:TalendHelpCenterSmiley Frustratedupported systems, databases and business applications by Talend components to see if you are on a supported database platform.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey


Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables


How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration


Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now