I'm trying to connect my existing database with salesforce via heroku connect. I was able to synchronize the two solutions.

However, I wanted to know how to do complex matching.

First I would like to create lead / account / opportunity from my other application, I have synchronized my objects however I don't know what is the right method for this type of problem.

For example, I have in my existing application a companies table and a company_contacts table, I would obviously like to link my company to my custom object account as well as create leads for each new contact from my company_contacts table and that they keep their relationships.

Do you have any examples on this kind of use case? Is this the right way to synchronize my salesforce with my existing database? Knowing that I have thought of another much less pretty solution the RULES of postgres in order to fold on the salesforces tables the changes made on my existing base.