Contents
How does Lightning connect work with external data?
To connect to an external data source, Lightning Connect uses the Open Data Protocol (OData) version 2.0. I joined several sessions and met folks from across the Salesforce.com platform to talk OData integration.
How to connect to a database using OData?
If you want to connect securely to an on-premise database using OData, here’s a related tutorial on odata.org using DataDirect Cloud to instantly produce OData from databases behind your firewall using DB2 as an example, but the same steps apply to SQL Server, Oracle, Postgres, MySQL, OpenEdge, Cloudera or HortonWorks.
How does Lightning connect with Salesforce external object integration?
The data gets fetched directly in real-time from source systems on demand without having to physically move or duplicate the data.
Is the OData cloud compatible with Salesforce platform?
OData is not limited to database connectivity, and includes a rich ecosystem or producers; and Progress Software’s DataDirect Cloud supports both on-premise databases behind a firewall and even cloud data sources including Google Analytics, Salesforce Platform (for cross org connectivity), Marketo or Eloqua.
How to use lightning connect with SQL Server?
Lightning Connect truly is a game changer when it comes to easily integrating external data with Salesforce. In this article I am going to show you how simple it is to access real-time data from a SQL Server Azure database and display it seamlessly in Salesforce using OData and Lightning Connect.
How does Lightning connect work with Salesforce ERP?
Lightning Connect enables your users to view and search records that are stored outside Salesforce, such as data in an enterprise resource planning (ERP) system. Instead of copying the data into Salesforce, which would be redundant and inefficient, use external objects to reference the data and access the data in real time via Web service callouts.