I want to connect teradata from PC SAS 9.2. I have tried the the following two methods:
1)libname tst TERADATA server=XXX user=XXX password=XXX;
ERROR: The TERADATA engine cannot be found.
ERROR: Error in the LIBNAME statement.
2) proc sql;
CONNECT TO TERADATA AS TERA
(Server = XXX Schema = XXX user = xxx pwd = xxx mode=teradata);
quit;
ERROR: The TERADATA engine cannot be found.
ERROR: A Connection to the TERADATA DBMS is not currently supported, or is not installed at
To connect teradata is there any other step I have to ensure before writing these code?
Thanks in advance
Does your site license SAS Access for Teradata?
post the outout of proc setinit; run;
As the message implies, are you sure that SAS/ACCESS to Teradata is installed?
Later on, you need the Teradata client, which more or less their ODBC driver.
/Linus
If after doing a PROC SETINIT you have SAS/ACCESS to Teradata installed - I used to connect to teradata this way where UPPERCASE are required and lowercase are my names.
LIBNAME tst TERADATA TDPID="10.2.123.456" USER=myuserid PASSWORD=mypassword SCHEMA=dbschema;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.