We have data integration Job for SQL SERVER - SFDC using Talend data integration tool.
SFDC environment:
Full sandbox Account
We have two custom object.
In that, Master-Detail relationship from Order_item__c to Order__c
Order__c and Order_item__c
External id : is composition of two column
that is
ext_ID__C IS concat(salesorder,salesorderline)
Detailed structure of Order__c and Order_item__C is
Schema of Order__c
Order__c ext_Id__c - External ID
Customer__c
Status__c
Order_Date__c
Req_Ship_Date__c
Salesperson__c
Customer_PO_Number__c
SYSPRO_Entry_System_Date__c
Inter_Warehouse_Sale__c
Schema of Order_item__c
Order_Item__c Order__c
Order_Line_Number__c
Warehouse__c
Quantity__c
Price__c
Inventory_Item__c
Disp_Qty__c
Order_Value__c
Ord_Qty_In_Each
Disp_Qty_In_Each__c
SYSPRO_Id__c
Dispatch_Date__c
Invoice_Date__c
Scenario is:
For Outputting the Order line item : The problem is we need to upsert the external ID in Order_Item__c. But to upsert this we need to go find the Sales force Order(which is available in the SQL SERVER view) first then traverse down to the Order Line Number. We are finding difficulty at the time of traversing into Multiple Line items for order.
We would like to Understand How do i UPSERT into Multiple Line item entries using Order_item__c and what will be the external Id in this case so that it does not allow duplicate as well.
Any help on it would be much appreciated !
Thanks in advance !