Configuring Teradata ODBC on macOS - Teradata Package for R

Teradata® Package for R User Guide
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for R
Release Number
17.20
Published
March 2024
ft:locale
en-US
ft:lastEdition
2024-04-09
dita:mapPath
efv1707506846369.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
nqx1518630623256
lifecycle
latest
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.