Enesys RS Data Extension is a Data Processing Extension that makes it possible to use Microsoft SQL Server Reporting Services (2005 & 2008) for building reports over SharePoint lists data (MOSS 2007, WSS V3 & SharePoint 2010).

Enesys RS Data Extension lets you build sophisticated queries (join, union, roll up, merge external data,...) over any SharePoint list (as well as document and Infopath form libraries metadata) and use the result for building reports.

It's complete integration with Reporting Services lets you leverage all the power of Microsoft's reporting platform: SharePoint integration, multiple formats rendering (Word, PDF, Excel, ...), subscribe 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.

Why Choose?

Solve business problems in no time

Enesys RS Data Extension is a very flexible solution that makes it possible to answer most business needs at a fraction of the cost required by a custom development.

• Transform your SharePoint site into a full fledged application by building sophisticated reports that will provide the necessary dashbord views, join and calculate data, provide in-depth analysis of your data, ... This is what we have done with the "Sales Lead Pipeline" site application template reporting solution.
• Use subscription features to automatically receive reports that will let you know contracts or licenses to renew, important tasks to do, projects that need some attention, or any kind of alerts that involves business rules ...
• Provide limited access to specific SharePoint data. Because a report will execute using the credentials you specify and not necessarily the credentials of the user running the report, you can build reports that will display data from sites and lists for which users do not have permissions.
• If you need to export data from multiple sites and lists, including specific calculations or transformations, you can build a report in no time and use Reporting Services features to export the data into Excel or XML format.

SharePoint Integration mode

By using, SharePoint integration mode, your reports are completely integrated within your site.

• You provide permissions for accessing those reports the same way you provide permissions on documents.
• You can put your reports in different document libraries.
• You can add columns to organize your reports into categories and add some description.
• You can display a list of available reports using a web part as you would do for displaying a documents.
• You can click on any report and it will execute and display the resulting data. A report acts like a small application that can do calculation and join lists data.

Export

You can export your data into the various export format provided by Reporting Services and share the information with external users:

• Excel, PDF, etc.
• The Word export format available starting from Reporting Services 2008 makes it easy to create document that merge data from multiple SharePoint lists.

Subscription

Automatically deliver reports by email, to a shared folder or a SharePoint document library. This can be very handy for very large reports that take time to execute.

You can also use a SharePoint list containing subscribers information for data driven subscriptions.

Merge external data with SharePoint

Enesys RS Data Extension allows you to merge external data with SharePoint data by using the XmlQuery statement. This statement available starting from version 3.1 makes it possible to retrieve data by querying the URL you specify.You can therefore retrieve any specific data and join or merge this data with SharePoint list's data. You can address various scenarios using this approach:

• Join both SQL and SharePoint data,
• Reporting over specific SharePoint data like Property bags,
• Aggregate disparate specific data for which no data source is provided by Reporting Services,...

Support for specific SharePoint features

SharePoint lists are not just plain tables. Lists can have folders, multi-value fields, recurring events,... That's part of the magic that makes SharePoint lists quite powerfull. Enesys RS Data Extension makes it possible to retrieve :

• Occurences of recurring events,
• items in specific folders,
• meeting instances,
• item versions…
• Expand SharePoint multi-value columns to support grouping and analysis.

Microsoft SQL Server Reporting Services Centric

You don't have to install anything on your SharePoint server. Enesys RS Data Extension is installed as a Reporting Services extension.

Ready to use samples

Our package includes numerous samples. We are also providing additional samples and complete solutions on a regular basis.

Support & Upgrades

We understand the value of a good support. We offer a Monday to Friday support with a 12h to 48h response time depending on the Edition. Our customers will tell you, we often go beyond expectations.

We are providing major an minor upgrades on a regular basis.

The initial purchase price includes a one year maintenance. The maintenance includes support and access to all new versions.

30 Days free trial

Enesys RS Data Extension is easy to install and configure.

You can evaluate the product during 30 days and contact our support during the evaluation process. We will be pleased to help you with your specific scenario.