1 / 17

How to Store the data you need In SharePoint 2010 

Mick Badran MVP, V-TSP,XYZ,ABC mickb@breeze.net ocs:mickb@breeze.net. How to Store the data you need In SharePoint 2010 . My Main Objectives for you. To show SharePoint as a Data Platform Get an understanding of data storage within SharePoint 2010 – above and beyond Documents and Tasks etc.

infinity
Download Presentation

How to Store the data you need In SharePoint 2010 

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mick BadranMVP, V-TSP,XYZ,ABCmickb@breeze.netocs:mickb@breeze.net How to Store the data you need In SharePoint 2010 

  2. My Main Objectives for you • To show SharePoint as a Data Platform • Get an understanding of data storage within SharePoint 2010 – above and beyond Documents and Tasks etc. • Ways to get Data In/Out of SharePoint 2010.

  3. Session Agenda • Places to store data within SharePoint 2010. • Data at the Site/Web level • Data in Service Applications • Data in Lists/External Lists • Data in Custom Fields • Data exposed through Silverlight 

  4. Places to Store Data In SharePoint • PROBLEM: SharePoint is ‘generally’ pitched to be all things to everyone.“I can’t do…”“Don’t worry, SharePoint will fix it!” • Question to ask yourselves: • What is the data? • Where is the data? • How long do I need it for?

  5. Places to Store Data In SharePoint • Common SharePoint data storage structures: • Documents!!! Xml Documents, Excel Docs, Reports • Lists listslistslists, custom columns, folders – offline issues? • Content Types • Site/Web/List/Folder – Property Bags • Access Services – ‘Web Database’ !!! • User Profile – custom properties • Custom Service Applications

  6. Data at the Site/Web Level • Storing data/content at a Site Collection or Web level. • What sort of data? • How? • How does it become exposed?

  7. Site/Web Properties Demo Show you something cool

  8. Data In Service Applications • By far the most flexible storage mechanism within SharePoint. • What sort of problem would warrant this? • Benefits of a Service Application? • Cons of a Custom Service Application? • No guarantee this data is going to be exposed – e.g. Access Services

  9. Service Applications Demo Show you something cool

  10. Data In Lists/External Lists • Flexible and easy access for both read and write • Up to 50 million items (apparently) per list. • What data is placed in lists? • How does relational data get processed? E.g. parent/child. • How are lookup fields resolved when inserting external data. • How to access List data? • ServerAPI, RSS, ClientOM, ListData.svc, REST, Offline..

  11. External List Demo Show you something cool

  12. Data In Custom Fields • Provide flexibility around packing/unpacking data – e.g. complex address. • Fields have 2 main modes: • Presentation Mode • Author/Editing Mode • We can perform different logic for each mode. • Custom XSLT Field Rendering in lists allows for exciting interactions.(No CAML required)

  13. Custom Fields - I Show you something cool

  14. Exposing Data Through SilverLight • Why Silverlight? • Silverlight runs on the Client machine with a ‘Silverlight CLR’ – an App in english. • Is able to talk to SharePoint/WCF Services etc. • Great for desktop notifications! • Can be initialised with particular parameters

  15. Custom Fields - II Show you something cool

  16. Wrap Up • SharePoint is more than just Documents and Tasks • It’s a flexible data platform! • Many structures exist out of the box – e.g. lists etc. • Or you can build your own. NB: all demos and slides will be on my blog as well.http://blogs.breezetraining.com.au/mickb

More Related