Salesforce Sharepoint Bi-Directional Integration

Hi Sai,

To access Salesforce we need any ADO.NET driver for this. In our sample we use the well-known RSSBus Salesforce driver referred as System.Data.RSSBus.SalesForce in the configuration file (see below). The driver must be installed on the computer, that runs the Cloud Connector, usually somewhere in the corporate network, e.g. on Windows 7.

Alternatively you can use the DEvArt ADO.NET data provider for SalesForce found here:

http://www.devart.com/dotconnect/salesforce/

The Cloud Connector is configured as follows:

_______________________________________________________________________________________________________

<?xml version="1.0" encoding="utf-8" ?>
<connection xmlns="http://www.layer2.de/schemas/cloudConnections" interval="60" version="1.2" enabled="true">

<dataEntities>
<dataEntity name="Salesforce"
provider="System.Data.RSSBus.SalesForce"
connectionString="User=myUser@myDomain.com; Password=myPassword;
Access Token=myAccessToken"
primaryKey="Id"
selectStatement="SELECT * FROM Account">
</dataEntity>

<dataEntity name="SharePointDestination"
provider="Layer2.SharePoint.Provider"
connectionString="Data Source=https://myDomain.sharepoint.com/sites/mySite/; Initial Catalog=myList;
Authentication=Office365; User Id=myUser@myDomain.onmicrosoft.com; Password=myPassword;"
selectStatement="">
</dataEntity>
</dataEntities>
<fieldMappings autoMapping="false" >
<fieldMapping>
<field entity="Salesforce" name="ID"/>
<field entity="SharePointDestination" name="Title" />
</fieldMapping>

<fieldMapping>
<field entity="Salesforce" name="Name"/>
<field entity="SharePointDestination" name="Company" />
</fieldMapping>

<fieldMapping>
<field entity="Salesforce" name="Phone"/>
<field entity="SharePointDestination" name="WorkPhone" />
</fieldMapping>

<fieldMapping>
<field entity="Salesforce" name="BillingCountry"/>
<field entity="SharePointDestination" name="WorkCountry" />
</fieldMapping>

</fieldMappings>

</connection>

_______________________________________________________________________________________________________

Refer to this Link also.This is an example of integrating SharePoint with Salesforce Chatter. The SharePoint instance could be local or in a datacenter as could the Salesforce instance -- in this case we're using a hosted SharePoint instance and a hosted Salesforce instance.

Thanks.