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.