Activity Forums Salesforce® Discussions Salesforce Sharepoint Bi-Directional Integration

  • Manpreet

    Member
    March 23, 2017 at 1:44 pm

    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="[email protected]; 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 [email protected]; 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>

    _______________________________________________________________________________________________________

     

    rtaImage

    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.

  • Sai

    Member
    April 6, 2017 at 11:09 am

    Hi Manpreet,

    Here my Requirement is i shlouldt any use Third part tools or install any apps in to local system its shld run through cloud and here i have doen up tp 90 parcent the only this is its not saving to SHarepoint FLoders are getting Creted Bro .... i request you to Help me out in this Issue

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos