Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

"[SOLVED] Cant connect to Teradata database"

Hi,

I am trying to connect to a Teradata database from Rapidminer.... when I click "Show Database Drivers"... I get a green light next to my Teradata driver (using an JDBC connector I found from their website and the URL prefix of jdbc:teradata://

....however, when I plug in the credentials into Manage Database Connections, it shows "Connection status Unknown"

Any thoughts on how to resolve this issue?

Find more posts tagged with

AI Studio

Databases

Accepted answers

All comments

homburg

Hi mccoydj2,

RapidMiner works with Teradata, their jdbc driver is just a bit special. It is split up into two jar files, one with the driver and another one containing a config file. Since both need to be part of the java class path both need to be set in the config dialog as well. In the section "Jar File" paste a string like this:
[tt]C:\rapidminer-studio\lib\jdbc\terajdbc4.jar,C:\rapidminer-studio\lib\jdbc\tdgssconfig.jar[/tt]
The driver also does ot support the standard port specification, it automatically connects to port 1025. So please do not set a port number, always leave these fields blank.

Cheers,
Helge

mccoydj2

Yup... that fixed it! Thanks for your help!