Openprise handles deleted records differently depending on which system of record holds the data.
Salesforce has two methods of deleting records: a "soft" delete, and a "hard" delete. A soft delete marks the record as deleted and moves it to the user's recycle bin. When Openprise imports data from Salesforce, it pulls these soft-deleted records and uses the attribute "OPIsDeleted" to identify them. If an existing record in Salesforce has been imported into Openprise, and then later soft-deleted, Openprise will know about the deletion when the updated record is re-imported into Openprise. However, if the record was hard deleted (ie. the user emptied their recycle bin) BEFORE Openprise had a chance to re-import the record, Openprise will never know the record was deleted. For this reason, it is recommended that the Salesforce data sources are periodically purged and re-imported. Please note: The authentication credentials used when Openprise communicates with Salesforce controls access — so if the access controls allow access to everyone's recycling bin, Openprise will see all soft-deleted records. However, if the access controls limits access to some user's recycle bins, Openprise will not have access to those user's soft-deleted records.
Marketo only has hard deletes, but their API tells us about deleted records, so Openprise captures OpIsDeleted information as records are deleted in Marketo. However, records that are merged in Marketo are not considered as "deleted" (they're just purged from Marketo) and therefore, with a few merges, Openprise can become out of sync with Marketo. Because of this, is a good idea to purge and reimport your Marketo data source periodically (with timing dependent on how frequently records are merged).
Eloqua only does hard deletes. However, Eloqua has no APIs to delete records nor any APIs to retrieve deleted records. So Openprise will become out of sync if any records are deleted in Eloqua directly. Oracle technical contacts recommend their users to never delete records, but rather use an attribute to mark records as deleted.
Pardot – Contact Openprise support for details on how Pardot manages deleted records.
Dynamics365 – Contact Openprise support for details on how Dynamics manages deleted records. Dynamics365 does not have APIs to manage deleted records, so periodic purge and re-import is suggested.