DATA Step, Macro, Functions and more

How to access Teradata from SAS

Reply
New Contributor
Posts: 3

How to access Teradata from SAS

Hi,

 

 

I am trying to execute the below code by sing BASE/ SAS:

 

libname rams teradata user=sas_user password=XXXXX database=database server=prod;

 

it is showing the below error. Can you please provide your valuable inputs asap.

 

Error: The SAS/ACCESS interface to TeraData cannot be loaded. The SASTRA code appendage could not be loaded.

 

Please let me know what are the prerequisites to connect to the Teradata DB as it is a first time access.

 

Thanks,

Rama Sarma

 

 

Super User
Posts: 17,907

Re: How to access Teradata from SAS

Is Access to Teradat licensed? 

 

Check license with proc setinit and installation with proc product_status. 

New Contributor
Posts: 3

Re: How to access Teradata from SAS

Hi Reeza,

 

Yes ..it is licensed version.

When I run proc setitin the below log is coming related to teradata. It is in Grace period and we are able to use it for other querying purpose. 

SAS/ACCESS Interface to Teradata
30MAY2016

When I run product-status, I am getting the below status message.

SAS/ACCESS Interface to Teradata ...
Custom version information: 9.4_M2.

 

Hence, Please suggest me with the next move.

Super User
Posts: 17,907

Re: How to access Teradata from SAS

You have to explain your set up. 

Are you a desktop SAS or server?

 

Does ODBC work?

 

Also, I would contact SAS tech support. They're fast and helpful. 

New Contributor
Posts: 3

Re: How to access Teradata from SAS

Hi,

 

From SAS server I am able to connect, but from desktop version only I am trying and I am getting the above mentioned error.

 

And my next move is, following support.sas.com to resolve the issue. But I am not able to get the exact resolution.

 

One more question is like..do we need to work with Teradata team to declare any IP address of our Base SAS to get the access?

 

Thanks.

Super User
Posts: 5,260

Re: How to access Teradata from SAS

You should definitely work with the TD to resolve any connection and athorization issues, but I don't think your IP is used by default as part of the authorization - but check to be sure.

First step should be to connect to TD from the local (on the SAS server) TD cleint (or any other ODBC client application that can use the TD client ODBC driver) to see if you can connect.

Once verified that par, go on to configure and connect from SAS.

Data never sleeps
Super User
Posts: 6,963

Re: How to access Teradata from SAS

Access to RDBMS works like this:

DB client is installed on SAS host

DB connection is configured into the client

Client config information is included in SAS startup files

SAS gets access by using DB client with the connection config

Now, if the specific workspace server that you use from the desktop misses the connection configuration in its startup script, it can't use the DB access.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 6,963

Re: How to access Teradata from SAS

See if one of these provides you with a clue what might go wrong:

http://support.sas.com/kb/51/194.html

http://support.sas.com/kb/44/700.html

http://support.sas.com/kb/16/105.html

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
SAS Employee
Posts: 203

Re: How to access Teradata from SAS

Hi @Rama_Goteti

 

This error typically means that the product in question (in this case SAS/ACCESS to Teradata) is not installed or is configured improperly. Checking the license file (SETINIT) only tells us if the product is licensed.

 

Best wishes,

Jeff

Ask a Question
Discussion stats
  • 8 replies
  • 551 views
  • 1 like
  • 5 in conversation