Connect Mysql Database via ODBC connector

Gopal_Desai
Gopal_Desai New Altair Community Member
edited November 2024 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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answers

  • BalazsBaranyRM
    BalazsBaranyRM 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

  • BalazsBaranyRM
    BalazsBaranyRM 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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.