Showing posts with label Lightning Connect. Show all posts
Showing posts with label Lightning Connect. Show all posts

Wednesday, 1 April 2015

External Data Sources with Lightning Connect OData 2.0

External Data Sources

Create external data sources to connect Salesforce to outside systems, such as SharePoint or any other data base.

Prerequisite
1) XML file for External Data Source



Step 1:- From Setup, click Develop | External Data Sources.


Step 2 :- Click New External Data Source, or click Edit to modify an existing external data source.



Step 3 :- Complete the specific steps for your data source.


Step 4 :- Click Validate and Sync, and confirm that the connection gets a successful status

Step 5 :- Optionally, select tables and click Sync to do the following for each selected table




Link :- https://www.youtube.com/watch?v=4aChUHMI5I8


Thursday, 1 January 2015

New Relationship Data type (External Object and Data source)



External objects are similar to custom objects, except that they map to data located outside Salesforce. Each external object relies on an external data source definition to connect with the data outside Salesforce. Each external object definition maps to a table that contains the data, and the object fields map to accessible table columns. The data in the external table can be searched and referenced in Salesforce using custom tabs and federated search.


1) Each organization can have up to 100 external objects.


External Lookup Relationship could now be setup between external objects and Salesforce object.
External Object - They are same as custom objects but used to map to data located outside Salesforce. External object take data from External source and External source obviously has its own DB. 

To create external object : From Setup, click Develop | External Objects.
To create external Data source : Develop | External data source