Integrate with SalesForce

On my quest to identify the right tool/technology to integrate the scribe data with SalesForce.com

Requirement :- Send about 6 pre-identified data elements (scribe data) to the SalesForce.com. Volume :- 5000 records per day.

Below are some options at my disposal

BizTalk Server with SaleForce.com Adapter

  • Twoconnect.com has done pretty good job on developing that adapter back in 2006, But we had to make it work on BizTalk Server 2010.
  • This is the only adapter I could find out for the BizTalk Server and based on the reviews/discussions in forums, it was not a wise choice for me to go with this adapter.

http://social.msdn.microsoft.com/Forums/en-us/biztalkgeneral/thread/bc31877d-c9d5-4c08-bf3a-05f0210db8de

http://geekswithblogs.net/BizTalkUnleashed/archive/2009/06/19/experince-of-biztalk-and-salesforce.com-integration.aspx

  • Lastly, I could consider integrating the BizTalk with SalesForce using WCF Custom Adapter, I will explore more on this option and update you all.

http://seroter.wordpress.com/2011/02/06/sending-messages-from-biztalk-to-salesforce-com-chatter-service/

SSIS with SaleForce.com

    • CozyRoc Adapter :- My Client is already using this, so may be we could leverage the same to talk with SalesForce.  ~=$399/yr

http://www.cozyroc.com/ssis/salesforce-destination

    • PragmaticWorks Adapter :- They seem to have a good adapter as well, this could be considered as any alternative. ~=$795 lifetime

http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/SSIS-Sharepoint-Destination-Adapter.aspx

Workflow console application with SalesForce.com

  • This option requires you to build it yourself and implement the complete interface with SalesForce.com.
  • WCF Workflow services hosted on Windows AppFabric seems to the the best option at the moment, Because it need have to go through the hassle of sharing the resources with our primary BizTalk Server.

 

Force.com provides us good oversight of integration with them.

http://www.salesforce.com/platform/cloud-infrastructure/integration.jsp

http://wiki.developerforce.com/page/Integrating_with_the_Force.com_Platform

 

 

 

Articles to Refer

http://www.summa-tech.com/blog/2010/03/22/integrating-with-salesforcecom/

http://wiki.developerforce.com/page/Integration

http://developer.force.com/REST

http://wiki.developerforce.com/page/Cheat_Sheets