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

Teradata® R Package User Guide

prodname
Teradata R Package
vrm_release
17.00
created_date
November 2020
category
User Guide
featnum
B700-4005-090K

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 five 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")
  • JWT : Using JWT token to connect to Vantage. The connection will be active till the expiry of JWT token.
    td_create_context(host = <host-name>, dType = "native", logmech = "JWT", logdata = list(jwt.token=<token_value>))

In addition to the five logon mechanisms listed above, connection to Vantage can be established using Stored Password Protection feature. See td_create_context() function in Teradata R Package Function Reference for more information.

To use non-default logon mechanisms (TDNEGO, LDAP, KRB5 and JWT), you must set up the clients with appropriate security mechanisms.