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

2 Likes

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.