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
Resolved Issue / Enhancement
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.
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.
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.
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
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.
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.
When mapping objects upon initial connection or refresh, the schema name is now displayed along with the object name in the Background Process pane.
Corrected an issue that caused a “Value cannot be null” error when the schema name is uppercase.
Cached metadata is no longer cleared periodically. This gives the user the option to refresh object metadata only when necessary.
Database Explorer (Viewer)
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.