Resources: Sharepoint BCS: Connecting to an XML file. http://www.screencast.com/users/jthake/folders/SharePointDevWiki.com%20Screencast/media/10d81c1f-2bbf-417f-a307-1e88933b2864 Permissions Issues http://www.biztalkgurus.com/blogs/biztalksyn/archive/2010/04/23/sharepoint-2010-rtm-and-bcs-permissions.aspx Hosting BAP in Sharepoint http://blogs.msdn.com/b/sharepoint/archive/2008/03/24/announcing-the-microsoft-biztalk-adapter-pack-office-developer-program.aspx Pre-requiste WCF LOB Adapter SDK SP2 http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=47ab6f21-0d8b-4c90-a8b9-e8647281b164 Download (if you don't have MSDN) Biztalk Adapter pack 2.0 http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=76736ba7-3c05-4436-9353-1c33f9005194#AffinityDownloads Adapter Pack Overview (Microsoft) http://www.microsoft.com/biztalk/en/us/adapter-pack.aspx HowToGuide for LOB 1.0 http://msdn.microsoft.com/en-us/library/dd442475(BTS.10).aspx Sharepoint 2010 BCS + SAP http://spninjablog.wordpress.com/2010/01/22/sharepoint-2010-bcs-wcf-sap/ http://kalsing.blogspot.com/2009/07/accessing-business-data-with-sharepoint.html http://www.slideshare.net/kalsing/sharepoint-saturday-india-sapsharepoint-interoperability http://blogs.technet.com/duetenterprise/archive/2010/04/16/technical-overview-of-duet-enterprise-for-microsoft-sharepoint-and-sap.aspx AppDev's Doug Ware. Georgia SharePoint expert, owner of Elumenotion. Exploring Sharepoint 2010 -Module 6 External Data. www.Appdev.com Explained how and when to use which content type. The easiest of the above to follow. Goal: Learn BCS 1. Created New Site with defaults for most. 2. Created Site Collection Error 1: When I tried creating a site collection I received this message from SharePoint. I found this in the Event Viewer: The Execute method of job definition Microsoft.SharePoint.Administration.SPUsageImportJobDefinition (ID 54f1a2a7-9981-47a9-8cae-f27c5664469a) threw an exception. More information is included below. Access to the path 'C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14LOGS' is denied. Gave Network Service access to that directory.. Error 2: Fixed by this post. http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/2a64ce83-ecf5-4f43-a46d-a6c3598df8cc/ Formatted box, Server 2008R2 restarted ran DCPROMO first, then VS2010 (without express), SQL 2008 R2, SP 2010, SP2010 designer. Seems that the Workgroup setup does not play well with Sharepoint 2010. So remember if you are using a development box you want to make sure it is a doman controller.Share on Facebook