Talend Open Studio v 7.0 (SELECT access to DBC.UDTInfo in Teradata)

Six Stars

Talend Open Studio v 7.0 (SELECT access to DBC.UDTInfo in Teradata)

I have downloaded the open source Talend Open Studio Integration 7.0 software; working on getting data from Teradata over to SQL Server.  I was able to successfully connect to Teradata db, however, I am getting the following error when retrieving schema from a table in a specific database. 

 

[Teradata Database] [TeraJDBC 16.20.00.06] [Error 5315] [SQLState HY000] The user does not have SELECT access to DBC.UDTInfo.TypeName]

 

Why would it be looking into that database if that's not where I want to look in?  Not getting any luck getting that access and was wondering if there is a way to bypass that.  Thanks for any help!

Eleven Stars

Re: Talend Open Studio v 7.0 (SELECT access to DBC.UDTInfo in Teradata)

I think it's to get db informations ask your dba to have more rights or write it by hands.
good luck

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.