8 – 10 March 2011 | Dubai, UAE

8 – 10 March 2011 | Dubai, UAE

Ayman El-HattabTSP, Microsoft MEASharePoint MVP

Data-Centric Composites and Mashups in SharePoint 2010

SESSION CODE: IAT302

Muhammed NabilTSP, Microsoft MEA

Agenda

Demo: Remote Manager

Demo: Loan calculator

Demo: Supply Chain Dashboard

What is a Mashup ?

Visio Services Overview

The Mashup Hero

How are we going to overcome this gap ?!Business

unit started to document

the requirements

TOO MUCH Lack of resource

Rapidly changing

requirements

IT

Applications

Business Unit

Calling super

team…

We need a solution Lets do Mashups

Applications

The End

What is composite ?

“Composite” refers to a way of delivering enterprise solutions by assembling them from prebuilt Components instead of building them from scratch.

What is a Mashup?

An application that results when a business user combines multiple sources of enterprise and public data with some visualization and interaction capabilities.

An application that results when a business user combines multiple sources of enterprise and public data with some visualization and interaction capabilities.

Remote Manager ScenarioDemo

Scenario• I want to stay closer to a group of people that I remotely manage • I call them every now and then

My goal• I would like to “connect” with my sub-ordinates when I call them

My idea:• Mash data from

• Twitter (to know what they are doing)• MSN Weather (to know what is going on where they live)

• … to have a good ice breaker during the first moments of our calls

Three quick aspects of mashup creation:• Connecting to external data (twitter.com, msn.weather.com)• Connecting parts• Using XSLT for map creation

Remote ManagerDemo

XSLT<?xml version="1.0" encoding="utf-8" ?><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ddwrt2="urn:frontpage:internal">

<xsl:output method="html" indent="no"/><xsl:template match="/" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime"> <xsl:call-template name="dvt_1"/></xsl:template><xsl:template name="dvt_1"> <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row" /> <xsl:call-template name="dvt_1.body"> <xsl:with-param name="Rows" select="$Rows" /> </xsl:call-template></xsl:template><xsl:template name="dvt_1.body"> <xsl:param name="Rows" /> <script src="http://MAPURL;key=THE_KEY" type="text/javascript“></script> <div id="xslmap" style="width:750px; height:400px"></div> <script type="text/javascript">

[CODE TO SETUP MAP] </script>

<xsl:for-each select="$Rows"> <xsl:call-template name="dvt_1.rowview" /> </xsl:for-each></xsl:template><xsl:template name="dvt_1.rowview"> <script type="text/javascript">

address = &quot;<xsl:value-of select="@Address" />&quot; + ", " + “. . .“ [CODE TO GENERATE BUBBLE HTML, EVENT LISTENER, FIND LAT AND LONG, AND ADD MARKER TO MAP] </script>

</xsl:template></xsl:stylesheet>

Loan Calculator Demo

Visio Services Overview

REQUEST #1“I want to share/view diagrams in SharePoint”

Central location Never leave the browser

No more dialogs!

REQUEST #2”I want diagrams that are always up to date”

(1 hr later)Not just a snapshot in timeDiagram only created once

View existing data in context

REQUEST #3”I want diagrams on my SharePoint pages!”

Diagrams in context with other relevant data.

Architecture

Creator

Data Source

Visio ServicesConsumer

VDW

PNG/ XAML

1. Create data connected diagram in Visio

2. Upload it to SharePoint

3. Consumer requests diagram

5. Diagram rendered in browser

4. Visio Services refreshes data and

diagram

VDW

Supply Chain DashboardDemo

Connect with us

Blogs:www.aymanelhattab.com analystinside.blogspot.comblogs.technet.com/meacoexwww.sharepoint4arabs.com

Follow us on Twitter:@AymanElhattab@Muhammed_Nabil

8 – 10 March 2011 | Dubai, UAE

Complete an evaluation on CommZone and enter to win an HP LAPTOP!

Related Content

SharePoint 2010 Developer Overview15:30 – 14:30 – Wen, Mar 9, 2011

Web Design and SharePoint 2010 Publishing Sites11:45 – 12:45 – Thu, Mar 10, 2011

SharePoint Sandboxed Solutions and InfoPath09:00 - 10:00 - Thu, Mar 10, 2011

Developing Office Business Applications with Microsoft Office 2010 and Microsoft SharePoint Server 2010 - 15:00 - 16:00 Thu, Mar 10, 2011

© 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee

the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.