Reading Excel Write to Teradata Data Very Slow

private brands.knwf (7.5 KB)

Hello, I have different times were I would like to read in Excel data, and then write this data to a Teradata table. In Knime, my workflow runs very slow. It is about the same speed as if I import data into Teradata. Has anyone else had this issue, and does anyone have suggestions on how to improve performance. This task would take about 8 seconds in Alteryx but could take an hour in Knime.

In DB Writer on Advanced tab change Batch Size to 10000


Thank you that did work for this combination of nodes.

1 Like

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