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
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.p... - Page 1021
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
Hi,
We have SAS/Access interface to ODBC licensed.
Thanks,
Vishal
My suggestion would be to use the Teradata ODBC driver since you are already licensed for SAS Access to ODBC.
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
See page 58 SAS/ACCESS Interface to ODBC :
http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.