Help with streaming

Hello Knime World,

I and very basic-level and (guess what?) I need your help.

I need to filter a DB2 table with data coming from an Oracle table.

Apparently, a very “classic” join. But I understand Knime will not accept to join tables living in different databases.

I have read/write permissions in Oracle and only read permission in DB2.

Knime lets me extract data from DB2 and write a table in Oracle, but the DB2 table has dozens millions rows and Knime is installed in a machine with limited resources: my workflow will stop with a missing space error. In order to test my workflow, I artificially filtered my query in DB2 and everything went fine - see picture Knime_1.

Digging a little deeper, I discovered the streaming executor, so the natural following step was to create a component with “simple streaming”, as a way to avoid writing any data inside Knime - see picture Knime_2.

And here is the problem: while te “no-stream” workflow works as expected, its “streaming” sibling will stop with a “DB Writer failed: data” error - see picture Knime3 and picture KnimeLog.

Still, the desired table is created inside Oracle (and it is populated as expected!!), but my workflow will stop and let me down there.

So, same workflow: no-streaming is OK and streaming is KO… is this even possible?

Can you help me understand what I m doing wrong? Because I know it’s my mistake…

Or maybe you could suggest different approaches?

Thanks everyone!