ODBC vs JDBC

[ksuman]

From Hadoop and presto data sources is it possible to setup the connectivity using ODBC and JDBC ?

What is the major diff ? similarly how many ways can establish terdata connectivity ?

[AnandVyas]

Hi @ksuman 

There is a native SAS/Access interface to Teradata which can be configured to use with SAS. For making connection via ODBC you will need the driver from the data source that you can use along with SAS. This will require SAS/Access to ODBC installed and configured at your site.

[ksuman]

@AnandVyas 

we have SAS Access interface to Teradata,

well my question is for Oracel normally

1) Oracle client install

2) tns.ora file will add the user,pass, hostname and IP...

similarly how to connect to TD ?

moreover what is diff ODBC and JDBC ?

SAS Access to ODBC is basic 

[AnandVyas]

For SAS/Access to TD you will need following client installed.

You can refer the system requirements doc based on your OS:

https://support.sas.com/documentation/installcenter/en/ikfdtnwx6sr/66390/PDF/default/sreq.pdf

https://support.sas.com/documentation/installcenter/en/ikfdtnlaxsr/66396/PDF/default/sreq.pdf

Search for section: SAS/ACCESS Interface to Teradata

SAS/ACCESS Interface to Teradata
Base SAS is required for the installation of SAS/ACCESS Interface to Teradata.
SAS has extended SAS/ACCESS and SAS In-Database Technologies support to selected cloud and
database variants of supported data sources. For a list of the supported variants, see
https://support.sas.com/en/documentation/third-party-software-reference/9-
4/support-for-database.html.
DBMS Products Required:
• Teradata Database version 13.10 or later
• Teradata CLIv2 client libraries, TTU 13.10 or later for Windows (64-bit libraries)
For SAS 9.4M3
DBMS Products Required:
• Teradata Database version 14.10 or later
• Teradata CLIv2 client libraries, TTU 14.10 or later for Windows (64-bit libraries)
For SAS 9.4M4 – 9.4M6
DBMS Products Required:
• Teradata Database version 15.10 or later
• Teradata CLIv2 client libraries, TTU 15.10 or later for Windows (64-bit libraries)
For SAS 9.4M7 and Later
DBMS Products Required:
• Teradata Database version 16.20 or later
• Teradata CLIv2 client libraries, TTU 16.20 or later

ODBC and JDBC are industry standard. Difference between them is the technology used for the driver. General difference here: https://www.geeksforgeeks.org/difference-odbc-jdbc/

In SAS perspective configuration will be different based on what you use ODBC or JDBC. You can refer the above shared system requirements document for the configuration. Kindly note JDBC is supported only from Nov 2018 release onwards.