"[SOLVED] Cant connect to Teradata database"
mccoydj2
New Altair Community Member
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?
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?
0
Answers
-
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,
Helge0 -
Yup... that fixed it! Thanks for your help!0