Hi There,
    I am trying to use Talend to read a XML file containing software installations on a machine and update the information to a MYSQL database. However, I would like to generate the XML file daily but would like Talend to create new row in the database (with the software installation version number incremented by 1) if and only if the information submitted by the XML is different to what is stored in the database based on multiple columns. How can I do that using Talend?

Example:
Say the XML file contains following information:
Software Name, Software Installation Path, software Version, Last executed date, Installation date

And the information is stored in a MYSQL database which has all the above fields as column PLUS additional column called “Software Inventory ID”, “Software inventory Version”, “machine Name” etc. With “Sofware Inventory ID” and “Sofware Inventory Version” as database primary key

Now I want to use Talend to update / insert (if doesn’t exists) a row in the database table only if software Name, software Installation path, software version (all 3) are different (for a machine) in the XML file compared to what’s stored in the database

Example data
Software Name, Software Installation Path, software Version, Last executed date, Installation date
Testsofware,C:\TestSoftware\TS.exe,1.0,20110712,2011,0101