Sharepoint BCS Connections

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

PDC 2010 streams!

PDC 2010 streams!

http://player.microsoftpdc.com/

Share on Facebook

Storing Context Properties onto the document for Break-Fix use in Sharepoint.

Problem: Moving documents to SharePoint removes context properties from message.  Using EDI this makes it difficult to use the Break-Fix Resubmit.

Write using Reflection and a lot of custom code to produce a standarized document to send to SharePoint that would be reusable.

<ToSharePoint>
 <SavedContext>
           <Context>
                      <Name>ReceiverPartyName</Name>
                      <Value>ACME</Value>
                       <Type>String</Type>
            </Context>
            <Context>
                      <Name>ToBeBatched</Name>
                      <Value>True</Value>
                      <Type>Boolean</Type>
             </Context>
 </SavedContext>
          <Payload>
               Original Documentusing xs:any
          </Payload>
</ToSharePoint>

Share on Facebook

Azure Firestarter Wednesday November 10th, 2010 : Alpharetta

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032463587&Culture=en-US

I will be there, if any of you are going let me know.  We can plan lunch properly.

Share on Facebook

MIA Azure Demo Shell

Note to self:  Create short names.  MicrosoftIntegrationArchitects.BCSSample.Azure failed to Run the first time through with an error message of so:

Where to start New Project:



Windows Azure Tools: Failed to initialize Development Storage service. Unable to start Development Storage. Failed to start Development Storage: the SQL Server instance ‘localhostSQLExpress’ could not be found. Please configure the SQL Server instance for Development Storage using the ‘DSInit’ utility in the Windows Azure SDK.
 
 Moved to my local instace:
 
Copy and paste this into a command window.  [Start->run] Type CMD in run then OK.
“C:Program FilesWindows Azure SDKv1.2bindevstoreDSInit.exe” /sqlInstance:.



First Test (Not the URL came up as :5051)  investigated port change, to see if my last implementation was somehow blocking the use of that port.
I ran IISReset [Start->Run] Type IISRESET and then hit OK,  used “Start Debugging” and the site came up properly.
Done for the morning.
Share on Facebook

Webcasts and recent reading (Why I haven’t posted much in the last week)

Sharepoint BCS

http://www.screencast.com/users/jthake/folders/SharePointDevWiki.com%20Screencast/media/10d81c1f-2bbf-417f-a307-1e88933b2864

ESB Toolkit from scratch to Done

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521358748974196639

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521358747494657215

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521358746500315471

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521358745490654863

ESB Offramp to Azure

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521364259904108159

http://www.cloudcasts.net/ViewWebcast.aspx?webcastid=2521364267614392367

SOA with .Net

http://search.barnesandnoble.com/SOA-with-NET-and-Windows-Azure/Thomas-Erl/e/9780131582316

Thomas Erl’s SOA Design Patterns

http://www.soapatterns.com/

Richard Seroter’s SOA Patterns with  BizTalk Server 2009

http://seroter.wordpress.com/2009/04/24/soa-patterns-with-biztalk-server-2009-released/

Share on Facebook

MIA Meetup Page tenative:

http://www.meetup.com/Microsoft-Integration-Architects/calendar/list/

Using forwarding from

http://www.microsoftintegrationarchitects.com

Share on Facebook

Getting Laptop Setup for the Sharepoint Workflow Services Talk at the first Integration Users Group meeting.

Loading from MSDN:
Sharepoint 2010
Sharepoint Designer 2010
Sharepoint Workspace 2010
VS2010Pro
SQL 2008R2

http://msdn.microsoft.com/en-us/library/ms549489.aspx

(Up and runnign as of 11:30 am)

Share on Facebook

SOA with .NET & Windows Azure Realizing Service-Orientation with the Microsoft Platform

Incredible new book, seems a very easy read. Looks like Brian Loesgan wrote part of this as well.

Share on Facebook

Excellent Azure Website. (Group of Developers)

http://oakleafblog.blogspot.com/2010/08/windows-azure-and-cloud-computing-posts_05.html

Share on Facebook