16.10 - Adding a New Driver Definition - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
When you create a new connection profile for a connection that uses JDBC, a default driver definition for an embedded driver is automatically selected. You can add a new driver definition for an external JDBC driver when you first create the profile in the Connection Profile wizard or using the Properties dialog box for an existing connection profile.
  1. Do one of the following, depending on whether you are creating a new connection profile or modifying an existing one:
    Option Action
    Creating a new connection profile In the New Connection Profile wizard, navigate to the Specify a Driver and Connection Details step for a Teradata or Aster connection or the JDBC Connection Properties step for a Hadoop connection.
    Modifying an existing Aster connection profile
    1. In the Data Source Explorer, right-click the connection name and select Properties.
    2. Select Aster Database Connection Properties.
    Modifying an existing Hadoop connection profile
    1. In the Data Source Explorer, right-click the connection name and select Properties.
    2. Select Hadoop System Connection Properties.
    3. Select the JDBC tab.
    Modifying an existing Teradata connection profile
    1. In the Data Source Explorer, right-click the connection name and select Properties.
    2. Select Teradata JDBC Connection Properties.
  2. Click next to Select a driver from the drop-down.
    1. Select the External JDBC Driver template for your system type.
    2. In Driver name, enter a unique name for the driver definition.
    3. On the JAR List tab, add the list of JDBC driver JARs. To locate your Teradata JDBC driver JAR files on the file system, click Add Jar/Zip.
    4. On the Properties tab, edit the JDBC driver properties.
    5. Click OK to save the new driver definition. The new driver is listed in the Select a driver from the drop-down list.