Heroku connect does physical delete in Heroku Postgres during 'isDeleted' flag set in Service Cloud

[Karthikeyan-Jagadeesan]

Heroku connect (https://devcenter.heroku.com/categories/heroku-connect) is used to replicate a set of service cloud objects in the Heroku Postgres database. When a record is deleted from Service Cloud object, Service Cloud does soft delete by internally setting 'isDeleted' flag to true. This flag is visible when the record is retrieved through out of the box Salesforce APIs. However, Heroku Connect physically removed the record from postgres database (https://devcenter.heroku.com/articles/heroku-connect-database-tables). This causes issues to the downstream system during record replication. Downstream systems are unable to detect the deletion (as records are physically deleted) during scheduled polling and retain the deleted records within their application.