Topic: Connecting to Teradata DB

Hi newerakb,

For the next version of DataCleaner we've fixed a bug which I think is what is causing your problem (ie. the bug is that we need to show the user an error message that is otherwise only logged). You can do either of two things:

• Run DataCleaner using the .cmd or .sh commands, which will make the command line appear in the background of the application. You should be able to see the error exception in the command line.

• Download the latest snapshot of our development version which has the bug fixed: get it here

Thanks for the reply. I tried the new version and am now seeing the following error (actual address masked):
java.sql.SQLException: No suitable driver found for jdbc://{address}

I have the driver registered, the logfile shows this:
INFO main dk.eobjects.datacleaner.gui.model.DatabaseDriver - Loaded class: com.teradata.jdbc.TeraDriver

Again, I've used this exact driver with this exact connect string in other Java apps, so I'm fairly certain that isn't the issue. Since all the profiler asks for is a connect string, id, and pw, how does it know which driver to use to connect?

Thanks again

Okay, I've solved that problem, and of course ran into another. I just needed to add "teradata:" to my connect string, like "jdbc:teradata://{address}".

Here's my current issue. When using Teradata JDBC, two driver files are requires. There's the main file, "terajdbc4.jar", and a config file, "tdgssconfig.jar". Both are required to connect using JDBC.

The problem is that the config jar doesn't actually contain a Java class, so I can't register it within the DataCleaner application. All it contains is a manifest and an xml file. I've added both the filepath and the directory path where the jar resides to my own CLASSPATH variable in Windows, but I still get the error messages associated with the config jar missing.

Any suggestions?

Just to keep this updated, section 1.5 on the following link has a situation involving this gss configuration file
[http://www.teradata.com/DownloadCenter/Topic9364-98-1.aspx]

I added the path to the xml file to the classpath and I still can't connect. So it looks like I won't be able to use DataCleaner without having some extra mechanism for registering a driver without a class.

Hi newerakb,

I see your problem. It's true that you can't put additional non-driver JARs on the classpath from within the application. You can however edit the .cmd/.sh file to include them in the classpath when starting up the JVM.

In the .cmd, here's how to do it:

1. Open datacleaner.cmd file in a text editor (eg. notepad or similar)
2) Go to the last line of the file and remove this part (the ending of the line):

-jar datacleaner.jar

3) Instead enter:

-cp datacleaner.jar;tdgssconfig.jar dk.eobjects.datacleaner.gui.DataCleanerGui

(the previous post is assuming the the "tdgssconfig.jar" file is placed in your datacleaner directory.

Thanks kasper, that worked beautifully! Working with Teradata I've learned to not get my hopes up with regard to finding any help with 3rd-party tools. Glad it worked out this time.

Thanks again.

Very glad it worked! I guess we can brag a bit about that in the datacleaner crew then ;-)

I guess I can confirm then that "com.teradata.jdbc.TeraDriver" is the correct classname, and "jdbc:teradata:{address}" is the correct connect string, in case you ever feel like adding it to the default list.

Hehe I've gone and added it right away.