The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
"[SOLVED] Cant connect to Teradata database"
Contributor I
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?
Tagged:
0
Answers
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