Add Teradata JDBC Drivers to SuperCHANNEL

JDBC (Java Database Connectivity) is a programming interface that lets Java applications access a relational database.

SuperCHANNEL needs a JDBC driver so that it can access the relational database system (e.g. SQL Server, Oracle, etc) where your source data is stored.

Before you can run SuperCHANNEL, you need to install the appropriate JDBC driver and configure SuperCHANNEL so that it can access the driver.

In most cases the JDBC drivers are supplied by the database vendors. STR does not supply the drivers.

Teradata

If your source data is stored in a Teradata database, then you need to configure SuperCHANNEL to use the Teradata JDBC driver.

Step 1 - Download and Install the Driver

1. Download the latest version of the Teradata JDBC driver from http://www.teradata.com/downloadcenter/
2. Extract the driver files from the download. The driver files are .jar files, and will be named something like terajdbc4.jar and tdgssconfig.jar.
   

3. Copy the driver files to the drivers directory in your SuperCHANNEL installation. If you chose the default installation options, the location will be: C:\Program Files\STR\SuperCHANNEL\jar\drivers

   

   Depending on your system configuration, you may need administrator permissions to copy to this directory. If you are prompted to provide administrator permissions, click Continue.

Step 2 - Edit the SuperCHANNEL Configuration

1. Locate the SuperCHANNEL configuration file, config.txt. If you chose the default installation options, this file will be located in C:\ProgramData\STR\SuperCHANNEL\bin
   
   

   Make a backup copy of this file before making any changes.

2. Open config.txt in a text editor.

3. Locate the line that defines the Java Class Path variable (java.class.path), and add the following to the end of the line:
   
   $(SNU_PROGRAM_HOME)\jar\drivers\terajdbc4.jar;$(SNU_PROGRAM_HOME)\jar\drivers\tdgssconfig.jar;

   

   Notes

   Replace terajdbc4.jar and tdgssconfig.jar with the filenames of the drivers you installed.

   $(SNU_PROGRAM_HOME) is a predefined variable that refers to the SuperCHANNEL program files directory.

   Each entry in the Java Class Path definition must be separated by a semi colon, and there must also be a semi colon at the end of the line.

4. Locate the line that defines the jdbc.drivers and add the following to the end of the line:
   
   :com.teradata.jdbc.TeraDriver

   

   Note

   Each entry in the jdbc.drivers definition must be separated by a colon.

5. Locate the following section of the configuration file:

   NONE

   # Uncomment this to force use of a schema qualifier before table names - needed for DB2 and Teradata.
   # str.usequalifier=.

6. Uncomment the str.usequalifier line by removing the # character at the start of the line:

   NONE

   # Uncomment this to force use of a schema qualifier before table names - needed for DB2 and Teradata.
   str.usequalifier=.

   This property configures SuperCHANNEL to prepend the schema name you specify at login time whenever it refers to database objects by name. If the table is not prefixed with a schema, Teradata assumes the schema name is the same as the login username, and if the schema and the user name are not the same then the tables cannot be queried from. Therefore SuperCHANNEL cannot read the registry tables and display or build the database correctly.

7. Save config.txt.

The following example shows the driver additions to the configuration file:

Step 3 - Start SuperCHANNEL

Start SuperCHANNEL, and use the following connection string to connect to Teradata:

jdbc:teradata://<servername>

Where <servername> is the name of your host for Teradata.

You will also need to provide user credentials for Teradata authentication:

Step 4 - Add Drivers to SNU

This step is optional. If you intend to run SuperCHANNEL from the command line or via scripting, you should also add the drivers to snu.bat. This is the SuperCHANNEL batch file, located in C:\ProgramData\STR\SuperCHANNEL\bin by default.

Make a backup copy of this file before making any changes.

Add the driver entry to the last statement in the file. This is the Java call to execute the program.