17.00 - Configuring Teradata ODBC on macOS - 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
Once installation is complete, one or more DSNs need to be configured for first time users.
  1. Create a System Data Source Name (DSN) in the /Library/ODBC/odbc.ini, using the GUI of Apple ODBC Administrator.
    1. Launch the ODBC Administrator utility in the /Applications/Utilities folder.
    2. Click the System DSN tab.
    3. Click the Add button to configure a new data source.
    4. If prompted to choose a driver, select the Teradata Database ODBC Driver 16.20.
    5. In the ODBC Driver Setup for Teradata Database dialog box window, enter the following information:
      Keyword Description
      DataSource An easy-to-recognize name for the database connection
      Teradata Server Info Hostname or IP address of the Advanced SQL Engine
      Authentication > Username Database user name
      Optional > Default Database  
    6. Click OK to close the dialog box window.
    7. Click Apply.
  2. Test the connection to the database:
    tdxodbc -d data-source-name -u UID -p PWD
  3. You can define more DSNs for additional connections by repeating Step 1, and test the connections as needed by repeating Step 2.