Upsert with MySQL

[For Windows]

To use an upsert for a MySQL target with Pervasive Data Integrator, you'll need to adjust one of the detailed settings in the driver. Navigate to the ODBC drivers from the Windows Control Panel. Select "Configure" for the DSN created for MySQL, and check the "Return matched rows instead of affected rows.

This post is replicated from http://my.opera.com/walkerca/blog/2010/12/18/upsert-with-mysql.