Connect Mysql Database via ODBC connector

Gopal_Desai
Gopal_Desai New Altair Community Member
edited November 5 in Community Q&A

Hello everyone,

i am new here and i would like to connect mysql database with rapidminer via ODBC. but it doesn't show me ODBC Bridge option. If anyone know, please help me out.

Tagged:

Best Answers

  • BalazsBarany
    BalazsBarany New Altair Community Member
    Answer ✓
    Hi,

    do you have a very good reason to connect via ODBC?
    The JDBC-ODBC bridge has been deprecated for years. It is much less reliable and efficient than a direct JDBC connection. 

    You should connect to MySQL with the MySQL or the MariaDB JDBC driver.

    Regards,

    Balázs
  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Answer ✓
    Hi,

    I'm afraid ODBC is not supported, for reasons outlined above. You will have to use JDBC.

    Regards,
    Marco

Answers

  • BalazsBarany
    BalazsBarany New Altair Community Member
    Answer ✓
    Hi,

    do you have a very good reason to connect via ODBC?
    The JDBC-ODBC bridge has been deprecated for years. It is much less reliable and efficient than a direct JDBC connection. 

    You should connect to MySQL with the MySQL or the MariaDB JDBC driver.

    Regards,

    Balázs
  • Gopal_Desai
    Gopal_Desai New Altair Community Member

    Hi,

    Thank you for the Reply. I am using also another application with ODBC. So for me it's easy to connect Rapidminer with my Database.

    Regards,

    Gopal

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Answer ✓
    Hi,

    I'm afraid ODBC is not supported, for reasons outlined above. You will have to use JDBC.

    Regards,
    Marco

Categories