Connecting to Teradata
tansri
New Altair Community Member
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!
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!
Tagged:
0
Answers
-
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
0 -
Did you actually download and install the JDBC driver for Teradata: https://downloads.teradata.com/download/connectivity/jdbc-driverIt 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.htmlHope this helps,
Ingo
0 -
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?
0 -
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,
Marco0