Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Connect Mysql Database via ODBC connector

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.

Find more posts tagged with

AI Studio

Databases

Connections

MySQL

Read Database

Accepted answers

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

All comments

BalazsBaranyRM

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