In my blogpost last week, I shared how, in just 5 minutes, you can expose MySQL, DB2, SQLServer, Oracle or SAP datasource as an OData API into Salesforce using Anypoint Data Gateway for Lightning Connect.
But let’s say what Data Gateway offers out-of-the-box is not a perfect fit for what you want to do.
Anypoint Data Gateway for Lightning Connect is a packaged cloud service that allows you to quickly and easily integrate data stored in legacy back-office systems with Salesforce. Using a simple point-and-click visual interface, you can access data from SAP, Oracle DB, Microsoft SQL, MySQL and others instantaneously from Salesforce. This ability to quickly connect diverse back-office systems eliminates the need to create separate design environments or to implement extensive training for Salesforce users,
Salesforce unveiled Lightning Connect with the promise of allowing you to expose the data stored in your legacy data source into Salesforce in real time, without needing any migration. The only requirement is exposing such datasource through an OData endpoint.
So you have your datasource on one end, and Salesforce supporting OData on the other. The question now is: how do you connect the dots?
Tired of googling and reading about OData without having a chance to play with it? Get happy then, this post is for those pragmatics like me that enjoy learning by doing rather than dealing with theory. If you enjoy the trial and error process, I can assure you that you won’t be disappointed.
What is OData?
Open Data Protocol (OData) is an open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way.
