Users
An unlimited number of users that work for your company can run reports
that use Enesys RS Data Extension as a data source.
| Unlimited | Unlimited | Unlimited |
Servers and CPU
Enesys RS Data Extension license is tied to a report server.
The Group Edition can be installed on one report server with 2 CPU
max.
The Standard Edition can be installed on one server with 4 CPU max.
The Enterprise Edition can be installed on any number of servers within
one company. There is no limit on the number of CPU for each server.
Dual-Core and Quad-Core processors count as one CPU.
| 1 Server / 2 CPU | 1 Server / 4 CPU | Unlimited Servers and CPU |
Developers
A developer is a user building a report using either Business
Intelligence Development Studio (Visual Studio) or Report Builder.
| 10 | 20 | Unlimited |
SharePoint Servers
With a single license, you can report over multiple SharePoint servers
owned and used by your company.
| Unlimited | Unlimited | Unlimited |
| Support and Upgrades |
|---|
Support
All licenses include a one year support. Technical support is offered
through our forum or by email.
The Group Edition license, includes a 48h guaranteed response time.
The Standard Edition license, includes a 24h guaranteed response
time.
The Enterprise Edition includes a 12h guaranteed response time. Support
may also be provided through GotoMeeting sessions for the Enterprise
Edition.
| 48h response time Mon-Fri, forum - email | 24h response time Mon-Fri, forum - email | 12h response time Mon-Fri, forum - email -
GotoMeeting |
Upgrades
By purchasing a license you are eligible to receive all major and minor
versions released within one year starting from the purchase date.
| 1 Year | 1 Year | 1 Year |
| Query Features |
|---|
Query Designer
A query designer integrated to Business Intelligence Development Studio
let's you build queries graphically.
| | | |
Lists, Document Libraries, Infopath Forms,...
Retrieve items from any SharePoint lists:
- Lists,
- Document libraries metadata,
- Infopath forms published fields,
| | | |
Multiple values columns
Enesys RS Data Extension allows you to break down an item that contains
multiple-values columns (lookup, choice, Person or groups) into multiple
items that will contain only one value in such column. You can therefore
easily have reports grouping on such columns.
| | | |
Recurring Events
Occurences of Recurring events are automatically generated from
recurrence definition. However, you can decide however to retrieve
events without expanding their occurences.
| | | |
Item Version
Enesys RS Data Extension let's you retrieve item versions.
| | | |
Folders
Enesys RS Data Extension has extensive support for list's folders. It
lets you query items into a specific folder, within a folder and its
subfolders or without taking account any folder.
| | | |
HTML Tags stripping
Enesys RS Data Extension can automatically strip HTML tags from
SharePoint Rich text fields. This feature is especially usefull with
Reporting Services 2005 which has no support for displaying HTML
tags.
| | | |
Meeting Instances
Support for retrieving items for all meeting instances or from a specific
instance.
| | | |
Roll Up Items
Roll up list items within an entire site collection. No need to specify
each site. The query will dynamically deal with any sub-sites that exist
at execution time.
| | | |
Merge Lists
Merge multiple lists from multiple site collections.
| | | |
SQL Server Data Integration (new in version 3.4)
Join and merge SQL Server data with SharePoint data by querying directly
over your SQL Server data bases.
| | | |
XML (new in version 3.1)
Integrate external XML data into your query.
| | | |
Join, Union, Group,...
Use SQL SELECT statement to further manipulate both your SharePoint lists
and external data.
| | | |
| Query SharePoint administrative data |
|---|
Site Collection
Provide detailed information about sites and sites collection.
| | | |
Site Permissions
Provides details on pemissions for a site or a set of sites.
| | | |
Site Columns
Provides details about Site Columns definitions.
| | | |
Content Types
Provides detailed information about Site's content types.
| | | |
Site Collection Groups
Provides detailed information about the SharePoint groups within a site
collection.
| | | |
List Collection
Provide detailed information about lists available in a site or a set of
sites.
| | | |
List Permissions
Provides detailed information about the permissions defined at the list
level.
| | | |
List Columns
Provide information about list's columns definition.
| | | |
| SQL Server Integration Services Components |
|---|
Enesys IS Data Extension
Standard and Enterprise Editions of Enesys RS Data Extension include a
license of Enesys IS Data Extension, our extension for SQL Server
Integration Services.
Note that the Standard Edition license, will allow you to run both
products providing that both products are installed on the same server.
This limitation does not apply to the Enterprise Edition.
| | | |
Query Designer and Features
Enesys IS Data Extension source component for Integration Services
provide a query designer and features similar to what is available with
Enesys RS Data Extension. You can therefore build complex queries to
retrieve items from SharePoint that can participate to your Integration
Services pipeline.
| | | |
Synchronization Components
Enesys IS Data Extension also offer a specific source and destination
component that makes it possible to synchronize a SharePoint list with a
SQL Server table.
| | | |
| | Group Edition | Standard Edition | Enterprise Edition |
|---|
| Product ID ...
| 300312115 | 300181728 | 300182213 |
| Price ... |
$1 450 / €1 060
|
$2 400 / €1 760
|
$9 200 / €6 600
|
Maintenance ...
Included in the initial purchase - for
subsequent years only.
| $300 / €200 | $600 / €400 | $2 300 / €1 600 |