connect to in Redshift DB, in order to query in Teradata

General
Tal
New Member

connect to in Redshift DB, in order to query in Teradata

Hi,

I am trying to connect to Redshift datasource in order to use teradata to query  from tables that are sitting in redshift.

I have all the connection details neede (Host, Port, User, password), however couldn't find how to do this connection.

I have went to "Tools"- "System DSN"- "Add" and looked for the option of redshift however there is no such option.

What should I do?

1 REPLY 1
Teradata Employee

Re: connect to in Redshift DB, in order to query in Teradata

When you say "in Teradata", do you mean the "Teradata SQL Assistant" client tool? (I'm guessing, since you mentioned using the ODBC control panel.)

 

If so, you first need to obtain and install an ODBC driver, e.g. from Amazon.