We have a patch release, Toad Data Point 4.2.1, available today. Here is a quick list of what is in this patch.
Resolved Issues in 4.2.1
Feature
Platform
Resolved Issue / Enhancement
Defect ID
Automation
N/A
Select to File and Export Wizard: Corrected an issue that was preventing Toad from completely clearing the worksheet before exporting to an existing Excel file when “Clear worksheet data before exporting” was selected. In this case, blank formatted rows remained after row count was reduced in subsequent exports.
QAT-10778, QAT-10863
Automation
N/A
Select to File: When specifying the export file, you can now select to use a macro-enabled Excel file type (.xlsm).
Note: The Select to File activity does not execute macros. To execute macros, continue to use the Export Wizard activity.
QAT-10781
Automation
N/A
Select to File: Corrected an issue that prevented successful generation of the file name date suffix in a script created in a previous version of Toad and run in batch mode. The date suffix format created in a previous version is now supported, as expected.
QAT-10859
Connections
Apache Hive
HiveServer2: Improved user experience upon initial connection to a large Hive data source. Toad now maps only the current schema to reduce the delay when presenting objects in the Object Explorer, especially when multiple large databases are involved.
QAT-10517, QAT-10557, QAT-10864
Connections
Apache Hive
You now have the option to manually refresh only one schema at a time. In the Object Explorer, right-click an object and select Refresh Schema. This enhancement applies to Hive and ODBC connections.
QAT-10869
Connections
Hive ODBC
Corrected an issue that prevented objects and schemas from displaying correctly in the Object Explorer. This issue also caused an error when attempting to execute unqualified SQL.
QAT-10870, QAT-10720
Connections
Apache Hive
When mapping objects upon initial connection or refresh, the schema name is now displayed along with the object name in the Background Process pane.
QAT-10871
Connections
Apache Hive
Corrected an issue that caused a “Value cannot be null” error when the schema name is uppercase.
QAT-10866, QAT-10717
Connections
Apache Hive
Cached metadata is no longer cleared periodically. This gives the user the option to refresh object metadata only when necessary.
QAT-10867, QAT-10764
Database Explorer (Viewer)
Salesforce
Enhancement: For Salesforce connections, you can now right-click the data grid in the Columns tab and copy cells/rows or export to Excel. This enhancement also applies to other (non-dimensional) Business Intelligence and NoSQL data sources.
QAT-10849