Export SQL data to PostgreSQL using Knime

sandrofdigital · January 15, 2021, 10:22am

Good morning, I’m new to knime and I’m learning by researching a lot on the internet, I need to export the data from the SQL database to PostgreSQL. Can someone explain to me which node to use to insert in PostgreSQL

mlauber71 · January 15, 2021, 10:33am

@sandrofdigital welcome to the KNIME forum

You could use the:

(see the sample workflows linked from the page).

A collection about KNIME and databases you can find here:

sandrofdigital · January 15, 2021, 4:55pm

thanks, i will study the content and if i need help i ask for help again

ipazin · January 18, 2021, 5:23pm

Hello @sandrofdigital,

here are two topics I managed to dig (older but might help) where I share my experience doing DB ETL with KNIME:

Anyways this is really a broad topic so feel free to open up a topic if more questions.

Br,
Ivan

sandrofdigital · January 18, 2021, 8:41pm

Hello @ipazin I thank you for your tips, I’m already reading and watching the video, thanks man

system · January 25, 2021, 8:41pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.