Creating relationships between objects in your Heroku Connect database

Issue

Salesforce inherently offers a method by which relationships between objects are reflected. These relationships are then synced to your database along with the objects. So, what happens if you need to create these relationships in the database and have them synced to Salesforce?

Resolution

As long as you are only needing to create simple relationships (a parent record and a child record), this is possible through one of a few methods.

  • The first method assumes that the record has already been synced with Salesforce and has an SFID.
  • The second method assumes that you do not have the SFID, which might happen if the record was just created.