What’s coming in Enesys Data Extension vNext? – Part 1

Form Based Authentication

In the next version of Enesys RS Data Extension (Standard and Enterprise Edition only), you will be able to query over SharePoint Sites configured with Form Based Authentication. The extension will automatically determine the authentication mode configured for the SharePoint site and and pass the appropriate credentials

Because Enesys IS Data Extension use the same core engine, it will also offer the possibility to query over FBA sites for extracting and transforming SharePoint lists date within SQL Server integration Services.

Easier Property Editing

As an alternative to the current approach for setting statements properties using the available property editor, the next version will also provide a better user experience with more engaging dialog boxes:

image image image image image

Improved Performance when retrieving Item Versions

In the current version, Enesys RS Data Extension will retrieve version information for all items you have selected in your list. This is obviously not a very efficient approach considering that retrieving item versions is a rater slow operation and that there is a few chances that you need to retrieve version information for all fields. In many cases, retrieving version information is mostly useful for getting an item’s comments history.

In the next version, it will be possible to specify the exact fields for which you would like to retrieve version information.

image

Data Source Variable and “SqlServerQuery” connection string

In the next version, it will be possible to use data source variables within the connection string of a SqlServerQuery statement (used for mixing SharePoint and SQL data).

That means that it will be possible to change the data base you are querying by updating a shared data source and without changing anything in the report. If you are running your reports over a test data base, only one change (in the data source) will be necessary to move them into production.