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