Import csv data in MySQL db

Hello,

I have about 30 csv files on my computer which are updated daily. I would like to write these once a day into a MySQL database.
I have configured the CSV Reader with desired transformation and successfully connected to the database with the MySQL Connector.

But now I can’t get any further. How can I now write the created table of the CSV into the database?
How can I set when and how often KNIME should automatically write the CSV data to the database?

@0x0 you can use the KNIME database nodes to upload your data and create tables in MySQL

That would be a task for the KNIME server or the new:

1 Like