ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I have been using the VIMP software to import from my odbc DB to a mysql and it work fine to the point where it populates the data when the target table is empty, but i want to be able to import a fresh instance of data at every scheduled refresh over existing data. The new data does not overwrite the data in the existing db target.

Help please.

Many thanks

Dave

You need to specify update key and set data transformation type to

Add new update existing records

Mike