"[SOLVED] Cant connect to Teradata database"

mccoydj2
mccoydj2 New Altair Community Member
edited November 5 in Community Q&A
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?

Answers

  • homburg
    homburg New Altair Community Member
    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
    mccoydj2 New Altair Community Member
    Yup... that fixed it! Thanks for your help! :)