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.
-
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 - In the Data Source Explorer, right-click the connection name and select Properties.
- Select Aster Database Connection Properties.
Modifying an existing Hadoop connection profile - In the Data Source Explorer, right-click the connection name and select Properties.
- Select Hadoop System Connection Properties.
- Select the JDBC tab.
Modifying an existing Teradata connection profile - In the Data Source Explorer, right-click the connection name and select Properties.
- Select Teradata JDBC Connection Properties.
-
Click next to Select a driver from the drop-down.
- Select the External JDBC Driver template for your system type.
- In Driver name, enter a unique name for the driver definition.
- 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.
- On the Properties tab, edit the JDBC driver properties.
- Click OK to save the new driver definition. The new driver is listed in the Select a driver from the drop-down list.