1 / 13

Enesys RS Data Extension

Reporting over SharePoint lists using Microsoft SQL Server Reporting Services and Enesys RS Data Extension. Enesys RS Data Extension.

hilel-ramsey
Download Presentation

Enesys RS Data Extension

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. Reporting over SharePoint lists using Microsoft SQL Server Reporting Services and Enesys RS Data Extension Enesys RS Data Extension Enesys RS Data Extension is a Reporting Services Data Processing Extension that makes it possible to use all the power of Microsoft SQL Server Reporting Services over your SharePoint data. With Enesys RS Data Extension query language based on XML, you can retrieve, merge, join and calculate data from any SharePoint list. Besides making it possible to build live interactive reports, Enesys RS Data Extension is also the perfect solution for solving business problems, by integrating and computing data from multiple SharePoint lists, that would otherwise needs the development of custom applications. This presentation explains how Enesys RS Data Extension works.

  2. Reporting Services Architecture Enesys RS Data Extension • Microsoft SQL Server Reporting Services is a complete reporting platform with an extensible architecture. • Building on this architecture, Enesys RS Data Extension provides a new type of data source that makes it possible to query SharePoint lists. Report Designer Browser Microsoft Office Custom Applications Report Builder Report Manager Report Viewer Programmatic Interfaces:XML Web Service and URL Access Report Server Report Builder – Query generationDrill-through Report generation Data Sources (SQL, XML, Oracle, …) Report Processing Security Services Data Processing Data Processing Security Output Formats (Excel, Html, …) Rendering Delivery Delivery Channels (e-mail, SharePoint, …) Report Server Databases

  3. Reports, Data Source and dataset A report relies on one or more Dataset and one or more Data Source. We will explain those simple concepts to show how Enesys RS Data Extension works.

  4. Building a report Enesys RS Data Extension • Building, designing and testing reports before deploying them on a report server is done with Microsoft Business Intelligence Development Studio (provided as part of the SQL Client tools). • Business Intelligence Development Studio is a subset of Visual Studio. SQL, Oracle, OLE DB, ODBC, XML, … A report relies on data identified by a Dataset. A Dataset queries a Data source for retrieving data A Data source retrieves the real data.

  5. Data Source Enesys RS Data Extension • A Data Source specifies connection information for reporting data. • Various types of Data Source are available out of the box (SQL Server, Oracle, XML, …). • Once Enesys RS Data Extension is configured, it is possible to create a Data Source of type « Enesys SharePoint Data Extension 2008 » for addressing SharePoint lists.

  6. Dataset Enesys RS Data Extension • A Dataset identifies data to be used for report generation. • Requires a data source. • Specify the query that will be executed for retrieving data. • The query syntax will depend on the type of data source you are addressing. Obviously, when you retrieve data from a SQL data base, you will use an SQL Query for retrieving the necessary data.

  7. Enesys rS Data extension Query SharePoint data is not relational by nature. To overcome this limitation, Enesys RS Data Extension provides an XML based query language that will let you manipulate SharePoint data in a relational way.

  8. Query Construction Principles Enesys RS Data Extension • A query is composed of several statements executed sequentially. • Each statement has a specific function. • Resulting data of each statement is stored in a temporary table. • “sqlQuery” statements can manipulate data resulting from other statements using SQL Select syntax. • The overall query result is the data resulting from the last statement. 1 2 3

  9. Query Builder Enesys RS Data Extension • To make it easier to build Enesys RS Data Extension’s Queries, we are providing a separate tool that let’s you build queries using a graphical interface.

  10. Demo • Some demonstrations: • Enesys RS Data Extension in ActionThis screen cast shows how to build a report from scratch using data from two joined SharePoint lists. • Query Builder - Single list queryShort demo showing how to build a simple query using the Query Builder tool. • Query Builder - Joining multiple listsShort demo showing how to join multiple lists using the Query Builder tool provided with Enesys RS Data Extension.

  11. Features Summary Enesys RS Data Extension • Retrieve data from any SharePoint list • Merge multiple lists from any site • Roll up list’s items within a site collection • Support for report’s parameters (single and multi-values) • Expand recurring events • Break down SharePoint multi-value columns into multiple items • Support for specific SharePoint features: folders, meeting instances, item versions,…

  12. All the power of Reporting Services over your SharePoint Data Enesys RS Data Extension • Scalable Reporting platform. • Sophisticated reports: • Grouping, sorting, filtering, expressions, • Tables, Matrix, Tablix (2008), • Charts, • … • Execute reports from SharePoint when installed in integration mode. • Deliver reports to SharePoint document libraries, via email, … • Report subscription • Export to PDF, Excel, Word (2008), … • Extensible architecture…

  13. Evaluating Enesys RS Data Extension Enesys RS Data Extension • In order to build, design and preview reports, you do not need to install a report server. Business Intelligence Development Studio, the report’s authoring tool provided with Reporting Services, does not rely on the report server: • Install Business Intelligence Development Studio which is available on Microsoft SQL Server CD/DVD (start regular install and only select Business Development Intelligence Development Studio for installation). • Run Enesys RS Data Extension installation program which is available for download on our web site (http://www.enesyssoftware.com). It will automatically configure your Business Intelligence Development Studio installation. • Create your first report with the help of «  Enesys RS Data Extension in Action  » video. • For more information: • Check our web site http://www.enesyssoftware.com (various samples, videos and other information available). • Download a copy of our product’s documentation. • Ask a question to our support: support@enesys.fr.

More Related