How to use parent's externalID for upinsert operations on Salesforce objects that have child objects

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
FFONTES
Posts: 2
Joined: Wed 14 Feb 2018 17:50

How to use parent's externalID for upinsert operations on Salesforce objects that have child objects

Post by FFONTES » Wed 07 Mar 2018 00:16

We are looking for an approach that allow us to exclusively use the External Ids instead of having to retrieve the Salesforce object Ids before we can do the upinsert operation. Could you please help indicating how to accomplish this using the Salesforce SSIS Data flow Components?

Below you find some background info:
For the Salesforce objects we are populating with data, all of them have an External ID field that is being used.The External ID is generated by the source table. We are doing upinsert operations on Salesforce objects that have child objects. We would like to exclusively use the External ID of the parent object when creating the child objects.

For example, the default Salesforce object Opportunity can have one or more OpportunityLineItems. A OpportunityLineItem has a a foreign key relationship to Opportunity. On the Opportunity we have a custom field EID__c.

If we were to insert new OpportunityLineItem objects, within the Devart Salesforce Destination component, and we have the Opportunity Ids, we can map the Opportunity Id (as the input column) to the OpportunityId destination column which is already exposed as a field. Instead, we would like to leverage the relationship that exists between the Opportunity and OpportunityLineItem. We would like to map the External Id (EID__c) of the opportunity (as an input column) to the Opportunity.EID__c (as the destination column).

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: How to use parent's externalID for upinsert operations on Salesforce objects that have child objects

Post by Shalex » Wed 07 Mar 2018 19:09

Please refer to viewtopic.php?t=36569. Does this help?

Post Reply