Connecting to Teradata

tansri

Hi,

I am trying to connect the community edition of RapidMiner 5.3 to a Teradata appliance using the Tools>Manage databse Drivers option to import the JAR file, but I keep getting the following error when I test the connection:
"No suitable driver found for <IP address><Database schema name>"

Request urgent help.

Thanks!

aborg

Hi,

  I am not familiar with Teradata, but according to their homepage you should use something like this:

jdbc:teradata://DatabaseServerName

. Do you have jdbc:teradata:// as a prefix?
Cheers, gabor

deepeshj

Hi.

 I am using jdbc:teradata:// as the prefix but still getting the error "No suitable driver found for jdbc:teradata://<DB IP>/DB_Schema. Please help.

Thanks

IngoRM

Did you actually download and install the JDBC driver for Teradata: https://downloads.teradata.com/download/connectivity/jdbc-driver

It is not sufficient to only change the prefix, you also need to install the driver so that RM can use it.  Here is more information on this: https://docs.rapidminer.com/latest/studio/connect/database/ and https://docs.rapidminer.com/latest/server/configure/connections/creating-db-conns.html

Hope this helps,
Ingo

deepeshj

@IngoRM

Yes, I have the placed the 2 jar files for this purpose at the designated path, as mentioned in the post https://community.rapidminer.com/discussion/32035/how-to-connect-a-teradata-database-to-studio/ as well as populated the other fields. I get the error "No suitable driver found for jdbc.teradata//<ip>". What is it that I'm missing out?

Marco_Boeck

Hi,

This is outdated since Studio 9.3.
Please see here for how to do this now (MySQL is used as an example, but it works for any JDBC driver): https://docs.rapidminer.com/latest/studio/connect/database/mysql-connector.html

Regards,
Marco