For more technologies supported by Talend, see Talend components.
This scenario upserts the collection blog as an existing record has its author changed and a new record is added. Before the upsert, the collection blog looks like:
1;Andy;Open Source Outlook;Open Source,Talend;Talend, the leader of the open source world... 2;Andy;Data Integration Overview;Data Integration,Talend;Talend, the leading player in the DI field... 3;Andy;ELT Overview;ELT,Talend;Talend, the big name in the ELT circle...
Such records can be inserted to the database following the instructions of Creating a collection and writing data to it.