Enesys RS Data Extension

Enesys RS Data Extension is a Microsoft SQL Server Reporting Service Extension that lets you build reports from SharePoint lists data (MOSS 2007, WSS V3 & SharePoint 2010).

Enesys RS Data Extension lets you build sophisticated queries for joining, aggregating and rolling up data from any SharePoint list as well as document libraries and Infopath form libraries metadata. Its complete integration with Reporting Services lets you leverage all the power of Microsoft's reporting platform: SharePoint integration, multiple formats rendering (Word, PDF, Excel, ...), subscribing to reports that can be delivered through email or directly into SharePoint libraries,...

The power of Enesys RS Data Extension queries combined with Microsoft Reporting Services SharePoint integration features let's you replace advantageously custom web part developments.

Features

Unlock your SharePoint Data with Reporting Services Power

You don't have to learn a new tool to build stunning reports. Enesys RS Data Extension is completely integrated to Reporting Services in order to provide you with the perfect tool to join, aggregate and share your SharePoint Data. Its integrated Query Designer provides an innovative approach to match SharePoint lists data features.

Support SharePoint Lists Features

SharePoint lists are not just plain tables: they can have folders, multi-value fields, choice columns, recurring events, item versions, survey lists ... That's part of the magic that makes SharePoint lists quite powerful. Enesys RS Data Extension offers a solution to query data at the SharePoint conceptual level while offering the flexibility of a full-fledge query language.

Advanced Features

Enesys RS Data Extension provides advanced features that will turn your reports into real applications. You can dynamically aggregate lists from an entire site collection. You can merge an arbitrary set of lists. You can join your SharePoint lists with data from SQL Server databases, Oracle databases or Web Services. By using SQL SELECT syntax, you can re-arrange the data in your SharePoint lists to fit the specific needs of your reports.

Credentials, SharePoint Permissions and Authentication

Enesys RS Data Extension honors SharePoint permissions. It uses your report credentials settings to access SharePoint data. Moreover, Enesys RS Data Extension supports access to SharePoint Web Application configured in Forms Based Authentication type.