1 / 21

Required Slide

Required Slide. Required Slide. Access Services under the Hood. Kerry Westphal Program Manager Microsoft Corporation. Session Takeaways. Access Services empowers users to solve business needs without engaging IT resources

denis
Download Presentation

Required Slide

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. Required Slide

  2. Required Slide Access Services under the Hood Kerry Westphal Program Manager Microsoft Corporation

  3. Session Takeaways • Access Services empowers users to solve business needs without engaging IT resources • Access Services allows IT to monitor databases across the organization through the power and flexibility of SharePoint 2010 • Access Services is built to scale on SharePoint

  4. Lego

  5. More Demands Fewer Resources

  6. Building a Web Database Kerry Westphal Program Manager Microsoft Corporation DEMO

  7. Large Lists Kerry Westphal Program Manager Microsoft Corporation DEMO

  8. Publishing http://www.mysite.com/MyApplication/ MyApplication.accdb SharePoint Site (SubWeb) ACCDB Publish Tables  Lists System Tablemsysaso Client Objects Roundtrip! Yes that includes VBA and Link Tables ASPX Pages Workflows SQL Reports JavaScript

  9. Form Rendering Example Browser WFE ADS Pick an ADS box using health info Get http://server/MyForm.aspx OpenResultSet(“Customers”, 100) New workbook Run Query Render Data Return first 100 rows and session ID Return HTML and Session ID to browser Store data In-memory Content DB

  10. Next Page/Sort/Filter Example Browser WFE ADS Crack session ID and figure out ADS box Pull rows out of in-memory data table http://server/AccessPortal.asmx?GetData SessionID=##### StartRow=101 RowCount=100 GetData(101, 100) Apply data to HTML DOM Return 100 rows Return data to browser Content DB

  11. List Relationships (Restrict Insert, Cascade Delete) Unique Column Constraints Data Level Validation Data Macros Data Platform

  12. Monitoring the Service Kerry Westphal Program Manager Microsoft Corporation DEMO

  13. Browser Access client Client Form & reports Data Form Web Part Datasheet Project JS object Server Access services session Access services Web service ADO.NetIn-memory Query processor Data access layer WSS Lists WorkFlows Access services event handlers Expressions Validation Referential integrity QuickFlows

  14. Browser Web Farm WFE 1 WFE 2 WFE 3 Data View Web Part Access services AJAX WS Data View Web Part Access services AJAX WS Data View Web Part Access services AJAX WS DSC DSC DSC Load balancer + proxy Load balancer + proxy Load balancer + proxy ADS/RS1 ADS/RS2 ADS Web service (private) ADS Web service (private) Data table cache Query Processor Data table cache Query processor SharePoint OM SharePoint OM Content DB

  15. Browser Web Farm WFE 1 Data View Web Part Access services AJAX WS Report Viewer Web Part … DSC Load balancer + proxy Hardware Load Balancer ADS/RS1 ADS web service (Private) Report Server … Query processor Access data provider SharePoint OM Report DB Content DB

  16. 5 Challenges • Run in the cloud as a hosted service (SharePoint Online) • Provide a robust, reliable data platform for data centric apps • Store database objects in SharePoint, render in the browser • Work with large record sets (5k+) without affecting server health • Allow rich ad-hoc querying and joins against lists 

  17. More Info | blogs.msdn.com/access | channel9.msdn.com/shows/access

  18. Resources Required Slide Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  19. Play the Microsoft Office & SharePoint Track Tag Contest Download the Microsoft Tag Reader Open the internet browser on your mobile phone and visit http://gettag.mobi Grand Prize (1) Xbox 360 Prize Package and Microsoft® Office 2010 Daily Prizes 40 copies of Microsoft® Office 2010 Come to the Expo Hall – Yellow Section OSP Info Desk for Official Rules & Collect Additional Tags from all OSP Track Sessions, Speakers and Expo Hall!

  20. Required Slide Complete an evaluation on CommNet and enter to win!

  21. © 2010 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.

More Related