Page History

Issue 1 : How to update Salesforce using update source when there are no fields to map with the external Id External ID of Salesforce from database a Database table.

Description: This happens when you try to integrate from Salesforce to Database, Lets . Let us say there is no external id External ID of Salesforce to map with primary key of a table in db a Database. If so then, you cannot update status back to Salesforce.

Resolution : Create a Rule which would that will process data from Salesforce to Database along with Salesforce Id, Then AID. Then, add one more Rule and use update Update operation to bring back the Salesforce Id from database, By this way ID from the Database. By so doing, we can successfully update the status back to Salesforce.

Issue 2 : Can we map the external External ID of Salesforce with the primary key of a database Database table to update back the status of Salesforce.? 

Description : Lets say we have an external External ID field of order on Order object of in Salesforce (Order_external_ID__c) which a . A DBSync user would like to map it with the SeqNo (auto generated primary key and auto generated) field of a database Database table. So, whenever a new order in is inserted into database a Database, DBSync gets SeqNo to update back to Salesforce on success map that, in turn, will not be visible in Salesforce.

...

Resolution :  Since SeqNo field is an auto number in table of database so Database, we advise that you do not to advise to map it with external id of Salesforce as it does External ID of Salesforce. This is because, an auto generated ID can not hold the value we provide externally. You should only map the externalID ExternalID (Order_external_ID__c) to some other field in database then a Database. Then, after sync, you can get the field value that can be used to update back to Salesforce.

...