topic Re: How to access Teradata from SAS in SAS Programming

How to access Teradata from SAS

VVDR — Wed, 22 Jun 2016 06:54:33 GMT

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

Re: How to access Teradata from SAS

Reeza — Wed, 22 Jun 2016 07:03:47 GMT

Is Access to Teradat licensed?

Check license with proc setinit and installation with proc product_status.

Re: How to access Teradata from SAS

VVDR — Wed, 22 Jun 2016 07:19:11 GMT

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.

Re: How to access Teradata from SAS

Reeza — Wed, 22 Jun 2016 07:33:20 GMT

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.

Re: How to access Teradata from SAS

Kurt_Bremser — Wed, 22 Jun 2016 07:37:28 GMT

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

Re: How to access Teradata from SAS

VVDR — Wed, 22 Jun 2016 12:38:48 GMT

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.

Re: How to access Teradata from SAS

LinusH — Wed, 22 Jun 2016 13:17:05 GMT

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.

Re: How to access Teradata from SAS

Kurt_Bremser — Wed, 22 Jun 2016 20:04:41 GMT

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.

Re: How to access Teradata from SAS

JBailey — Sat, 11 Feb 2017 21:08:02 GMT

Hi @VVDR

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