Directly Accessing a Teradata Table

[john471]

Can anyone please help with the following:-

I was using an ODBC linked table to a Teradata database, and extracting a sub-set of data to local tables to use in a report. I was using an administrator's (or high power user, at any rate) account to do this, and they have now decided I may not use their account any more, and now must use my own (they even changed their password - can you believe the audacity of it all !!!? )

Problem is : They won't grant my account access to the "database", as only an elite few are permitted this. They have granted my account access to a table (or is it a "view"???) in the Teradata database. Therefore, trying to link to the table is impossible as far as I can tell, because the ODBC connection will not give me a list of tables in the "database" (as I am not permitted access to the database, as a whole). HOWEVER: Using another tool (QueryMan 5.1) I can connect to the teradata machine, and execute the following statement; and get an "AnswerSet" (returned records)

sel * from <databaseName>.<TableName>

So access is permitted to the table, if only I could convince Access to have "blind faith" and "point" to it without "seeing" it.

Does anyone know how I might get around this dilemma in AC97 ?

 

[Pat Hartman]

You don't have authority to view the database's system tables. That's why the ODBC driver can't give you a list. If you know what the connection string is, you can use TransferDatabase to link to the table.

 

[john471]

Thanks

Pat,

Thank you very much.

As always; you are a genius.

Now I just have to convince the Teradata DBA to stop persuing his "alternate" solution, and grant me access to the other table I also need!

Pat, once again, thank you.