function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Hithesh SaicharanHithesh Saicharan 

Postgres(NodeJS) integration with chatter

We are having two modules one is developed in salesforce and another is Node JS(Postgres DB). So wee need to send some data from Node JS to chatter in salesforce and also vice versa. What is the best approach to do this implementation?
Best Answer chosen by Hithesh Saicharan
SwethaSwetha (Salesforce Developers) 
HI Hithesh,
You can use a third-party tool like Zapier to integrate between chatter and Salesforce.
See https://zapier.com/apps/chatter/integrations/postgresql
Below are steps that this third party tool claims:
Step 1: Authenticate Chatter + PostgreSQL.
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
Step 3: Choose a resulting action from the other app.
Step 4: Select the data you want to send from one app to the other.

Incase you want custom code, you need to write using Connect API (https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/quickreference.htm). There are no direct code snippets available in this scenario over the internet for this integration.

If this information helps, please mark the answer as best.Thank you

All Answers

SwethaSwetha (Salesforce Developers) 
HI Hithesh,
You can use a third-party tool like Zapier to integrate between chatter and Salesforce.
See https://zapier.com/apps/chatter/integrations/postgresql
Below are steps that this third party tool claims:
Step 1: Authenticate Chatter + PostgreSQL.
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
Step 3: Choose a resulting action from the other app.
Step 4: Select the data you want to send from one app to the other.

Incase you want custom code, you need to write using Connect API (https://developer.salesforce.com/docs/atlas.en-us.chatterapi.meta/chatterapi/quickreference.htm). There are no direct code snippets available in this scenario over the internet for this integration.

If this information helps, please mark the answer as best.Thank you
This was selected as the best answer
Boris FrankBoris Frank
Hello! You can take a look at Skyvia (https://skyvia.com/data-integration/integrate-salesforce-postgresql). With Skyvia you can easily perform bi-directional sync of PostgreSQL and Salesforce.