We are pleased to announce the release of Enesys RS Data Extension 3.3. In this new version, we have concentrated our development efforts on integrating our Graphical Query Builder directly within Business Intelligent Development Studio (Visual Studio interface). This new approach greatly enhances the process of building queries an reports over SharePoint data.
Enesys SharePoint Query Builder is now integrated with Business Intelligence Development Studio (both BIDS 2005 and 2008).
This approach brings several advantages over the separate Query Builder tool available in previous versions:
- No need to re-enter your Data Source properties when building a query with the separate Query Builder.
- No need to copy/paste/import your query from and to the separate Query Builder tool.
- Support for SPLogin credentials.
You have the choice to edit your query using either a Visual Query Builder or an XML editor (new in this version).
The Xml Editor allows the power users to write the query without using a visual interface.
New XML editor
When editing a query that contains syntactic elements not supported by the Visual Query Builder, you will be automatically put in XML editor mode. The XML editor provides intellisense features that simplify query editing. It is possible to toggle between the Visual Query Builder and the XML editor.
It supports Undo/Redo actions using its contextual menu:
SQL Editor
The editor available when editing a SELECT clause within a SqlQuery statement has been improved and offer Undo / Redo commands as well.
Those who are manipulating big SELECT clauses will also be happy to learn that the SQL code is not reformatted anymore each time you edit the query. Your own SQL code layout remains unchanged.
Other Query Builder improvements:
The Columns/Filtering/Sorting panel displays both the internal and display names of the columns.
A comment can be associated with each statement.
