How Does Fivetran Capture Deletes?

Question

How does Fivetran capture deletes from Salesforce?

Environment

Connector: Salesforce

Answer

In Salesforce, there are two types of deletes:

• Soft deletes
• Hard deletes

For more information, see Salesforce's documentation.

Fivetran fetches the soft-deleted records from Salesforce using the SObject Get Deleted API endpoint.

Once you soft-delete a record in Salesforce, it resides in the Recycle Bin for 15 days, after which the record is hard-deleted from the Salesforce database. Salesforce does not provide the option to fetch the hard deleted record.