topic Re: Configure to connect Teradata in Administration and Deployment

Configure to connect Teradata

karthic2612 — Thu, 02 Aug 2018 10:49:32 GMT

Hi All,

Please help me in configuring teradata jdbc drivers in SAS. Please let me know steps to be followed to configure teradata jdbc driver in SAS. I need to connect to teradata from SAS to fetch/push data to/from SAS.

Thanks,

Vishal

Re: Configure to connect Teradata

nhvdwalt — Thu, 02 Aug 2018 11:06:56 GMT

Hi @karthic2612

As a starting point, see below. I've assumed SAS 9.4 on Linux.

Configuration:

http://support.sas.com/documentation/installcenter/en/ikfdtnlaxsr/66396/PDF/default/sreq.pdf - Page 19

Usage:

https://go.documentation.sas.com/api/collections/pgmsascdc/9.4_3.4/docsets/acreldb/content/acreldb.pdf?locale=en#nameddest=titlepage - Page 1021

Re: Configure to connect Teradata

karthic2612 — Thu, 02 Aug 2018 11:36:07 GMT

Hi,

We do not have licensed SAS/Access interface to Teradata to configure. I would like to go with Teradata jdbc driver to be configured in SAS to connect Teradata database. Could you please help me on configure Teradata jdbc in SAS

Thanks,

Vishal

Re: Configure to connect Teradata

nhvdwalt — Thu, 02 Aug 2018 11:56:49 GMT

Hi @karthic2612

What SAS Access engine(s) do you have licensed ?

Re: Configure to connect Teradata

karthic2612 — Thu, 02 Aug 2018 12:07:10 GMT

Hi,

We have SAS/Access interface to ODBC licensed.

Thanks,

Vishal

Re: Configure to connect Teradata

nhvdwalt — Thu, 02 Aug 2018 16:51:39 GMT

My suggestion would be to use the Teradata ODBC driver since you are already licensed for SAS Access to ODBC.

Re: Configure to connect Teradata

karthic2612 — Fri, 03 Aug 2018 06:17:05 GMT

Hi,

Okay. Thanks for the suggestion.

I have installed unixodbc manager. I need to install Teradata odbc driver.

My doubt is do we need to install using our root id or Sas installer id.

After installing teradata odbc driver. what are all changes do we need to do in sasenv_local file. Could you please let me know the steps to complete the configuration of teradata odbc driver in SAS.

Thanks,

Vishal

Re: Configure to connect Teradata

SASKiwi — Fri, 03 Aug 2018 07:54:56 GMT

See page 58 SAS/ACCESS Interface to ODBC :

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf