Fabian Williams SharePoint Blog

Solving problems with SharePoint day and night

Video How To: Create a Multi Master Relationship with SharePoint 2010 BCS External List using SharePoint Designer 2010

Synopsis:  In this video webcast I am doing the following:

  • Using multiple (two) disparate LOB Systems
    • Two Independent SQL Server Databases
    • Separate Security Model
    • No Explicit Relationship between data elements
  • Using two External Content Types in SPD 2010
  • Using two External List in SharePoint
  • Creating a Site Page to establish a Multi Master Page which will allow one to key off a data element and see detail information resulting from another LOB System.

Follow this link or click the image below: http://www.screencast.com/t/NzJiOWMzZDQ


Happy New Year… Stay tuned in 2010 for more SharePoint 2010 from Me! Come out and see me at SharePoint Saturday

  • Virginia Beach
  • Indianapolis
  • Boston

and at SharePoint Tech Con in San Francisco


December 31, 2009 - Posted by | Business Connectivity Services, Office 2010 Beta, SharePoint 2010, SharePoint Development, SharePoint General, SharePoint How-To, Video Screencast, Webcast | , , ,


  1. 3.Hi,

    Thanks for the video.
    I have a question.I am creating ECT from Sharepoint designer.
    The External content Type -Tables configured from SQL server database have columns of data type Numeric and small int.

    These when used in External List The columns are defined as data type Decimal and Interger respectively in the List in sharepoint.

    The problem I have here is,After creating the external list in Sharepoint site ,I cannot sum the column with datatype “Decimal”(in external list).(Totals-in sharepoint view)

    The External list usually have “Number” as its data type.But BDC on conversion uses “Decimal” and “Integer”.

    Any thoughts on how I can change the data type in sharepoint? or how can I get the sum of decimal columns?


    Comment by Priyanka | August 27, 2010 | Reply

    • I more so use VS 2010 to create ECT and not SPD, doing so I can create my own properties for the entitiy

      Comment by fabiangwilliams | September 9, 2010 | Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: