I am new to AWS so please be easy on me..
I have a PostgreSQL DB hosted on Amazon RDS and would to expose few tables of the PostgreSQL database through OData service. The goal is to use these PostgreSQL tables as external objects in salesforce.
How do I expose these AWS hosted PostgreSQL tables as OData service which can be accessed from Salesforce.com using lightning connect ?
Any out of the box AWS capability or a 3rd party product which can be used to enable OData layer on the top of these PostgreSQL tables ?
Appreciate any help,
Best Answer
Depending upon your "build" vs. "buy" perspective... if you're interested in building your own solution, check out this Salesforce project:
https://developer.salesforce.com/blogs/developer-relations/2015/05/introducing-lightning-anydb-connector-data-democracy-fueled-salesforce-lightning-connect.html
If you're interested in "buying" instead, we are one of a handful of vendors who provide OData capabilities for various sources without any modification or changes to the underlying data source. We can definitely OData-enable Postgres in RDS. We've used this to integrate Oracle and SQL Server data on RDS into Salesforce with Salesforce Connect. We've also successfully tested integrating Postgres running on Compose.io, which is now part of IBM.
We offer a SaaS service, Datadirect Cloud: https://www.progress.com/cloud-data-integration. You can trial this at no charge, by simply filling out a form. Fully functional, 30 days.
We also offer a product that you can host yourself on your choice of infrastructure. (It requires an Intel/linux/java system.) It's called Hybrid Data Pipeline. https://www.progress.com/hybrid-data-integration. Similar functionality - dynamically add OData capabilities to selected data sources.
You can trial this, too, by filling out a form and downloading the installer, but it would involve having a system to install it on. A little more work. FYI - it seems that Amazon's new Lightsail virtual server offering is an easy way to trial Hybrid Data Pipeline. You have to use the largest system, though.
Any questions...