1 / 21

SQL Server 2008 R2 Reporting Services 05 – Working with ATOM Data Feeds

SQL Server 2008 R2 Reporting Services 05 – Working with ATOM Data Feeds. SQL10R2UPD01-DECK-05 [Presenter Name] [Presenter Title] [Company Name]. Module Overview. What's New in Reporting Services Developing Reports with the New Features Visualizing Data with Maps

oded
Download Presentation

SQL Server 2008 R2 Reporting Services 05 – Working with ATOM Data Feeds

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. SQL Server 2008 R2 Reporting Services 05 – Working with ATOM Data Feeds SQL10R2UPD01-DECK-05 [Presenter Name] [Presenter Title] [Company Name]

  2. Module Overview • What's New in Reporting Services • Developing Reports with the New Features • Visualizing Data with Maps • Working with Shared Components • Working with ATOM Data Feeds • Embedding Reporting into Applications • Developing with the Microsoft Chart Controls

  3. Agenda • Generating ATOM Data Feeds from Reports • Consuming ATOM Data Feeds • Demo: Exporting a Report Feed • Lab: Working with ATOM Data Feeds

  4. Generating ATOM Data Feeds from Reports • Data Feed Overview • ATOM Data Service • Data Feed Generation • Data Service Document • ATOM Document • Multiple Data Regions

  5. Data Feed Overview • Export any report as a data feed • Formatting does not affect the export • Similar to CSV export • Consider developing reports exclusively for data feeds to meet specific data requirements • Use data feeds for a variety of scenarios • Prevent direct access to data source • Simplify complex data structures for user queries • Use Reporting Services features to manage data access • Security • Scheduled execution • Snapshots

  6. ATOM Data Service • Streams data on demand • Describes in XML format how to retrieve data from data service • Uses same format as ADO.NET data services feed

  7. Data Feed Generation • Toolbar button • URL access http://<servername>/ReportServer?/<reportPath>&rs:Command=Render&rs:Format=ATOM

  8. Data Service DocumentATOMSVC File • A data feed export • Does not render data (unlike other export formats • Produces an ATOMSVC file that references the data feed Data Feed URL Unique ID

  9. ATOM DocumentAccess • Replace &amp; with & in the data feed URL to access the ATOM document • Open the ATOM document to view the rendering of the data feed in XML format

  10. ATOM DocumentStructure Header Section Data Section

  11. Multiple Data RegionsSource Report

  12. Multiple Data RegionsData Feed Components Table Chart One data feed per nested data region

  13. Multiple Data RegionsATOMSVC File Data Feed URL Unique ID

  14. Agenda • Generating ATOM Data Feeds from Reports • Consuming ATOM Data Feeds • Demo: Exporting a Report Feed • Lab: Working with ATOM Data Feeds

  15. Consuming Report Feeds • PowerPivot for Excel • URL Access

  16. PowerPivot for Excel • Open ATOMSVC file to launch Table Import Wizard • Provide name for data feed connection • Select data feeds to import and apply filters

  17. URL Access • URL access for direct access to data feed • Add device info parameters • <Datafeed> • <Encoding> http://<servername>/ReportServer?/<reportPath>&rs:Command=Render&rs:Format=ATOM&rc:DataFeed=xAx0x0xDx0x0x0x1&rc:Encoding=ASCII

  18. Exporting a Report Feed SQL10R2UPD01-DEMO-04 Demo

  19. Working with ATOM Data Feeds SQL10R2UPD01-HOL-03 Lab

  20. Resources • Generating Data Feeds from Reports • http://msdn.microsoft.com/en-us/library/ee210663(SQL.105).aspx • Data Feeds Overview • http://msdn.microsoft.com/en-us/library/ee210699(SQL.105).aspx • PowerPivot Website • http://www.powerpivot.com • PowerPivotPro Blog • http://powerpivotpro.com

  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