I have a knime workflow where I insert some data into an Oracle DB. The data comes from a Table Creator and have the number of columns and format suitable to the table in question, so I can have a DB Writer to persist it. That is very simple and works fine.
The question is, is it possible to have a sql script generated from that workflow? I need to have this flow replicated in other schemas or DBs and used by teams that does not have access to Knime directly.
The example workflow is depicted below, and is also available as an attachment.
it is not possible to convert this.
However, we are logging the SQL we are executing in the database in the KNIME log file. So it should be possible to get the SQL the DB Writer used by extracting it from the log.