Teradata Connection Help

RazorSQL can connect to Teradata via either JDBC or ODBC. See below for information on both of these connection methods.

Connecting to Teradata via JDBC

RazorSQL does not ship with the Teradata JDBC drivers. To get connected to Teradata, the JDBC drivers must first be obtained. Click the below link to get the appropriate JDBC driver from the Teradata site:

https://www.teradata.com/DownloadCenter/

Once the JDBC driver is obtained, users can connect to Teradata via the JDBC Type 4 driver by launching the connection wizard and selecting Teradata as the database type and JDBC (Teradata JDBC Driver) as the connection type. The driver location field needs to include the paths to the terajdbc4.jar and tdgssconfig.jar files. The two paths should be separated by semi-colons. Either manually type in the paths, or use the browse button and select both jars by holding down the control key, or use the browse button two times and say No when asked to replace the path to have RazorSQL store the paths to both files.

Next, enter any applicable login information. In the Database Name field, enter the name of server where Teradata is located. and in the Port field, enter the TCP port that Teradata is listening on. The default is 1025.

Connecting to Teradata via ODBC

To get connected with ODBC, the Teradata ODBC driver must be installed on your machine, and an ODBC datasource for Teradata must be configured on the user's machine prior to connecting. To get the Teradata ODBC driver, click the following link:

https://www.teradata.com/DownloadCenter/

For more information on setting up ODBC datasources, see the following:

ODBC Setup

Once the ODBC driver is installed and an ODBC datasource is configured, open the connection wizard, select Teradata as the database type, ODBC as the connection type, and select the name of the ODBC datasource you configured to make an ODBC connection to Teradata.

Manual Terdata JDBC Information

If manually configuring your connection, see the following for JDBC driver class and JDBC URL format. Manual JDBC Information