We are trying to get the data from the client to Knime which is currently stored in MariaDB.
The client provided us with the following info: DB server - MariaDB 10.6, host, user, pass, database, table.
The problem is that Knime doesn’t have MariaDB Reader node built in and as I understand from my research, that MySQL Reader with MariaDB drivers should be used. However, I was not able to make it work…
Can somebody provide some guidance what could be the best way to connect to MariaDB in my case? Should I install some drivers?
Yes, you’ll need to download the MariaDB JDBC drivers and register them with KNIME. Here’s the official KNIME page: KNIME Database Extension Guide
I once connected to my MariaDB with the MySQL drivers and it worked, so you can use those if you need more spice in your life. They’re not guaranteed to work though, so don’t do that for production workflows!
Hi @wytux10 , you should be able to connect to MariaBD using the MySQL drivers since MariaDB was forked from MySQL. Like @Thyme , I have done it too.
However, of course there are differences between the 2, and you may not be able to use some MariaDB features that MySQL does not support, but for basic queries and operations, it should be fine.
I tried using MySQL connector with regular drivers and it actually worked! Thanks so much! Im sure that database extentsion guide will come in handy in the future.
