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!!!