*Sorry for my english, i'm french ^^*
I'm a beginner in Talend and i try to make a jobs to work with VtigerCRM.
So, we have 1 table in AS/400 Database and we want to synchronize datas with Vtiger (AS/400 is the main database) all the 24 hours.
So, with tVtigerCRM Module in talend, we can make one type of action per module (Insert, Update, Delete), and i want to use the right action at the right time (the picture is attached to the post).
I do not know how to determine, for each record, whether it has been modified, deleted (id that no longer exists), or it's a new one ...
I don't know if you really understood what I want to do, I can not explain well what I would like to do...
Thank you !
@Minos,you need to compare the As/400 DB sorce table with Target table then only you can figure out that the record is new or existing.
@Minos,you can do with tMap or tJoin..
please find the blelow links to
Finally I did something else, I've already imported all the data, and for comparison I'm just in the process. I was thinking rather to copy the bases on CSV files (12000 lines approximately it's not very heavy) then to check them using the module tFileCompare, the problem and that I would like to separate into subjob (update or insert) according to the answer of the tFileCompare, it is possible ?
@Minos,you can separate the flow since again you need to do lookup with target to derive new record or udpdated record.
Sorry I had another problem in the evening yesterday and I just corrected the problem...
I don't really understand how to separate the flow according to an entry condition in fact...
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.