Enabling hard delete using the Salesforce connector

Henry Simms
Henry Simms Administrator
edited February 5 in Tips and tricks

When deleting data from a Salesforce object you can tell the API to hard delete the data so that it does not go in to the recycle bin and therefore can't be recovered. It's also possible to do this with DELETEs in the Export step using the native Salesforce JDBC driver. Here are the steps:

  1. In your Salesforce External System, add the custom connection property EnableHardDelete=true
  2. Hard delete also requires the Bulk API to be used, so the number of rows to be deleted must be greater than or equal to the BulkLoadThreshold connection property value for Hard Delete to work. The default value for BulkLoadThreshold is 4000, so if you want to hard delete on smaller volumes (or for everything), set BulkLoadThreshold to a low value or to 0.
    image.png
  3. Finally ensure that the Salesforce user account you're using has the permissions to perform a "Bulk API Hard Delete".
    image.png

You should then be able to use this External System to carry out hard deletes from an Export step:

image.png

Hopefully it should go without saying, but use this setting with caution as any deletions will not be recoverable!

Tagged:

Categories