Add Business Intelligence to your SharePoint lists

The increasing adoption of SharePoint as an intuitive collaboration platform for users has spread business data over multiple sites and lists. At the same time, this has created the need to report and aggregate data from multiple SharePoint sites and lists to further increase the business value of this data.

Enesys RS Data Extension provides a solution to this demand by extending "Microsoft Reporting Services" and by letting you query (retrieve, join, merge,...) data and build reports from any SharePoint lists.

Design your query using our Visual Query Designer

Enesys RS Data Extension lets you build sophisticated queries over your SharePoint lists by using a Visual Query Designer that is completely integrated into Business Intelligence Development Studio. It supports many features that will let you get the most of your SharePoint data.

Support for specific SharePoint features like folders, recurring events, meeting instances, multi-value columns
Support for single and multi-values report's parameters
Roll up list's items within an entire site collection

Build your report with Microsoft Report's designer

No need to learn a new tool. Build your report using Microsoft's Report Designer and take advantage of its numerous features.

Sophisticated layout that lets you build dashboard views easily
Report's expression and interactive features
Extensive 2D and 3D charts and gauges controls
Flexible export features: Word, PDF, XML,...

Share your report for immediate availability to all users

Once your report is ready, it is only one click away from being available to all users.

With Reporting Services installed in SharePoint Integration mode, your reports are directly available within your sites.

Besides making it possible to provide live reports to users, Enesys RS Data Extension is also the perfect solution for solving business problems, by integrating and computing data from multiple lists, that would otherwise need the development of custom applications.

Sample Reports Gallery

Click on a thumbnail to display the report. The complete set of reports built over Microsoft Sales Lead Pipeline site template is available for downloading and ready to use.

Try it now!

You don't need a report server installation in order to test Enesys RS Data Extension.

Microsoft's Report Designer installed on your workstation is all you need to build and preview reports. It can be installed from SQL Server Installation CD by selecting Business Intelligence Development Studio.

Once it is installed, run Enesys RS Data Extension installation program, run the client configuration tool and you are ready to build reports over your SharePoint lists.

See it in Action

The following screen cast will show you the basics of creating reports using data from SharePoint lists.

Focus

Sales Lead Pipeline Reporting Solution

Discover how Enesys RS Data Extensioncan leverage your business data and transform your SharePoint sites into full featured applications.

Download the complete set or reports ready to run over the Sales Lead Pipeline application template provided by Microsoft. The detailed reports and dashboard views will let you manage your pipeline effectively and monitor your team performance accurately.

And if the provided reports are not enough...Just build a new one!

Build reports that join SQL data with SharePoint lists

Need to join SQL data with SharePoint lists? See how Enesys RS Data Extension 3.4 new "SqlServerQuery" statement makes it possible.

Testimonials

"A year and a half ago I volunteered to undertake a project that would support the collection of certain data associated with the rollout of a new version of our Kronos Workforce Management offerings. While SharePoint was an easy choice for the data repository, using it presented a challenge when it came to meeting the wide variety of reporting requirements associated with the project. The Enesys RS Data Extension tool proved to be a wonderful solution to those reporting challenges. Not only is it effective at unlocking access to the valuable data stored on our SharePoint sites, it is also fairly easy to use. You don't have to be a developer or hardcore programmer. Anyone with basic report writing experience can be up and running on it fairly quickly.

Following my initial experience, Enesys was adopted across our company and continues to help us unlock and utilize valuable SharePoint data. The number of reports created to date is in the thousands, and continues to grow daily.

In addition to finding Enesys a very effective tool, my experience with their Support organization has also been great. Whenever I do find the need to request assistance, Frederic, Marien, and team always provide a prompt and thorough response. Often times, in addition to providing the needed answers, they go above and beyond by offering alternative approaches and more efficient ways to accomplish something. I really do appreciate that!"

Bill Mulcahy
Corporate Account Manager
Kronos, Inc.

News & Blog

Configuring Kerberos Authentication

If you would like to run reports using Windows Integrated Security, that is using the credentials of the user running the report for retrieving SharePoint lists, you will most probably need to use Kerberos instead of NTLM for both your SharePoint and Reporting Services installations.

... (26/07/2010)

Improving report performance with item versions

Retrieving item versions is a time consuming operation. While working with a customer that needed a report (including comments history) for exporting data to excel, we could find a workaround that greatly improved the overall performance of the report.

... (21/07/2010)

Enesys RS Data Extension 3.4.6 Released

Enesys RS Data Extension 3.4.6 is a maintenance release that fixes a bug related to the use of Windows Integrated Security credentials. It is recommended to upgrade if you are using version 3.3.32 and upper. ... (20/07/2010)

More News