New Features
Changes 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.
- A similar change to Authentication key functionality is included in Toad Intelligence Central 4.3.
Toad Pivot Grid now has more functionality, a simplified workflow, improved user interface, and an easy-to-use window layout.
- New functionality includes exporting to an Excel pivot table, exporting data to Intelligence Central and Local Storage, and creating calculated columns.
- 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.
- The field Areas allow you to easily view which fields are applied to the grid, easily apply a filter to field values, and quickly change the field summary type, if necessary. By default, the field list is docked above the field Area for easy navigation. In addition, the layout of the pane is now customizable.
- 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.
- Export to Excel includes customization. You can now specify different options for the exported a number Excel file. This is similar to the customization available when exporting to Excel through the Export Wizard or the Select to File activity.
- 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.
- Add a field multiple times. You can now add the same field to a pivot grid multiple times.
- You can now save pivoted data to a new or existing table in Local Storage.
- You can now publish pivoted data to Intelligence Central as a Dataset.
- You can now export the pivot grid to an Excel pivot table. You can now export the pivoted data to
- You can now save the pivoted data to Local Storage.
- The Toad Pivot Grid file now includes the connection. The associated database connection is opened upon opening a saved Toad Pivot Grid file created in 4.3 (or later).
- You can now rename the Grand Total fields. Right-click a Grand Total field name and select Rename Grand Total.
*******
Additional information relating to the new features in version 4.3 can be found in the Toad Data Point 4.3 Release Notes or in the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)
