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.
Quick Tour: Reporting Services integration
Enesys RS Data Extension provides a complete integration with Reporting Services.
Reporting Services Integration
Enesys RS Data Extension extends Reporting Services so that you can benefit from all the
features provided by Microsoft's platform.
You don't have to learn an entire new tool to get all your data. In fact, all your
Reporting Services expertise and knowledge can be used with Enesys RS Data Extension.
The only thing that is specific to Enesys RS Data Extension is the query side of things.
And to get your life easier, we are providing a Query Designer that is completely
integrated to Business Intelligence Development Studio.
And if this is the first time you are using Reporting Services, just know that most of
what you will learn will be completely reusable for building reports using different data
Visual Query Designer
Enesys RS Data Extension Visual Query Designer will help you build sophisticated
Integrated Visual Query Designer
Enesys RS Data Extension Visual Query Designer makes it easy to build sophisticated
queries directly from within Microsoft Business Intelligence Development Studio.
Because Enesys RS Data Extension offers so many different features (query SharePoint
lists, roll-up lists in an entire site collection, query SQL or Oracle databases, and many
more features), the Visual Query Designer provides the necessary user interface that makes
it unecessary to remember every command and configuration settings.
It provides everything you need to build and test your queries with a few mouse
Innovative Query Approach
Enesys RS Data Extension provides an innovative query approach that won't limit the way
you can manipulate your lists data.
Innovative Query Approach to Match SharePoint Features
What makes SharePoint lists powerful is that they are not plain tables: you can easily
manage events, tasks, issues, etc. At the core of Enesys RS Data Extension is a Query
Engine that understands SharePoint concepts and features.
Enesys RS Data Extension will let you deal with all those specific SharePoint features.
You can retrieve item versions, multi-value fields, folders, etc... You can also aggregate
items from an entire site collection.
Besides the numerous SharePoint features that are exposed through our query engine, we
have taken a specific approach so that you can handle complex queries and merge SharePoint
data with external data. In fact, you can get multiple result sets (from SharePoint lists,
SQL Server tables, XML) and use SQL SELECT Syntax to manipulate your data into a dataset that you will use within
Support for Credentials and Report Parameters
Enesys RS Data Extension fully implements the Reporting Services Extension API to
provide a complete reporting experience.
Full featured Reporting Services extension
Enesys RS Data Extension is a full featured Reporting Services extension. It supports
Reporting Services credentials defined at the data source level.
Report's single-value and multi-value parameters are also fully supported at the query
level so that you don't have to retrieve unnecessary large number of items from your
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
Quick Tour: Aggregate lists from an entire site collection
Enesys RS Data Extension provides extensive features for rolling up items from an
entire site collection.
Aggregate Lists from an Entire Site Collection
The need of rolling up lists within an entire site collection is a common scenario. For
instance, you may have one site by project but still want to get all your project tasks
analyzed globally and displayed in a single report.
Enesys RS Data Extension provides a command that will let you aggregate lists in an
entire site collection. There is no need to update your query each time you create a new
sub-site. Items from new sites are automatically retrieved and displayed within your
Because Enesys RS Data Extension respects SharePoint permissions, a user will only get
items from the sites he has the necessary permissions, when running a report using
Quick Tour: Merge a set of Lists
Enesys RS Data Extension provides features for merging an arbitrary set of lists.
Merge an arbitray Set of Lists
In order to merge a specific set of lists from multiple sites or even sites collection
you can use Enesys RS Data Extension ListsMerge feature.
This feature lets you merge a set of lists returned by some other command (Enesys RS Data
Extension lets you use multiple commands in the same query). This means that you can use a
SharePoint list, a Database table or even some specific business logic to enumerate the
lists you would like to merge. No need to update your report to add or remove some
Advanced Data Manipulation
Use SQL SELECT syntax to manipulate your SharePoint data the way you want.
Advanced Data Manipulation
In order to let you manipulate your SharePoint data in all possible ways, Enesys RS Data
Extension comes with an innovative approach to query.
It lets you execute multiple commands that return data from SharePoint lists or other
sources (SQL Server, Oracle or XML data). In order to make sense of this data, Enesys RS
Data Extension lets you manipulate the data resulting from those commands using SQL SELECT
This approach is extremely flexible and offers advanced manipulation possibilities:
- Join multiple SharePoint lists, InfoPath forms and document libraries metadata
- Combine SharePoint data and SQL Server or Oracle data
- Aggregate data from multiple site collections
Mix SharePoint lists with SQL Server and Oracle Data
Enesys RS Data Extension lets you mix data from SharePoint lists, Microsoft SQL Server
Join SharePoint lists with SQL Server and Oracle data
Because it is extremely easy to create lists of event, tasks or issues, more and more
users will use SharePoint to track (or document) items that live in a database or an
Enesys RS Data Extension lets you query over SharePoint lists, SQL Server and Oracle
databases. Thanks to its advanced data manipulation features, you will be able to combine
SharePoint, SQL Server and Oracle data exactly the same way you can manipulate multiple
SharePoint lists by using join or union operators.
Retrieve XML Data
Enesys RS Data Extension lets you retrieve data from any URL that returns data in XML
Retrieve XML data
In order to offer even more possibilities, Enesys RS Data Extension lets you also query
any URL that returns XML data. For instance you can query existing RESTFul Web Services or
create your own web service or any web server page that returns XML data.
Using Enesys RS Data Extension advanced manipulation features, you can use the power of
SQL SELECT syntax in order to combine your XML data with SharePoint lists and SQL
This feature lets you include your very own business logic or some very specific data
sources into the mix and take advantage of Enesys RS Data Extension features.
Specify List Name or Site URL using Report Parameters
Build generic reports by specifying list and site name at run time using report
Specify List Name or Site URL using Report Parameters
Your report is not tied to a specific List or SharePoint Site. Enesys RS Data Extension
lets you use Report Parameters to specify your SharePoint list name and/or the relative
site URL of the list.
That means you can build generic reports that can be used with multiple lists or sites as
long as the list has all the fields specified in your query.
As an example of this approach, you can refer to our ready-made reporting solution that lets you build reports from any Survey list.
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.
Extensive Support for Credentials
Enesys RS Data Extension honours SharePoint permissions and supports Reporting Services
Credentials and SharePoint Permissions
One of the strength of SharePoint is that it brings permissions management at the
Business Manager level. Enesys RS Data Extension respects SharePoint
permissions. It will retrieve data using the Credentials settings you have configured at
the data source level.
By using Windows Authentication Integrated Security, you can ensure that
the user running the report will only get data for which he has the necessary SharePoint
On the other hand, by using Stored Credentials, you can allow users to
execute specific reports that will display data from SharePoint sites or lists for which
they do not have permissions.
Enesys RS Data Extension supports both Windows and Forms-Based authentication
Claims, Forms and Windows Authentication
Enesys RS Data Extension supports SharePoint Web Applications configured with Claims
(SharePoint 2010 only) and Classic authentication. Both Windows and
Forms-Based authentication types are supported.
When reporting over SharePoint Forms-Based web sites, you just need to set a single
property in the connection string.