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

Connecting Via ODBC

macctenmaccten Member Posts: 28 Contributor II
edited November 2018 in Help
Hi All

I wish to connect to teradata warehouse using rapid-miner
I see on the read database operator that you can connect to any database using a URL
Is it possible to connect using existing ODBC setups
So for example we have other programs like MS Access that can connect using existing ODBC connections by just pointing to it in the ODBC manager
Does rapidminer have this ability

Thanks for your help

Answers

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn
    Rapidminer is written in Java and so uses JDBC rather than ODBC for connection.  This means that if you wish to connect via an ODBC driver you would need to use the ODBC:JDBC bridge driver (which RapidMiner has installed) however this means that the ODBC driver must be installed on the client machine for it to work. 

    In the case of Teradata though, I think it comes with a JBDC driver which you can download alongside instructions on how to make connections here: http://www.razorsql.com/docs/connection_teradata.html

    Hope that helps!
  • macctenmaccten Member Posts: 28 Contributor II
    Hi JEdward

    Thank you for your prompt reply
    I am only going to use this on a local machine which already has the ODBC driver
    Could you tell me what i fill in for the host and the IP Address
    Excuse the ignorance of the question but i have very little experience with Java and ODBC uses IP Addresses in our setup

    Thanks
Sign In or Register to comment.