topic tSalesforceOutput "Relationship mapping for upsert" parameters in Talend Studio

tSalesforceOutput "Relationship mapping for upsert" parameters

Anonymous — Tue, 28 May 2013 11:30:53 GMT

I can't get this to work. There are 4 parameters to input:
Column name of Talend schema
Lookup field name
Module name
External id name
But there is no description of what to enter or how to use it.
Account has a lookup to RB_Country__c: Country__c
RB_Country__c has an externalid field: ExternalId__c
Talend schema column Country__c contains the value of the RB_Country__c.ExternalId__c field.
What are the parameters and how to enter them?

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Anonymous — Wed, 29 May 2013 03:09:45 GMT

Hi,
Here is a component reference with scenario tSalesforceOutput and Setting up a Salesforce connection. Hope it will help you.
Best regards
Sabrina

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Anonymous — Wed, 29 May 2013 05:36:17 GMT

Hey is your problem solved?

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Anonymous — Wed, 29 May 2013 07:05:08 GMT

Thnx xdshi but it is not clear to me what a lookup module is. Is this a component I need in my Talend Job?
Do I enter all the names with quotes or without them? Just a simple example would be so helpful
AmparoEmmy: No I have not got it to work sadly..
This feature would be so helpful.

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

_AnonymousUser — Wed, 29 May 2013 11:41:56 GMT

Hi,
I got it to work for upserting Cases that have relations to existing Accounts and Contacts. Please note that Accounts and Contacts are somehow special in that they dont't use that "__r" extension like modern (or custom) objects / relations do. (Compare SOQL queries created by e.g. ApexExplorer to get that difference.)
That values I used are:
Column name of Talend Schema Lookup field name Module name External id name
ExtContactId "Contact" "Contact" "ExtContactId__c"
ExtAccountId "Account" "Account" "ExtAccountId__c"
Regards, N.

Re: tSalesforceOutput "Relationship mapping for upsert" parameters

Anonymous — Thu, 30 May 2013 10:03:03 GMT

Thanx AIN123. You're example lines helped a lot. Got it working with custom objects.