Professional SharePoint 2010 Cloud-Based Solutions

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page ii

ffirs.indd ii firs.indd ii 10/19/2011 1:20:59 PM 0/19/2011 1:20:59 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page i

PROFESSIONAL

SHAREPOINT® 2010 CLOUD-BASED SOLUTIONS

INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxiii

CHAPTER 1 Getting Started with SharePoint and the Cloud . . . . . . . . . . . . . . . . . . . . . .1

CHAPTER 2 Using SQL Azure for Business Intelligence . . . . . . . . . . . . . . . . . . . . . . . . .21

CHAPTER 3 Building a Windows Azure-Based Service . . . . . . . . . . . . . . . . . . . . . . . . .51

CHAPTER 4 Creating an Aggregated Solution Using Cloud-Based Data . . . . . . . . . 83

CHAPTER 5 Connecting LinkedIn and SharePoint Profi le Data . . . . . . . . . . . . . . . . . . 113

CHAPTER 6 Using Twitter in Your SharePoint Solutions . . . . . . . . . . . . . . . . . . . . . . 139

CHAPTER 7 Using Bing Maps in Your SharePoint Business Solutions . . . . . . . . . . . 173

CHAPTER 8 Financial Modeling with Excel Services and Windows Azure . . . . . . .205

CHAPTER 9 Creating a Training Application in SharePoint Online . . . . . . . . . . . . . . 257

CHAPTER 10 Managing Customer Information in SharePoint Online. . . . . . . . . . . . . 275

CHAPTER 11 Securing Cloud Solutions Using Claims-Based Authentication . . . . . 309

INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337

ffirs.indd i firs.indd i 10/19/2011 1:20:58 PM 0/19/2011 1:20:58 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page ii

ffirs.indd ii firs.indd ii 10/19/2011 1:20:59 PM 0/19/2011 1:20:59 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page iii

PROFESSIONAL

SharePoint® 2010 Cloud-Based Solutions

ffirs.indd iii firs.indd iii 10/19/2011 1:20:59 PM 0/19/2011 1:20:59 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page iv

ffirs.indd iv firs.indd iv 10/19/2011 1:20:59 PM 0/19/2011 1:20:59 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page v

PROFESSIONAL

SharePoint® 2010 Cloud-Based Solutions

Steve Fox

Donovan Follette

Girish Raja

Paul Stubbs

ffirs.indd v firs.indd v 10/19/2011 1:20:59 PM 0/19/2011 1:20:59 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page vi

Professional SharePoint® 2010 Cloud-Based Solutions

Published by

John Wiley & Sons, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Copyright © 2012 by John Wiley & Sons, Inc., Indianapolis, Indiana

Published simultaneously in Canada

ISBN: 978-1-118-07657-6

ISBN: 978-1-118-22265-2 (ebk)

ISBN: 978-1-118-22967-5 (ebk)

ISBN: 978-1-118-22951-4 (ebk)

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means,

electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108

of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization

through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers,

MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the

Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201)

748-6008, or online at http://www.wiley.com/go/permissions.

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with

respect to the accuracy or completeness of the contents of this work and specifi cally disclaim all warranties, including

without limitation warranties of fi tness for a particular purpose. No warranty may be created or extended by sales or pro￾motional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold

with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services.

If professional assistance is required, the services of a competent professional person should be sought. Neither the pub￾lisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to

in this work as a citation and/or a potential source of further information does not mean that the author or the publisher

endorses the information the organization or Web site may provide or recommendations it may make. Further, readers

should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was

written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the

United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Wiley also publishes its books in a variety of electronic formats and by print-on-demand. Not all content that is available

in standard print versions of this book may appear or be packaged in all book formats. If you have purchased a version of

this book that did not include media that is referenced by or accompanies a standard print version, you may request this

media by visiting http://booksupport.wiley.com. For more information about Wiley products, visit us at

www.wiley.com.

Library of Congress Control Number: 2011939643

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dress are

trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affi liates, in the United States and other coun￾tries, and may not be used without written permission. SharePoint is a registered trademark of Microsoft Corporation.

All other trademarks are the property of their respective owners. John Wiley & Sons, Inc., is not associated with any

product or vendor mentioned in this book.

ffirs.indd vi firs.indd vi 10/19/2011 1:21:01 PM 0/19/2011 1:21:01 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page vii

To my mother and father.

— Steve

To Lorie, my love always.

—Donovan

To my wonderful parents and loving wife, Seetha, for

always being there for me.

—Girish

To my wife, Rosa

—Paul

ffirs.indd vii firs.indd vii 10/19/2011 1:21:02 PM 0/19/2011 1:21:02 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page viii

ffirs.indd viii firs.indd viii 10/19/2011 1:21:02 PM 0/19/2011 1:21:02 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page ix

ABOUT THE AUTHORS

STEVE FOX is the Director of Developer & Platform Evangelism (DPE) for SharePoint

and Windows Azure. He regularly speaks to developers about SharePoint, Offi ce, and

cloud development, at both domestic and international conferences. Steve has

authored many articles and books, including Beginning SharePoint 2010

Development (Wrox, 2010) and Developing Microsoft SharePoint Applications on

Windows Azure (MSPress, 2011). He has worked at Microsoft for 12 years and currently lives in

Seattle, Washington.

DONOVAN FOLLETTE is a Sr. Technical Evangelist for Microsoft with more than 25

years of experience developing enterprise business applications on a variety of plat￾forms. He currently specializes in helping to enable developers in building integrated

line-of-business (LOB) solutions with Microsoft Offi ce and SharePoint 2010.

GIRISH RAJA is a Technical Evangelist at Microsoft’s Redmond campus. In this role,

Girish helps the community learn various development features of SharePoint and

provides guidance for building applications using its platform. He also works on

demonstrating how well SharePoint integrates with other Microsoft technologies

through his blog and various channel9 videos. Prior to this role, he was an Evangelist

for Dynamics CRM.

PAUL STUBBS is a Microsoft Technical Evangelist for Azure, SharePoint, and

Offi ce, where he focuses on the information worker development community

around SharePoint and Offi ce, Silverlight, and cloud computing. He has authored

several books on solution development using Microsoft Offi ce, SharePoint, and

Silverlight, as well as several articles for MSDN Magazine, and has also spoken at

Microsoft Tech-Ed, PDC, SharePoint Conference, DevConnections, and MIX conferences. Paul

has also worked as a Senior Program Manager on Visual Studio in Redmond, Washington. Paul is

a Microsoft Certifi ed Trainer (MCT) and frequently participates in the developer community on

the Microsoft forums. Visit Paul’s blog at blogs.msdn.com/pstubbs for deep SharePoint developer

information.

ffirs.indd ix firs.indd ix 10/19/2011 1:21:02 PM 0/19/2011 1:21:02 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page x

ffirs.indd x firs.indd x 10/19/2011 1:21:05 PM 0/19/2011 1:21:05 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page xi

ABOUT THE TECHNICAL EDITOR

LARRY RIEMANN has more than 17 years of experience architecting and creating

business applications for some of the world’s largest companies. Larry is an inde￾pendent consultant who owns Indigo Integrations and does SharePoint consulting

exclusively through SharePoint911. He writes articles for publication, is a co-author

of Professional SharePoint 2010 Branding and User Interface Design (Wrox, 2010)

and a contributing author on Professional SharePoint 2010 Administration (Wrox, 2010), and is

an occasional speaker. For the last several years he has been focused on SharePoint, creating and

extending functionality where SharePoint leaves off. In addition to working with SharePoint, Larry

is an accomplished .Net Architect and has extensive expertise in systems integration, enterprise

architecture, and high-availability solutions. You can fi nd him on his blog at http://lriemann

.blogspot.com.

ffirs.indd xi firs.indd xi 10/19/2011 1:21:05 PM 0/19/2011 1:21:05 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page xii

ffirs.indd xii firs.indd xii 10/19/2011 1:21:05 PM 0/19/2011 1:21:05 PM

www.it-ebooks.info

Fox ffi rs.indd V3 - 10/11/2011 Page xiii

CREDITS

ACQUISITIONS EDITOR

Paul Reese

PROJECT EDITOR

John Sleeva

TECHNICAL EDITOR

Larry Riemann

PRODUCTION EDITOR

Kathleen Wisor

COPY EDITOR

Luann Rouff

EDITORIAL MANAGER

Mary Beth Wakefi eld

FREELANCER EDITORIAL MANAGER

Rosemarie Graham

ASSOCIATE DIRECTOR OF MARKETING

David Mayhew

MARKETING MANAGER

Ashley Zurcher

BUSINESS MANAGER

Amy Knies

PRODUCTION MANAGER

Tim Tate

VICE PRESIDENT AND EXECUTIVE GROUP

PUBLISHER

Richard Swadley

VICE PRESIDENT AND EXECUTIVE PUBLISHER

Neil Edde

ASSOCIATE PUBLISHER

Jim Minatel

PROJECT COORDINATOR, COVER

Katie Crocker

PROOFREADER

Jen Larsen, Word One

INDEXER

Robert Swanson

COVER DESIGNER

Ryan Sneed

COVER IMAGE

© iStock / Stephen Goodwin

ffirs.indd xiii firs.indd xiii 10/19/2011 1:21:05 PM 0/19/2011 1:21:05 PM

www.it-ebooks.info