Replacing Salesforce Dataloader with Talend - Missing SourceId functionality

[ThinkingACloud]

We are currently trying to move from using Dataloader to Talend for various activities. But there is a key capability the Salesforce dataloader has that we seem to be unable to replicate in Talend. 

Consider a CSV with only 2 columns. We want to insert these rows into Salesforce but only the Name column will be inserted.

SourceId is not a field in Salesforce and so will not be included in the insert.

For this table there is validation such that if Name is blank the upsert will fail.

When we use Salesforce Dataloader to upsert this data the tool automatically includes the SourceId column in the result success and failure files

The following picture shows the source CSV and the success/failure files generated by Salesforce Dataloader

 

In the success file Dataloader has automatically linked the Target Id to the SourceId which was not sent to Salesforce. For the error file it has shown each error on the same row as the SourceId

We want to do the same with Talend but we are unable to find a way to relate the source ids to the id or errors created during the upsert to Salesforce.

(Continued in next post due to character limit on this forum)

[ThinkingACloud]

If we could do this in Talend it would really help for the following reasons:

1. Many objects cannot have external Ids added and so it allows us to easily build relationships for these
2. If we are using a staging database we can add the target id into the table which opens up more capabilities
3. When upserting objects with polymorphic Ids if we use external ids we need to split the load per object. If we do not use external ids we can load the rows all at once.

When we do something similar in Talend there seems to be no way to relate the SourceId and targetId fields for the successes and no way to link the SourceId to the errors.

Is there anyway to do this using Talend?