Hi,
I have Informatica 8.1 and have to use Teradata as Backend. I created ODBC connection and I am able to import teradata tables as source and target. I created a relational connection for Teradata and tried to execute my workflow but I am getting error. In teradata relational connection I have given connection name as edw_dev , user_id and Password and data source name again as edw_dev as that is my system dsn name in ODBC connection. The database name is kept as blank.

The error which I am getting is

Severity Timestamp Node Thread Message Code Message
ERROR 8/22/2007 7:52:36 AM node01_nyrofclnxinformatica READER_1_1_1 RR_4036 Error connecting to database [
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [b_sott_dev] and connection string [edw_dev].].

What could be possible reason for this? Is there any problem with the relational database connection I have provided or is it problem with ODBC.

Any help will be highly appreciated.

Thanks,
Ritesh Kumar