Connect INFORMATICA PowerCenter to TERADATA

Third Party Software
Enthusiast

Connect INFORMATICA PowerCenter to TERADATA

Hi,

this is a second post, looks like the former one is lost ...
an attempt to connect INFORMATICA to TERADATA via ODBC returns an error :
[DataDirect][ODBC Teradata Client driver][Teradata]The user does not have SELECT access to DBC.TVM.

Does anybody know why INFORMATICA should access DBC.TVM ?
read access is given on dbc.tables, dbc.databases ...
Thanks for giving links or details on the rights that are required,

Pierre
Tags (1)
2 REPLIES
Teradata Employee

Re: Connect INFORMATICA PowerCenter to TERADATA

Most tools access dbc tables/views to retrieve metadata information about the database objects. I'm surprised it's only these three so far, it will probably want access to dbc.columns also

Dave

Re: Connect INFORMATICA PowerCenter to TERADATA



Hi, All dbc.tables, dbc.databases & dbc.columns are views based on dbc.tvm table. When we create any User in Teradata, by default it grant SELECT access to most of the dbc views..So in case if you read data it allows..but when you try to read the structure of views then it throws error. i believe may be you are trying to import the structure/metadata of the dbc views within Informatica..contact you DBA and get SELECT access to dbc.tvm table too.

in simple terms: if you execute "Select * from dbc.tables " - it works fine
but when you execute "Show select * from dbc.tables" - it throws an error "The user does not have SELECT access to DBC.TVM"

Thanks
Thiru