Jul 20, 2016 8:06:21 PM by Julie Hyman
Toad Data Point version 4.0 is being released today! With each release of Toad Data Point we are focusing on adding enhancements requested by users which make connecting, querying and data prep easier for all of our users, regardless of your level of SQL expertise! Below are some of the exciting new features you can find in this release.
Various enhancements have been made to Toad Data Point connectivity
Transformation and Cleanse (T&C) is the easiest way to review and profile your initial result sets and define actions you want to take against the data to move it from that initial results stage to an analysis-ready format. We’ve put some effort into making T&C both easier to use and expanding the transformation actions available.
In the T&C window users can now isolate which data columns they see on the screen so they can focus their attention just where they need it.
Figure 1 - Show/Hide Columns lets users define what columns they want in their workspace
Users can also filter to specific patterns within the data with a simple double-click
Figure 2 - T&C Filter to a specific pattern
Users can also choose from 4 new transform types in T&C:
Figure 3 - T&C Rename Column
2. Remove Column: Gives users and easy way to remove columns from the final dataset
Figure 4 - T&C Remove Column
3. Split Column: Allows users to split a single column in up-to 10 new columns
Figure 5 - T&C Split Column
4. Extract Date: Allows users to extract elements such as year, quarter, month, day of week, etc from a date column into new columns
Figure 6 - T&C Extract Date
In Toad Data Point we have also introduce 2 new functions when creating calculated fields. Found under the “Miscellanous” group, “Next” and “Prior” allow users to build formulas that reference the values in the previous and next rows of data.
Figure 7- T&C Next and Prior functions
Toad Data Point now also allows users to reference the maximum date of a column or the minimum date of a column over a specified group of rows
Figure 8 - T&C ColMaxDate and ColMinDate
In the latest version of Toad Data Point you can now more easily save and organize your individual transformation steps or complete transformation sequences to make make them easier to reuse in the future against similar datasets. New features that have been added to this area are:
Figure 9- T&C Transforms Repository Window Enhancements
Now, when using Toad Intelligence Central v3.0, you can publish any and all of your useful transforms and transform sequences into Toad Intelligence Central where they can be browsed and downloaded by other Toad Data Point users. Using this common transforms repository allows you to share the knowledge of how data needs to be made ready for analysis with other Toad Data Point users and establish some quality guidelines so everyone has the opportunity to use the same methods and formulas.
Figure 10 - Searching, selecting and downloading from the T&C Common Repository on Toad Intelligence Central
The Dimensional Viewer in Toad Data Point has been greatly enhanced to allow more fully functioned use. Enhancements include:
Automation now contains a “Publish File” activity – meaning you can publish files (such as Excel workbooks) directly to Toad Intelligence Central as part of any automation workflow.
Figure 11 - Automation can now publish files to Toad Intelligence Central
In Toad Data Point , we have simplified the Import/Export windows so that you do not need to know if you are doing an import vs export beforehand – just simply click on the “Import/Export” icon on the ribbon bar and you will be guided through easy to understand questions to the correct functionality.
Figure 12- New easier import/export option on ribbon bar
Written by Julie Hyman
Julie Hyman is a Sr. Product Manager for Quest Software. Julie has 20+ years of experience in Development, Project Management and Product Management.