Toad® Data Point 4.3
Monday, October 16, 2017
The Toad Data Point Professional edition includes the following new features and enhancements.
Changes to Authentication Keys
This release includes an important change to Authentication keys. Beginning with Toad Data Point 4.3, a view can have only one type of key applied at a time (per data source), either a shared key or a personal key. This change is designed to simplify the process of Authentication. Please review the following details.
In summary, an object can have only one type of key applied at a time. A snapshot always has a shared key. A View can have either a personal key or a shared key, but not both.
Note: For cross-connection queries, each data source can have its own separate key type, either personal or shared.
Cross-Connection Query Optimization. This release of Toad Data Point includes a number of enhancements that optimize cross-connection query execution for improved performance.
The Base and the Professional editions of Toad Data Point contain the following new features and enhancements.
This release of Toad Data Point includes a redesigned Toad Pivot Grid with more functionality, a simplified workflow, an improved user interface, and an easy-to-use window layout.
New functionality includes exporting to an Excel pivot table
Enhanced Pivot Grid Window. The Pivot Grid window is now easier to use.
You can now build a pivot grid by dragging fields from the field list to the field Area directly below the field list. This is similar to the workflow and layout found in Excel. You can also drag fields directly to the pivot grid.
Export to Excel Pivot table. You can now export a pivot grid to Excel as an interactive Excel pivot table that includes the underlying result set. This provides you with a working pivot table in Excel along with the underlying data, allowing you to re-pivot result set data in Excel, if necessary.
Export to Excel Grid includes full rows. When exporting the summarized data to Excel as a data set (Excel Grid), the exported file now includes full rows of data wherever the pivot grid grouped data into merged cells.
Create a calculated field. You can now create a calculated field. Use the expression editor to build an expression used to calculate the new field. The calculated field is added to the field list.
Publish data to Intelligence Central. You can now publish pivoted data to Intelligence Central as a Dataset.
Edit the underlying query. You can now edit or execute the underlying query. Click Edit Query in the toolbar to open an editor pane where you can modify the query or execute it to preview data.
Customize field names. You can now rename fields to further customize your pivot grid to create meaningful reports when sharing the Pivot Grid or exporting to Excel or other document formats. Right-click a field and select Value Field Settings or Field Settings.
Customize Grand Total name. You can now rename the Grand Total fields. Right-click a Grand Total field name and select Rename Grand Total.
Workflow Enhancements. Frequently-used actions are now available through the right-click menu.
Easily change the way pivot grid values are summarized. Right-click a grid value or field and select Summarize Values By. For subtotaled fields, select Field Settings.
Easily change the way values are displayed. Right-click a grid value and select Show Values As.
Easily create and apply conditional formatting. Right-click the grid and select Format Rules | Manage Rules to open the Rules Manager. Create rules from predefined or custom conditions. Easily select cell background color, text appearance, etc.
Easily group columns or rows. Right-click a column (or row) header and select Group By.
In addition to the right-click menu, the Value Field Settings dialog can be used to specify all settings for a pivot grid (Data Area) field.
Right-click a pivot grid value or field and select Value Field Settings.
Backward Compatibility Information
In this release of Toad, the Pivot Grid tool allows you to edit and execute the underlying query. Toad Pivot Grid documents created and saved in this release of Toad include the connection information.
To upgrade a Toad Pivot Grid document created in a previous release of Toad, open the file in 4.3 and select a connection when prompted. Then execute the query (click Edit Query) and save the file.
Automation scripts with the Pivot Grid activity created and saved in a previous release of Toad are supported and should execute as expected when run using Toad Data Point 4.3.
Supported Data Set Size
If your result set contains a large number of rows (one million or more), you may experience a delay or reduced performance when sending data to, or working in, the Pivot Grid. For best results, work with a data set of less than one million rows. For larger data sets, try the following workaround.
Workaround: If your result set contains a large number of rows, build the pivot grid on a sampling of rows. Then use an Automation script to pivot all rows.
Aggregate Field in Calculated Column. In the Query Builder, the Aggregate field is now enabled for Calculated columns in the Criteria (lower) pane.
Note: Although the entire list of Aggregate functions is available, select only a function applicable to the current Calculated column to avoid a database error.
Set Variable Activity. In the list of available Date functions in the expression editor, the Date function Round() has been replaced with the function RoundDate(). The functionality is the same. The Math function Round() remains unchanged.
Activity Result Variable. Instead of an empty string, the value of the "_ACTIVITY_RESULT" variable is now set to "Succeeded" when an Automation activity does not error.
Specify Foreground Execution Timeout. You can now specify a timeout for the execution of a SQL statement on the foreground thread. To set this option, go to Tools | Options | Database | Timeout.
Export to Excel - Consistent Export Options Dialog. When exporting to Excel, Toad allows you to customize file and worksheet options for the exported Excel file. This feature is available when exporting to Excel from a number of different Toad modules, including the Select to File activity in Automation
Toad Security. Beginning with Toad Data Point 4.3, Toad Security is no longer available by default. The option to implement Toad Security (Tools | Administer | Toad Security) is not enabled. To enable Toad Security, see Quest Support.
Got a great idea for a new Toad Data Point feature or enhancement? Share it with the Development Team and the Community by posting it on Idea Pond.
Visit Toad Data Point - Idea Pond where you can submit your ideas. You can also read and vote on the enhancement ideas submitted by other Toad users.
Remember, you can find blogs, videos, and forums at the Toad Data Point Community.
© 2017 Quest Software Inc.
ALL RIGHTS RESERVED.
This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software Inc.
The information in this document is provided in connection with Quest Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest Software does not make any commitment to update the information contained in this document.
If you have any questions regarding your potential use of this material, contact:
Quest Software Inc.
Attn: LEGAL Dept
4 Polaris Way
Aliso Viejo, CA 92656
Refer to our web site (www.quest.com) for regional and international office information.
This product includes patent pending technology. For the most current information about applicable patents for this product, please visit our website at www.quest.com/legal.
Quest, Quest Software,