Connect Mysql Database via ODBC connector

Gopal_Desai

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

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

Hi,

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

Regards,
Marco

BalazsBaranyRM

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

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

Hi,

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

Regards,
Marco