We have data integration Job for SQL SERVER - SFDC using Talend data integration tool.
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
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
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 !