BookmarkSubscribeRSS Feed
ani
Calcite | Level 5 ani
Calcite | Level 5

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 Smiley Happy

4 REPLIES 4
art297
Opal | Level 21

Does your site license SAS Access for Teradata?

FriedEgg
SAS Employee

post the outout of proc setinit; run;

LinusH
Tourmaline | Level 20

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

Data never sleeps
robby_beum
Quartz | Level 8

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;

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 3965 views
  • 0 likes
  • 5 in conversation