Here’s is my slide deck and the Resources from the SharePoint Saturday Sydney 2011. Thank you for those who attended and voted for this session.
|Plan to upgrade BCS|
|BCS Resource Centre|
|BCS Video – Secure Store|
|BCS Security Overview|
|How BCS & Azure play together|
Windows Azure MarketPlace DataMarket is a service that provides a single consistent marketplace and delivery channel for high quality information as cloud services. It provides high quality Statistical and Research data across many business domains from financial to Health Care.. You can read more about it here
How do we consume this content in an enterprise scenario? In this post we are going to look at how to integrate Azure Marketplace Datamarket with SharePoint 2010 via Business Connectivity Services via .NET Connector as a external list. This enable us to surface Azure DataMarket data through SharePoint 2010 lists which opens up world of possibilities including going offline with SharePoint workspace and participation with workflows, enterprise search etc..
Let’s first start with Azure Datamarket. Logon to https://datamarket.azure.com with your live id and subscribe to a dataset that that you are interested in. I selected European Greenhouse Gas Emissions DataSet. Also note down your account key in the Account Keys tab as we will need this information later on.
The Dataset details give you the input parameters and results as follows.
LinqPad is a nifty tool to develop and test LINQ Query Expressions. It allows you to connect to Windows Azure DataMarket Datasets and develop the queries against the data as shown below.
Now lets move on to VS2010 and create a BCS Model project as shown below.
Rename the Default Entity in the BDC Model designer and set the properties that you want to expose as the external content type
Once all properties are set DBC Explorer displays my model as shown below.
Now our BDC model is ready. Now lets implement ReadList and ReadItem BDC operations.
First Add a Service Reference to your project. Set the Address to the location of your Azure DataMarket
Dataset and Discover the oData Feed as shown below.
After the service reference is added , we can implement the ReadItem method as shown below.
Note that Service Reference Context requires your live ID and account Id pass as credentials in to the service call.
Once all operations are implemented Click F5 to build and Deploy your BDC model into SharePoint. Once deployed
log on to Central Administration and go to Manage Service Applications and select Business Connectivity Services
and view the Details of EmissionStat Content Type being Deployed. You might wanted to permissions for this content
type at this point.
Now the external content type is defined all we need is a external List based on this content type. Fire up SharePoint
Designer and Create an external list referencing the new External content type just created
Once the list is created navigate to the list in the portal. Note that Windows Azure market place Data Market content
now surfaced through SharePoint 2010 list as shown below. The VS2010 solution associated with this post can be download here
Viewing item details shows full item details using our ReadItem BCS operation.
Integrating Structured data (Azure) with Unstructured content (Collaborative Data) in SharePoint allows you to create high business valued
composites for informed decision making purposes at all levels in your organisations. Happy Cloud Collaboration!
Windows Identity Foundation (WIF) is the platform on which SharePoint 2010 claims authentication is based. WIF, which is fully supported in SharePoint 2010, ADFS 2.0, ASP.NET, Windows Communication Foundation (WCF), and any other .NET application you care to develop, provides the infrastructure necessary to generate, transmit, and process claims-based identity in a simple and straightforward manner. It removes the roadblocks imposed by legacy authentication schemes like NTLM and Kerberos and puts control directly into the hands of developers, users, and IT security professionals. long story short, it’s a framework written to help solve identity issues common in the of cloud computing and service-oriented architecture.
The idea of claims based identity is one that many people are willing to try. Getting accurate information out there to the public though does take time.
The important point is this is based on industry standards. Many different entities are on board along with Microsoft in this matter. The digital world continues to give us new opportunities and those involved believe that this will help all of us to get the most out of it. There is a strong foundation in place to continue building upon. The use of AD FS v2, CardSpace, and Windows Identity Foundation are all important pieces of this puzzle.
As a demonstration of these capabilities, I’ll show how SharePoint 2010, WCF,and WIF can be put together to solve the identity delegation problem. In this demo session part 1 I start establishing the trust relationship between ADFS 2.0 and SharePoint with PowerShell and demonstrate how the claims get into SharePoint.Then we build and deploy a claims viewer Webpart with WIF programming model. In part 2 We start with a web service that is front-ending line-of-business information stored in a SQL database. Then, we’ll configure it to use WIF to request the calling user’s claims from SharePoint and process the token so that authorization decisions can be made. we’ll surface this information in SharePoint 2010 as an External Content Type using Business Connectivity Services (BCS).
Click here to view a recorded screencast of this session.
The slide deck of this session is shared here