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


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

MultiMasterScreenCastImage

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


Leave a comment

Your email address will not be published. Required fields are marked *

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

  • Priyanka

    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?

    Thanks.