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?
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.