How to Update Existing Records During Export into Database Using JDBC


If you have a workbook which imports database tables through JDBC, update the existing rows in the database table instead of inserting new rows.

Currently, you can easily insert the new rows into the database table using JDBC export, if the workbook has a computation which prepares a delta of changed rows (either new or existing rows) in filtered into two separate sheets.


To update existing rows, you can either prepare a sheet with the desired data and choose to overwrite the table in the export job configuration, or manipulate the data on the target table after only the delta is exported.