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/

Connecting to Teradata

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.

Required Properties

To connect to Teradata, set these properties:

• AuthScheme: Specify your Teradata server's required authentication mechanism: either TD2 (default) or LDAP.
• User: Teradata user username.
• Password: Teradata user password.
• 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.

For more information on available properties, see the Teradata .NET Data Provider documentation.

TLS/SSL Configuration

To encrypt connections with TLS/SSL, enable DataEncryption.

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.