Publish and Download Transform and Cleanse Rules
You can now publish transform and cleanse rules (transforms) to Intelligence Central to share with other Toad Data Point users.Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
Dataset Data Source Name
For published datasets, Toad now provides the data source name. You can find this information by viewing the dataset in the Database Explorer. In the Object Explorer, right-click the dataset and select View Details. Then select the Information tab.
Script Owner Can Delete Logs on Intelligence Central
In addition to the root user, the script owner can now delete the saved script execution logs for an Automation script running on Intelligence Central.
Notification of Automation Script Errors
If an Automation script errors when executed on Intelligence Central, notification of the error is included in the Daily Digest email sent to users with Manage privileges to the script.
Transform and Cleanse Data
You can now publish a Transform and Cleanse document to Intelligence Central (in addition to publishing your transformed data).
You can now hide columns from view in the Transform and Cleanse window. A new pane, Show/Hide Columns, opens on the left side of the window by default. Select only the columns you want to display. This is useful when your data grid contains a very large number of columns.
A new rule type allows you to remove one or more columns from the transformed data.
Toad Data Point is now certified by Cloudera.
-In addition, this release includes several enhancements to the Cloudera Impala ODBC connection.
-In the Object Explorer, Impala tables and Impala databases now display as expected.
-In the code completion dialog in the Editor, tables and databases are now displayed correctly in the treelist and include the correct icons.
You can now specify a response buffer size for a Teradata connection. This allows you to govern the number of rows returned in one response. Increasing the response buffer size might help to improve performance for large data sets. In the Teradata Connections Properties dialog, in the Advanced tab, enter a value in the Response buffer size field. By default, this value is set to the maximum value.
This release includes several enhancements to the Netezza ODBC connection.
-In this release, support for Netezza synonyms is improved. The Database Explorer (Viewer) now includes a Script tab for Netezza synonyms. In addition, the Query Builder now supports synonyms.
-Multi-line strings are now highlighted correctly.
-In the Import Wizard, when importing into a new table in Netezza 7.0.3 or later, you can now select a schema and a database.
The native SAP HANA connection in Toad now supports HANA Views (Analytic, Calculation, and Attribute). HANA Views are now visible in the Object Explorer and code completion list when using this type of connection.
Apache Hive (HiveServer2)
When creating a HiveServer2 connection, you can select a default schema to open upon connection. In addition, Toad now lists all available schemas in the Object Explorer allowing you to filter by a different schema after connecting.
-Index and partition information is now displayed for HiveServer2 objects in the Database Explorer.
Publish File Activity
This release includes a new Automation activity which allows you to publish one or more files to Intelligence Central. You can publish files produced by previous activities in the Automation script, or you can publish other existing files.
Additional information relating to the new features in version 4.0 can be found in the Toad Data Point 4.0 Release Notes or in the 'New in this release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)