Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-07-08 02:12 PM

Teradata JDBC Connection

Hi team,
I am using Talend Team edition 4.2 using to to load Teradata database. I have Install Teradata Client on my machine. I have two jar file:
1. tdgssconfig.jar
2. terajdbc4.jar
and placed in C:\jdbc Folder.
url string is com.teradata://<Ip_Config>/<DB_Name>
I have Class path environement variable as c:\jdbc
there is no space in the Talend Studio Directory.

I am using tTeradataMultiload Component to load database.
While executing tthe Job I have encounter the following error. I tried alot to solve but could not. Help me to solve this. Let me know if more info is requested.

connecting to socket on port 3482
connected
GSSException: Failure unspecified at GSS-API level (Mechanism level: UserFile parameter null)
at com.teradata.tdgss.jtdgss.TdgssParseXml.<init>(Unknown Source) at com.teradata.tdgss.jtdgss.TdgssConfigApi.<init>(Unknown Source) <

To see the whole post, download it here
Labels (6)
Labels
780 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2012-07-08 10:59 PM
Author

Hi
I'm just curious about this.
Why don't you use the components under teradata family in TOS which can offer better performance and Talend support?
Regards,
Pedro
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 02:03 AM
Author

I am very new to Teradata and so Talend. I used tTeradatafastloadutilityprotol as well. but the same issue.
May I request you to let me know the correct component.
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 02:14 AM
Author

Hi
I notice you are using tJDBCConnection and you didn't configure it correctly. That's why you got a nullpointerexcetion.
What's your essential requirement? What's the design of your job?
Regards,
Pedro
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 02:19 AM
Author

I have to load teradata database. my source file is dat file and I am using JDBC Connection to insert Audit info like start time, end time and seq id. then disable any index on the table. after that load database, archive file and enable the index.
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 02:27 AM
Author

Hi
According to your description, you can use two components about teradata.
tTeradataOutput is used for loading data while tTeradataRow can disable or enable index.
Regards,
Pedro
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 02:50 AM
Author

Thanks Pedro. But I also need tJDBCConnection. I am attaching my Screen shot. I would be great help, if you point out the missing configuration in JDBC. Also Let me know if you need more info.
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-09 05:09 AM
Author

did you get a chance to check? I check my job for Netezza databasee and its working fine as attached.
But for Teradata, its not.
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-10 12:26 AM
Author

Hi Pedro,
its a bit urgent. can you please help me to sort it out? let me know if addition info is required
Cheers,
Siegfried
610 Views
0 Likes
Anonymous
Not applicable
‎2012-07-10 12:31 AM
Author

Hi
I suggest that you should use the components under teradata famlily in TOS.
Because the JDBC jar files about teradata may cause some unexpected errors due to wrong version.
Why don't you download the document and read the instructions about teradata components? They are much more efficient than JDBC way.
Regards,
Pedro
610 Views
0 Likes