🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

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!

Find more posts tagged with

AI Studio

Accepted answers

All comments

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