Allow only update to Salesforce table

[former_member198401]

Hi All,

I have a requirement where we need to send only Updates to the Account table in Salesforce. I can use a Table comparison and Map Operation to achieve this but when I use Table comparison it doesnt shows the SFDC datastore to select the Target table. So my only option will be

Source>Query_Transform>Map Operation>Salesforce Target table(Account)

What opcode shall I set in Map operation Transform to achieve this.

How can we make sure that only updates go to the Account table in Salesforce

Any inputs would be appreciated and rewarded with points.

Regards

Arun Sasi

[former_member187605 · Accepted solution]

Yes, Map_Operation is the solution. Discard all opcodes except Update.

[former_member198401 · Accepted solution]

Thanks Dirk!!

[former_member198401 · Accepted solution]

Hi Dirk,

I tried with the map operation transform with the opcode Update>Update and Normal>Update as well but its not updating the Salesforce table.

If we dont use the Map Operation transform then Salesforce adapter does an upsert based on an external column and update is seen on the target Salesforce table.

Any further thoughts

Regards

Arun Sasi

[former_member198401 · Accepted solution]

Hi Dirk,

I have raised a Ticket with SAP Support Team.

Let me know if you have any thoughts

Regards

Arun Sasi

[former_member192448 · Accepted solution]

Hi Arun

The solution here was to change the External ID for Salesforce.

Salesforce allows you to mark up to 3 fields as External IDs and these fields must be text, number or email field types. Values in these External ID field must also be unique and you can also determine whether or not values are case sensitive.

This solution is documented in the KBA 2121780

Regards

Charles

[former_member198401 · Accepted solution]

Thanks Charles!!

This works

Regards

Arun Sasi