Hi, We want to connect snowflake to our salesforce instance to get the data from snowflake to Salesforce. Can anyone please advise on how to do that? Any app exchange product or documentation. I am having hard time to find proper way do it? I contacted salesforce support, but they told me to post in the developer forums as some others might have connected and they can provide more information. Thank you!

Hi Everyone,
We are interested in using salesforce connect to connect to postgres db hosted on AWS. I understand my options to be the following:

• implement OData on AWS (build it)
• use a tool to help with OData on AWS (buy it). The 2 I have played are Skyvia and DataDirect Cloud
• use the Apex Connector Framework (build it)

I'm writing this post in the hope that someone else out here has already wrestled with these options and would be willing to share some advice. I have only had a quick play with Skyvia and DataDirect Cloud, and both seem to have issues...if results are not as expected, it is difficult to debug. Are these tools worth spending anymore time...can they be made to work with a little more persistence? Are there any similar products that are better?

As far as the 2 build options go....you're talking to a salesforce admin that can hack a bit of Apex, and psql, but that's about it....I have read the docs on apex connector framework and it seems feasible, but I have no idea how this would compare to building on AWS. So, it would be great if someone could provide a quick comparison on the differences to these 2 approaches. 

 

Thanks!!!

We're looking at Heroku Connect and were wondering what alternatives there are for bi-directional syncing of Salesforce and our Heroku postgres database.  Any suggestions for good tools you've used for this?