Test Connection to Vantage with Teradata SQL Driver | Teradata R Package - 16.20 - Testing Connection to Vantage with Teradata SQL Driver for R - Teradata R Package

Teradata® R Package User Guide

Product
Teradata R Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2022-05-02
dita:mapPath
qbt1519078127352.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval

Establish a connection to the database using td_create_context(), with the argument dType set to 'native'.

con <- td_create_context(host = <host-name>, uid=<username>, pwd=<password>, dType = "native")
There are four logon mechanisms available to connect to Vantage with Teradata SQL Driver for R.
  • TD2: The Teradata 2 (TD2) mechanism provides authentication using a Vantage database username and password. This is the default logon mechanism.
    td_create_context(host = <host-name>, uid=<username>, pwd=<password>, dType = "native", logmech = "TD2")
  • TDNEGO: TDNEGO is a security mechanism that automatically determines the actual mechanism required, based on policy, without user's involvement. The actual mechanism is determined by the TDGSS server configuration and the security policy's mechanism restrictions.
    td_create_context(host = <host-name>, uid=<username>, pwd=<password>, dType = "native", logmech = "TDNEGO")
  • LDAP: LDAP is a directory-based mechanism. User logs on to a Vantage database with a directory username and password and is authenticated by the directory.
    td_create_context(host = <host-name>, uid=<username>, pwd=<password>, dType = "native", logmech = "LDAP")
  • KRB5: KRB5 is a directory-based mechanism. User logs on to a Vantage database with a domain username and password and is authenticated by Kerberos (KRB5 or SPNEGO mechanism).
    td_create_context(host = <host-name>, uid=<username>, pwd=<password>, dType = "native", logmech = "KRB5")
To use non-default logon mechanisms (TDNEGO, LDAP and KRB5), you must set up the clients with appropriate security mechanisms.