none
how to connect SalesForce CRM server using SSIS connectors.. RRS feed

  • Question

  • Hi Friends,

    I have a small requirement, 

    I want to connect Salesforce CRM Server from the SSIS..

    Is there any Open Source connectors was there to connnect..

    Are there any other way to connect to the salesforce using SSIS....

    Please help me on this..

    Saturday, August 27, 2016 2:18 PM

Answers

  • Hi Kapil,

    As far as I know, Microsoft has not provides Open Source connectors for connecting to Salesforce in SSIS.

    According to your description, I found a case in Salesforce’s forum that people are discussing the similar requirements. According to the discussion, most people suggest use a third-part components to retrieve data from Salesforce side. Please take a  reference.

    Since this is a third-part component, so please use it carefully.

    In order to avoid some issues, I suggest you’d better to get some help from the third-part component’s vendor before using it in SSIS.

    Regards,

    Seif


    • Edited by Seif Wang Wednesday, August 31, 2016 8:52 AM
    • Proposed as answer by Seif Wang Thursday, September 8, 2016 10:26 AM
    • Marked as answer by Eric__ZhangModerator Friday, September 9, 2016 1:17 AM
    Monday, August 29, 2016 12:01 PM

All replies

  • Essentially, you have to use a Web Service Task to connect to Salesforce Web API.

    Try this video...
    https://channel9.msdn.com/Shows/SQL-Server-Integration-Services-Tutorial-Videos/Web-Service-Task

    Try this video...

    https://www.youtube.com/watch?v=WyCiIWKUFKU

    Sample using Amazon Web Services
    https://channel9.msdn.com/coding4fun/articles/Using-the-Amazon-Web-Service

    Documentation
    https://msdn.microsoft.com/en-us/library/ms140114.aspx?f=255&MSPPError=-2147217396

    Please mark answered, if it does it.

    • Proposed as answer by Seif Wang Sunday, August 28, 2016 6:46 AM
    • Unproposed as answer by Seif Wang Thursday, September 8, 2016 10:26 AM
    Saturday, August 27, 2016 5:07 PM
  • Hi Kapil,

    As far as I know, Microsoft has not provides Open Source connectors for connecting to Salesforce in SSIS.

    According to your description, I found a case in Salesforce’s forum that people are discussing the similar requirements. According to the discussion, most people suggest use a third-part components to retrieve data from Salesforce side. Please take a  reference.

    Since this is a third-part component, so please use it carefully.

    In order to avoid some issues, I suggest you’d better to get some help from the third-part component’s vendor before using it in SSIS.

    Regards,

    Seif


    • Edited by Seif Wang Wednesday, August 31, 2016 8:52 AM
    • Proposed as answer by Seif Wang Thursday, September 8, 2016 10:26 AM
    • Marked as answer by Eric__ZhangModerator Friday, September 9, 2016 1:17 AM
    Monday, August 29, 2016 12:01 PM