Adding a New Driver Definition - Teradata Studio

Teradata Studio Express User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cxo1484765174902.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.