Configuring Teradata ODBC on macOS - Teradata Package for R

Teradata® Package for R User Guide
Product
Teradata Package for R
Release Number
17.00
Published
July 2021
Language
English (United States)
Last Update
2023-08-08
dita:mapPath
yih1585763700215.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
B700-4005
Product Category
Teradata Vantage
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 Analytics Database
      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.