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
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.
I more so use VS 2010 to create ECT and not SPD, doing so I can create my own properties for the entitiy