Testing Connection to Vantage with Teradata ODBC Driver | Teradata R Package - 17.00 - Testing Connection to Vantage with Teradata ODBC Driver - 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
After installing the tdplyr package on the client, you can load the tdplyr package, and use the td_create_context() function to establish a connection to the database from the R interface on the client.
  1. Load the tdplyr package:
    library(tdplyr)
  2. Use td_create_context() to establish a connection to the database:
    For example, assume that your DSN is called "TDDSN", then from the R command line interface, run the command:
    con <- td_create_context("TDDSN")
    When your DSN specification contains at least the connection data source name, user name and password information, this command run successfully without any error message.
    Otherwise, also specify as needed the function string arguments dsn=<data-source-name>, uid=<username>, and pwd=<password>.
    For example:
    con <- td_create_context(dsn="TDDSN", uid="user1", pwd="user1",database="TDDB")
  3. Run the command con to show the details of the connection.