Connect Mysql Database via ODBC connector

Question

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.

BalazsBaranyRM · Accepted 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 · Accepted Answer

Hi,

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

Regards,
Marco