macOS DSN Configuration
This section shows how to set up ODBC connectivity and configure DSNs on macOS.
Minimum macOS Version
The CData ODBC Driver for Teradata driver requires macOS Sierra (10.12) or above.
Licensing the Driver
In a terminal, run the following commands to license the driver. To activate a trial, omit the <key> input.
cd "/Applications/CData ODBC Driver for Teradata/bin"
sudo ./install-license.sh <key>
You'll be prompted for a name and password. These refer to your name and your machine's password.
Deploying the Driver
Begin by downloading the official Teradata JDBC driver.
Place the driver jar into the installation/lib directory. Ex: /Applications/CData ODBC Driver for Teradata/lib/
The driver wraps the official Teradata Database driver; you can connect to the CData ODBC Driver for Teradata using the same connection properties and access the same functionality as the underlying Teradata driver. You also need to install the official driver alongside the CData ODBC Driver for Teradata.
Connecting to Teradata
Required Properties
To connect to Teradata, provide the following authentication information and specify the database server name.
- AuthScheme: Set this to either TD2 (default) or LDAP depending on the required authentication mechanism of your Teradata server.
- User: Set this to the user name of a Teradata user.
- Password: Set this to the password of the Teradata user.
- DataSource: Specify the Teradata server name, DBC Name, or TDPID.
- Port: Specify the port the server is running on.
- Database: Specify the database name. If not specified, the driver connects to the default database.
TLS/SSL Configuration
Enable DataEncryption to encrypt connections with TLS/SSL.
Uninstalling the Driver
The easiest way to uninstall the driver is to open a terminal and run the included uninstall.sh script, located in the installation directory. For example:
cd "/Applications/CData ODBC Driver for Teradata" sudo ./uninstall.sh
Note: The script needs to be run from the installation directory.