One thing I see as a huge advantage of the KNIME software is its diverse technology ecosystem. This allows you - among other things of course - to connect to all major databases and data warehouses, so you can blend different data types from any source 
In case you need a refresher on our most common connectors, take a look at our Connectors Cheat Sheet 
Download here: https://www.knime.com/sites/default/files/2022-11/CheatSheet_Connectors_A3_Web.pdf