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
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 ?
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.
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.
Add the steps involved:
Also, for convenience, here is the link to the JAR files:
and default path to the jdbc folder on desktop:
C:\Program Files\RapidMiner\RapidMiner Studio\lib\jdbc
>>> 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: