You need to sign in to do that
Don't have an account?
enossir
Informatica, The ID field in salesforce.com object must be mapped for update.
So we pull data from SAP quotes/sales and push it into a custom object in SFDC.
How we reference the records in SFDC to the ones in SAP is via the SAP sales doc #. In fact when you view this is Informatica you can see in both SAP and SFDC the Sales doc. and SAP_Sales_Doc__c and keys.
Now theres another field ORCL in SAP it's a boolen value true/false (or X/blank) and i need to push that to the related records in SFDC. The problem is when i try to us data synchronization it tells me "The ID field in salesforce.com object must be mapped for update." How the hell am i supposed to map to this field when there's nothing in SAP that references that.....the only reference to records i have is via the SAP sales doc.
How we reference the records in SFDC to the ones in SAP is via the SAP sales doc #. In fact when you view this is Informatica you can see in both SAP and SFDC the Sales doc. and SAP_Sales_Doc__c and keys.
Now theres another field ORCL in SAP it's a boolen value true/false (or X/blank) and i need to push that to the related records in SFDC. The problem is when i try to us data synchronization it tells me "The ID field in salesforce.com object must be mapped for update." How the hell am i supposed to map to this field when there's nothing in SAP that references that.....the only reference to records i have is via the SAP sales doc.
create a new external id field ( you can use SAP id or any uniquer field ) and use this field for both insert and update