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?