Teradata & RapidMiner

Analytics

Teradata & RapidMiner


Hello,


I am trying to connect Teradata to rapidMiner5 using either the ODBC and the JDBC connection with the drivers provided in the Teradata webiste. I am using Win-64 and therefore VMware player for Teradata. When I try the ODBC Bridge, rapidminer cannot find the driver [Data source name not found and no default driver specified], even though the driver is available in the "Show Database Driver" window.  


Then I try with the JDBC. In "Manage Database Connections" I put:


name: the name of the DSN


database system: name of the JDBC connection


host: IP of the VMware Player


port: 1025


database scheme: blank


user and password I use the ones put in the DSN (ie the Teradata root details).


I get an error: [Error 1000][SQLState 08S01] Login failure for Connec....


I don't know what to do. I am thinking that maybe I am making some mistakes in setting up the JDBC connection in the "Manage Database Drivers" window. 


Can anybody help me ?


Thank you,


Edoardo

3 REPLIES
Enthusiast

Re: Teradata & RapidMiner

Today I get the same error and did some search for the solution but I found onyl the question here. So I did some extra search and found the answer: delete the port number in the "Manage Database Connections" dialog.

New Member

Re: Teradata & RapidMiner

The Teradata JDBC driver package includes two jar files, one containing the driver and another one with a config file in it. The driver only works when both files are linked via the classpath.

Step-by-step guide

Add the steps involved:

  1. Please download the appropriate JDBC drivers from Teradata and copy all its jar files to the folder "lib/jdbc" inside your RapidMiner Studio installation directory. This ensures that the driver classes are part of the java classpath.
  2. Next go to the database driver management dialog.
  3. For the jar file dialog manually enter both path statements comma separated to address both files (e.g. /path-to-rapidminer-folder/lib/jdbc/terajdbc4.jar,/path-to-rapidminer-folder/lib/jdbc/tdgssconfig.jar).
  4. Teradata JDBC drivers seem to offer no support for port settings. Please leave the port field blank, otherwise a connection cannot be established. 
  5. The driver setup should look similar to the setup shown in this image:

Also, for convenience, here is the link to the JAR files:

http://downloads.teradata.com/download/connectivity/jdbc-driver

 

and default path to the jdbc folder on desktop:

C:\Program Files\RapidMiner\RapidMiner Studio\lib\jdbc

  

large.png

 

http://community.rapidminer.com/t5/tkb/articleprintpage/tkb-id/Studio%40tkb/article-id/39 

Teradata Employee

Re: Teradata & RapidMiner

>>> Teradata JDBC drivers seem to offer no support for port settings.

 

Port 1025 is the default port number that the Teradata Database listens on. Virtually all Teradata Database systems listen on port 1025; it is very rare for a Teradata Database system to be configured to listen on a different port.

 

Which means that there is normally no need to override the default port number. You can simply omit it, or not specify it.

 

While the Teradata JDBC Driver does not support specifying the Teradata Database port number with a colon separator and following the hostname, the Teradata JDBC Driver does offer a DBS_PORT connection parameter for specifying the Teradata Database port number, in the rare cases that something other than port 1025 is used.

 

Here is a link to the documentation for the DBS_PORT connection parameter:

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_DBS_...