Professional Sharepoint® 2010 Cloud-Based Solutions

An authoritative guide to extending SharePoint's power with cloud-based services If you want to be part of the next major shift in the IT industry, you'll want this book. Melding two of the hottest trends in the industry—the widespread popularity of the SharePoint collaboration platform and the rapid rise of cloud computing—this practical guide shows developers how to extend their SharePoint solutions with the cloud's almost limitless capabilities. See how to get started, discover smart ways to leverage cloud data and services through Azure, start incorporating Twitter or LinkedIn into your solutions, find the best ways to secure everything, and much more. Shows developers how to use Microsoft SharePoint 2010 to create scalable, cloud-based solutions Melds the hottest new trend in the industry—developing, hosting, managing, or storing code in the cloud—with what SharePoint developers need to know to weave these technologies into their solutions Provides developer patterns, real-world examples, and invaluable walkthroughs Topics include SQL Azure for data management and BI, building an Azure-based corporate tax service, connecting Linked In and SharePoint profile data, creating a filterable Twitter dashboard, leveraging Bing Maps Geo services, maintaining security, and more SharePoint developers, discover exciting new ways to extend SharePoint's functionality with this practical and content-rich guide. Professional Sharepoint® 2010 Cloud-Based Solutions 3 About The Authors 11 About The Technical Editor 13 Credits 15 Acknowledgments 17 Contents 19 Introduction 25 Chapter 1: Getting Started with Sharepoint and the Cloud 33 Overview of the Cloud 33 Windows Azure 35 Web 2.0 36 Bing Services 37 Microsoft Dynamics CRM 38 Understanding the Importance of the Cloud 38 Integrating the Cloud with SharePoint 40 Setting Up Your Development Environment 41 Setting Up a Virtualized Environment 41 Installing Hyper-V 42 Setting Up a Native Environment 43 Creating Your First SharePoint Cloud Application 45 Summary 51 Additional References 52 Chapter 2: Using Sql Azure for Business Intelligence 53 Overview of SQL Azure 53 Uses of SQL Azure 54 Migrating SQL Server to SQL Azure 54 Interacting with SQL Azure with SQL Server 2008 R2 Management Studio 55 BI Solutions Using SQL Azure 57 No-Code BI Solutions in SharePoint 57 Code-Based Solutions in SharePoint 58 Creating a BI Dashboard Using SQL Azure and SharePoint 59 The Solution Architecture 59 Creating the Sales BI Application 60 Creating the SQL Azure Database 61 Creating an External List 63 Creating the WCF Service 67 Creating the Sales Web Part 72 Creating the Sales Dashboard UI 78 Summary 80 Additional References 81 Chapter 3: Building A Windows Azure–Based Service 83 Getting Started 84 Installing SharePoint 2010 84 Installing Windows Azure SDK and Tools 84 Creating an SSH Tunnel 84 Initializing the Windows Azure Compute and Storage Emulators 85 Using Windows Azure Table Storage 86 Creating the Windows Azure Web Role 87 Creating the Entity Data Model 88 Populating the Windows Azure Table 90 Creating a WCF Service Endpoint 101 Building a Windows Azure Service 101 Accessing Table Storage Data 103 Creating a SharePoint BCS External Content Type 109 Consuming a Windows Azure Service Using BCS 109 Summary 113 Additional References 114 Chapter 4: Creating an Aggregated Solution Using Cloud-Based Data 115 Overview of Mashups 115 Creating Mashups Using Yahoo Pipes 116 Using the Pipes Editor 117 Creating Pipes 119 Consuming Pipes 121 Joining Multiple Feed Sources 124 Sorting and Filtering Feed Sources 126 Using Existing Pipes 129 Extending Your Pipes with Yahoo Query Language 133 Using the YQL Console 134 Creating a YQL Pipe Web Part 141 Summary 143 Additional References 143 Chapter 5: Connecting Linkedin and Sharepoint Profile Data 145 Overview of SharePoint Social Computing 146 My Site 146 SharePoint Profi les 147 Adding Custom User Profi le Properties 148 Social Tagging and Notes 149 Activity Feeds 150 Blogs 150 Wikis 151 Understanding the LinkedIn Social Networking Programming Model 152 LinkedIn Profi les 153 Creating a LinkedIn Silverlight Web Part 153 Authenticating in LinkedIn 155 Reading LinkedIn Profile Properties 156 Reading SharePoint Profi le Properties 160 Posting LinkedIn Status Messages 165 Summary 169 Additional References 170 Chapter 6: Using Twitter in Your Sharepoint Solutions 171 Overview of Twitter 171 Developing Applications Using Twitter 173 Using OAuth in Your Twitter Applications 173 Building Applications That Require Authorization 174 Building Applications That Do Not Require Authorization 179 Using the Twitter Trends Data 181 Integrating Twitter with SharePoint 184 The Solution Architecture 184 Creating the Twitter and SharePoint Solution 185 Creating the Twitter Service 185 Creating the Silverlight Client Application 198 Deploying the Silverlight Application 203 Summary 204 Additional References 204 Chapter 7: Using Bing Maps in Your Sharepoint Business Solutions 205 Overview of Bing Maps 205 Bing Maps Controls 210 Leveraging Geo-Location Web Services 211 Integrating the Bing Maps API with SharePoint 212 Leveraging the Client Object Model 213 The Solution Architecture 214 Creating a SharePoint Solution Using Bing Maps 215 Creating the Bing Map Application 215 Creating the Application UI 218 Creating a Store and Sales List in SharePoint 232 Deploying the Silverlight Bing Application 233 Summary 235 Additional References 236 Chapter 8: Financial Modeling with Excel Services and Windows Azure 237 Overview of Excel Financial Models 238 Integrating Windows Azure with Offi ce 239 Office Clients and Azure 240 Office Services and Azure 241 The Solution Architecture 241 Accessing Azure Table Data via WCF Data Services 243 Using a WCF Service to Provide Azure Table Data 251 Extending an Excel Financial Model to Leverage Azure Table Data 268 Creating an Excel Client Add-In 269 Using the ECMAScript Object Model with the Excel Web Access Web Part 277 Summary 286 Additional References 287 Chapter 9: Creating a Training Application in Sharepoint Online 289 Overview of the Training Application 290 The Solution Architecture 290 Understanding the SharePoint Online Platform 290 Scalable Storage in the Cloud with Azure 292 Building the Video Library 292 Creating the Data Model in SharePoint Online 293 Uploading Videos to Windows Azure 294 Creating an Integrated User Experience 298 Creating the Video Player 299 Enabling Social Experiences in Training 303 Summary 306 Additional References 306 Chapter 10: Managing Customer Information in Sharepoint Online 307 Overview of Microsoft Dynamics CRM 308 The Solution Architecture 311 Using Silverlight with SharePoint 312 Security and Authentication 313 Building the Dashboard 313 Connecting Document Libraries to CRM Online 314 Building the Windows Azure Proxy 315 Creating the Silverlight Grid and Chart 323 Bringing It All Together 338 Summary 340 Additional References 340 Chapter 11: Securing Cloud Solution Susing Claims-Based Authentication 341 Overview of Claims-Based Identity 342 WS-Federation vs. WS-Trust 343 The Power of Claims-Based Identity 344 SharePoint and Claims 345 Relying Party Applications, Federation Providers, and Identity Providers 346 Relying Party Applications 347 Window Azure AppFabric Access Control Service 348 Active Directory Federation Services v2.0 348 The Solution Architecture 348 Accessing Claims-Based Azure Services from SharePoint 350 Setting Up an Access Control Service Namespace 350 Establishing AD FS v2.0 As a Trusted Identity Provider for ACS 350 Creating a Relying Party Azure Web Application 353 Wiring the Azure Web Application to Trust ACS 357 Accessing the Azure Web Application from SharePoint via Claims-Based Authentication 365 Summary 367 Additional References 367 Index 369 Advertisements 383 Annotation An authoritative guide to extending SharePoint's power with cloud-based servicesIf you want to be part of the next major shift in the IT industry, you'll want this book. Melding two of the hottest trends in the industrythe widespread popularity of the SharePoint collaboration platform and the rapid rise of cloud computingthis practical guide shows developers how to extend their SharePoint solutions with the cloud's almost limitless capabilities. See how to get started, discover smart ways to leverage cloud data and services through Azure, start incorporating Twitter or LinkedIn into your solutions, find the best ways to secure everything, and much more. Shows developers how to use Microsoft SharePoint 2010 to create scalable, cloud-based solutionsMelds the hottest new trend in the industrydeveloping, hosting, managing, or storing code in the cloudwith what SharePoint developers need to know to weave these technologies into their solutionsProvides developer patterns, real-world examples, and invaluable walkthroughsTopics include SQL Azure for data management and BI, building an Azure-based corporate tax service, connecting Linked In and SharePoint profile data, creating a filterable Twitter dashboard, leveraging Bing Maps Geo services, maintaining security, and moreSharePoint developers, discover exciting new ways to extend SharePoint's functionality with this practical and content-rich guide If you want to be part of the next major shift in the IT industry, you'll want this book. Melding two of the hottest trends in the industry - the widespread popularity of the SharePoint collaboration platform and the rapid rise of cloud computing - this practical guide shows developers how to extend their SharePoint solutions with the cloud's almost limitless capabilities. See how to get started, discover smart ways to leverage cloud data and services through Azure, start incorporating Twitter or LinkedIn into your solutions, find the best ways to secure everything, and much more.