Append Data option in Database Output block

indranildatta · May 20, 2011 7:34AM

Hi,

Is there an option to be able to append data to an existing table in a database using the database output? I couldn't find any in the configuration section, but it would be good to know if there is a way to do this?

Cheers!
Indranil.

chris · May 20, 2011 8:10AM

There is no option at the moment, however you should be able to do the appending before exporting the data. In DataManager, add a Database source and select the table that you want to export too. Connect this source to an "Append" operation and append it with the new data. Finally connect this to the "Database export" block. If you need to do this on a scheduled basis you should connect a "De-duplicate" operation prior to the export.

indranildatta · May 20, 2011 8:13AM

Thanks Chris. Anything in the pipeline on this?

Cheers!

steve · May 20, 2011 9:46AM

Nothing planned yet. I've reclassified this as an idea.

Welcome!

Categories

Ideas Parade