Lightning Connect

Its a time to connect salesforce to other system for data perspective then easiest option provided by Salesforce is lighting connect. 

It connects and access data from external sources with point-and-click simplicity. It Incorporate data from legacy systems (SAP, Oracle, Microsoft, etc.) in real time in Salesforce application objects. 

How to set-up : 

There are two type of entities which need to setup in order to work on lightning connect. 

1. External Data Source 

2. External Object 

Goto Setup>Build>External Data Source and Create a new External Data Source which will keep reference of an external hosted data source. 

1. Select option "Lightning Connect: OData 2.0" then Salesforce connect to external data server. The external data must be exposed by a service that uses Open Data Protocol (OData) Version 2.0. Such a service is called 

an OData producer.               

2. Select identity Type "Anonymous" then no authentication is required but if you select other option than it will ask authentication from different ways like Oauth2.0, password authentication. 

In my example I have put one OData supported data and then select Anonymous identity types and put URL with 

http://services.odata.org/V2/(S(z03hdcomixoupwtkwk3as00w))/OData/OData.svc/ 

After creating this external Data Source, we need to create External Object. For this I have clicked on Validate and Sync button and I was redirected to next screen where I found table with option to select object data I wanted to inherit. Once I select object and click on Sync option, external Object got created.

Here I have selected two objects "Categories" and "Products" so resulting two external objects have been created.

These External objects can not be modified within Salesforce but these synced with external system. 

we can read the data either via visiting record file or applying SOQL. This data does not count against Salesforce storage limit. 

Here is data :