topic Re: What is needed to connect SAS to teradata in SAS Enterprise Guide

What is needed to connect SAS to teradata

anjicamsas — Sun, 13 Oct 2019 12:37:49 GMT

when i hit the code (Proc setinit; run;), i am able to see the following in the log.
---SAS/ACCESS Interface to DB2 29NOV2019
---SAS/ACCESS Interface to Oracle 29NOV2019
---SAS/ACCESS Interface to PC Files 29NOV2019
---SAS/ACCESS Interface to ODBC 29NOV2019
---SAS/ACCESS Interface to Teradata 29NOV2019
---SAS/ACCESS Interface to MySQL 29NOV2019
---SAS/IML Studio 29NOV2019

but in the folder (C:\Program Files\SASHOME2\SASFoundation\9.4\access\sasexe), i couldnt fine these sasiotpt.dll and sasiotra.dll.

when i try to run any terdata code, i am getting end up with following error.
ERROR: The TERADATA engine cannot be found.
ERROR: A Connection to the teradata DBMS is not currently supported, or is not installed at your site.

WHAT should i do ?

Re: What is needed to connect SAS to teradata

SASKiwi — Sun, 13 Oct 2019 19:20:37 GMT

Run - proc product_status; run; - to confirm if SAS/ACCESS Interface to Teradata is installed or not.

Re: What is needed to connect SAS to teradata

anjicamsas — Mon, 14 Oct 2019 09:21:51 GMT

There are two servers in my ENterprise guide ( local and sasapp)
From SASAPP profile connected,
When i run PROC SETINIT;RUN;

i can see the following (regarding Teradata)
Current version: 9.04.01M5P091317
Operating System: LIN X64 .

---SAS/ACCESS Interface to Oracle 14DEC2019
---SAS/ACCESS Interface to SAP ASE 14DEC2019
---SAS/ACCESS Interface to PC Files 14DEC2019
---SAS/ACCESS Interface to ODBC 14DEC2019
---SAS/ACCESS Interface to Teradata 14DEC2019

When i run PROC PRODUCT_STATUS;RUN;

For SAS/ACCESS Interface to Teradata ...
Custom version information: 9.45

When i try to connect to teradata using below code,
libname trlib teradata user=ABCDEF password=PWDPWD;

i gets following error.

26 libname trlib teradata user=ABCDEF password=XXXXXXXX;
ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS file or names database. .
ERROR: Error in the LIBNAME statement.

What could be the issue. it will be much helpful if i get answer for this.

Re: What is needed to connect SAS to teradata

Patrick — Mon, 14 Oct 2019 10:59:53 GMT

@anjicamsas

Please ask the same question only once in a single forum. Ongoing discussion here