16.20 - Configuring Teradata ODBC on macOS - 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
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 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.