Thursday, October 19, 2017
Toad® Data Point is a multi-platform database query tool built for anyone who needs to access data, understand data relationships, and quickly produce reports.
With Toad Data Point, you can:
Toad Data Point provides a full-featured Database Explorer, Query Builder, and Editor for the following databases:
Toad Data Point also provides querying and reporting functionality via the following provider types:
The purpose of the ODBC provider is to offer basic connection and querying capabilities to any database that supports an ODBC 3.0 or later driver. For a list of databases tested with the ODBC provider, see the System Requirements in the Release Notes. This form of connectivity allows connections to databases such as Netezza, IBM iSeries, Ingres, and Vertica™. Because this form of connectivity is generic, it is not full-featured and may not be as robust as the fully-exploited providers for the other databases.
Business Intelligence and NoSQL Data Sources
Toad Data Point provides users with the ability to connect to non-traditional data sources, such as Business Intelligence and NoSQL sources. You can connect to these data sources and explore data and objects, query data, report results, and automate tasks.
The following data sources are supported:
Oracle Business Intelligence Enterprise Edition (OBIEE), SAP Business Objects™, Salesforce®, Microsoft SQL Server Analysis Services, Google Analytics™, OData, and SharePoint®
Azure Table Services, Cassandra™, Cloudera Impala, DynamoDB, HBASE™, Hive™, MongoDB™
The Toad Data Point Professional edition includes the following new features and enhancements.
Changes to Authentication Keys
This release includes an important change 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. Please review the following details.
In summary, an object can have only one type of key applied at a time. A snapshot always has a shared key. A View can have either a personal key or a shared key, but not both.
Note: For cross-connection queries, each data source can have its own separate key type, either personal or shared.
Cross-Connection Query Optimization. This release of Toad Data Point includes a number of enhancements that optimize cross-connection query execution for improved performance.
The Base and the Professional editions of Toad Data Point contain the following new features and enhancements.
This release of Toad Data Point includes a redesigned Toad Pivot Grid with more functionality, a simplified workflow, an improved user interface, and an easy-to-use window layout.
New functionality includes exporting to an Excel pivot table
Enhanced Pivot Grid Window. 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.
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.
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.
Publish data to Intelligence Central. You can now publish pivoted data to Intelligence Central as a Dataset.
Edit the underlying query. You can now edit or execute the underlying query. Click Edit Query in the toolbar to open an editor pane where you can modify the query or execute it to preview data.
Customize field names. You can now rename fields to further customize your pivot grid to create meaningful reports when sharing the Pivot Grid or exporting to Excel or other document formats. Right-click a field and select Value Field Settings or Field Settings.
Customize Grand Total name. You can now rename the Grand Total fields. Right-click a Grand Total field name and select Rename Grand Total.
Workflow Enhancements. Frequently-used actions are now available through the right-click menu.
Easily change the way pivot grid values are summarized. Right-click a grid value or field and select Summarize Values By. For subtotaled fields, select Field Settings.
Easily change the way values are displayed. Right-click a grid value and select Show Values As.
Easily create and apply conditional formatting. Right-click the grid and select Format Rules | Manage Rules to open the Rules Manager. Create rules from predefined or custom conditions. Easily select cell background color, text appearance, etc.
Easily group columns or rows. Right-click a column (or row) header and select Group By.
In addition to the right-click menu, the Value Field Settings dialog can be used to specify all settings for a pivot grid (Data Area) field.
Right-click a pivot grid value or field and select Value Field Settings.
Backward Compatibility Information
In this release of Toad, the Pivot Grid tool allows you to edit and execute the underlying query. Toad Pivot Grid documents created and saved in this release of Toad include the connection information.
To upgrade a Toad Pivot Grid document created in a previous release of Toad, open the file in 4.3 and select a connection when prompted. Then execute the query (click Edit Query) and save the file.
Automation scripts with the Pivot Grid activity created and saved in a previous release of Toad are supported and should execute as expected when run using Toad Data Point 4.3.
Supported Data Set Size
If your result set contains a large number of rows (one million or more), you may experience a delay or reduced performance when sending data to, or working in, the Pivot Grid. For best results, work with a data set of less than one million rows. For larger data sets, try the following workaround.
Workaround: If your result set contains a large number of rows, build the pivot grid on a sampling of rows. Then use an Automation script to pivot all rows.
Aggregate Field in Calculated Column. In the Query Builder, the Aggregate field is now enabled for Calculated columns in the Criteria (lower) pane.
Note: Although the entire list of Aggregate functions is available, select only a function applicable to the current Calculated column to avoid a database error.
Set Variable Activity. In the list of available Date functions in the expression editor, the Date function Round() has been replaced with the function RoundDate(). The functionality is the same. The Math function Round() remains unchanged.
Activity Result Variable. Instead of an empty string, the value of the "_ACTIVITY_RESULT" variable is now set to "Succeeded" when an Automation activity does not error.
Specify Foreground Execution Timeout. You can now specify a timeout for the execution of a SQL statement on the foreground thread. To set this option, go to Tools | Options | Database | Timeout.
Export to Excel - Consistent Export Options Dialog. When exporting to Excel, Toad allows you to customize file and worksheet options for the exported Excel file. This feature is available when exporting to Excel from a number of different Toad modules, including the Select to File activity in Automation
Toad Security. Beginning with Toad Data Point 4.3, Toad Security is no longer available by default. The option to implement Toad Security (Tools | Administer | Toad Security) is not enabled. To enable Toad Security, see Quest Support.
See Resolved Issues for more enhancements and resolved issues in this release of Toad Data Point.
Got a great idea for a new Toad Data Point feature or enhancement? Share it with the Development Team and the Community by posting it on Idea Pond.
Visit Toad Data Point - Idea Pond where you can submit your ideas. You can also read and vote on the enhancement ideas submitted by other Toad users.
Remember, you can find blogs, videos, and forums at the Toad Data Point Community.
The following is a list of issues addressed and enhancements implemented in this release of Toad Data Point.
|Feature||Platform||Resolved Issue / Enhancement||Defect ID|
|Automation||N/A||The drive letter in a network path is now translated to the full UNC name in a scheduled Automation script, as expected.||QAT-10197|
|Automation||N/A||Enhancement: Instead of an empty string, the value of the "_ACTIVITY_RESULT" variable is now set to "Succeeded" when an Automation activity does not error.||QAT-10230|
|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. This correction is also in Toad Data Point 4.2.1.||QAT-10778, QAT-10863|
|Automation||N/A||Export Wizard activity: If this activity exports to a macro-enabled Excel file, when the script is executed and the file does not exist, Toad now displays a descriptive error message instead of creating a blank .xlsm file.||QAT-10688, QAT-10774|
|Automation||N/A||Dimensional Viewer activity: Corrected an issue which prevented the export of Calculated columns and Rollup columns when exporting to Excel.||QAT-10399|
|Automation||N/A||Set Variable activity: Added helpful messages and tooltips hints that display if a date value is entered and requires single quotes.||QAT-10547|
|Automation||N/A||Refresh Snapshot activity: If snapshot refresh errors when source table does not exist, the error is now reported in the script execution log, there is no error dialog, and the script fails.||QAT-10305|
|Automation||N/A||Dimensional Viewer activity: Corrected an issue that caused an "Index out of range" error when executing a Dimensional Viewer activity after switching the Dimensional View file.||QAT-10295|
|Automation||N/A||Set Variable activity: Corrected an issue that caused an error when attempting to execute a script in which a variable was defined using the function, Round(). In the Expression editor, the Date function Round() has been renamed to RoundDate().||QAT-10795|
|Automation||Oracle||Select to File activity: If multiple queries are used, each query now exports to a separate worksheet, even when the overwrite and the add suffix options are selected.||QAT-10553|
|Automation||N/A||Run Automation Script activity: Corrected an issue that caused a "This file was not available at runtime" error when running a script in batch mode that contains a Run Automation Script activity and was created in a previous version of Toad.||QAT-10508|
|Automation||Oracle||Set Variable activity: Corrected an issue in which the Set Variable activity evaluated a string value that included a date format using the forward slash delimiter (/) as an expression.||QAT-11011|
|Automation||N/A||Corrected an issue in which an Automation script failed to error even though the connection in the Loop Dataset activity failed to connect.||QAT-10298|
|Automation||Oracle||Export Wizard activity: If the Export Wizard activity connection does not have a saved password, the Automation script errors as expected, instead of prompting the user by opening a dialog.||QAT-10996|
|Automation||N/A||Execute Script activity: If you attempt to publish a table that does not exist to Intelligence Central using the Execute Script activity, you now encounter an informative error message.||QAT-10984|
|Automation||N/A||Execute Script activity: Corrected an issue that caused an error message dialog to open instead of presenting the error message in the log file only, as expected for an Automation script.||QAT-10960|
|Automation||N/A||Set Variable activity: Using the DateTime Variable type and a single-quoted value is now supported as a bind in the Bind Parameters dialog and when used in a SQL statement.||QAT-10962|
|Automation||N/A||Toad provides a more helpful error message now when an activity uses a file (such as a Toad document) and the file is missing at run time.||QAT-10306|
|Automation||N/A||Corrected an issue in which a date value in a string variable was surrounded by single-quotes when expressed in a file name (i.e., filename_#MyVar#.xlsx was expressed as filename_'datevalue'.xlsx).||QAT-10709|
|Automation||N/A||Pivot Grid activity: You can now export to Excel and append sheets to the same Excel file upon subsequent executions.||QAT-10701|
|Automation||N/A||Compare Data activity: Corrected an issue that caused a "File in use" error when running two Data Compare scripts simultaneously.||QAT-10789|
|Automation||N/A||Corrected an issue that caused an FTP connection error to be written to the Windows Event Log upon execution of a script containing an FTP connection.||QAT-11234|
|Automation||N/A||Select to File activity: Corrected an issue that prevented Toad from notifying the user that there is an undefined variable if the query is originating from a linked SQL file.||QAT-11418|
|Automation||N/A||Select to File activity: You can once again use the Expression editor to build a file name suffix.||QAT-11058|
|Automation||N/A||Select to File activity: Corrected an issue involving using a suffix in the file name and the Overwrite option.||QAT-11434, QAT-11394|
|Automation||N/A||Loop Dataset activity: Corrected an issue that caused an error in the Loop Dataset activity when the SQL included a comment.||QAT-11415|
|Automation||N/A||Corrected an issue that caused Toad to incorrectly interpret a variable string value that contained a dash (-) or forward slash (/).||QAT-11166|
|Connections||Composite ODBC||Corrected an issue that resulted in incorrect data values in TINY INT columns when displayed in Toad.||QAT-10694|
|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||SAP ASE||In the SAP ASE Connection Properties dialog, you can now specify a default language to use for the connection. This value overrides your Regional Language setting, for this connection only.||QAT-10368|
|Connections||SAP HANA||This release of Toad Data Point was tested against SAP HANA 2.0.||QAT-10605|
|Connections||Oracle||This release of Toad Data Point was tested against Oracle 12c R2.||QAT-10512|
|Connections||Oracle||Corrected an issue in which the user was prompted to commit data after closing a connection even though no data was changed. This issue also occurred when closing Toad or when a connection was idle for an extended time period.||QAT-10851|
|Connections||Amazon Redshift ODBC||This release of Toad Data Point was tested with Amazon Redshift ODBC driver 188.8.131.520.||QAT-11160|
|Connections||Business Intelligence, NoSQL||Added an enhancement to improve mapping objects with very large row size from Business Intelligence and NoSQL data sources.||QAT-10847|
|Connections||Amazon Redshift ODBC||Enhanced the Redshift ODBC connection to include the same features as a PostgreSQL connection.||QAT-11161|
|Connections||PostgreSQL ODBC||Added support for PostgreSQL and Oracle non-standard passwords. For PostgreSQL, enclose password in curly brackets.||QAT-11185|
|Connections||SAP ASE||Corrected an issue that caused "Domain error during conversion of INT value '0' to a BIT field" error in a SAP ASE connection when switching between databases.||QAT-11655|
|Connections||Ingres ODBC||Corrected an issue that resulted in an error when trying to save changes to date fields through the data grid.||QAT-11740|
|Cross-Connection Query||Teradata||Corrected an issue that caused an error when attempting to execute a cross-connection query with an LDAP connection to Teradata.||QAT-6740|
|Data Compare||N/A||Corrected an issue in which cell formatting was not retained when data was exported to Excel.||QAT-10194|
|Data Compare||N/A||You can now resize the Data Compare Wizard window.||QAT-11326|
|Data Grid||N/A||Corrected an issue that caused some number columns to be treated as string values, for example when filtering or sorting, and to be displayed left-justified instead of right-justified.||QAT-11107|
|Database Explorer||Teradata||For Teradata Views, the column type is now displayed in the Columns tab, as expected.||QAT-10410|
|Dimensional Viewer||Cross-Connection||Corrected an issue that caused an error when refreshing after the underlying query was modified to now include a cross-connection query.||QAT-10247|
|Documentation||N/A||The Beta Release Notes now include the resolved issues from previous Beta releases.||QAT-10949|
|ER Diagram||N/A||Corrected an issue that caused an error when attempting to edit a Database Diagram (ER Diagram) file.||QAT-11564|
|Export Wizard||N/A||Export to macro-enabled Excel: Corrected an issue that changed the order in which macros execute after opening the Export Wizard template.||QAT-10903|
|Export Wizard||N/A||When opening an existing template which exported multiple objects to separate worksheets, the Export Options page did not show the correct target worksheet for each object. This issue has been corrected.||QAT-10122, QAT-11018|
|Export Wizard||N/A||Corrected an issue in which exporting to Excel produced a file where CTRL+END moved to an empty row after the last populated row. Now CTRL+END moves to the last populated cell in an Excel export file as expected.||QAT-10973|
|Export Wizard||N/A||Refined some workflow steps when selecting a Query or Query file from which to export. Refined steps include editing the query and using the Back button.||QAT-2075|
|Export Wizard||N/A||When exporting multiple objects and you choose to include the SQL statements in the output file, all SQL statements selected are now included in the exported file, as expected.||QAT-10976|
|Export Wizard||N/A||When exporting a very large SQL statement to Excel, the statement is now exported to multiple cells in order to include the entire statement and comply with Excel's 32,767 character limit.||QAT-10977|
|Export Wizard||Microsoft Access||You can use a variable (#MyVar#) in the Access table name.||QAT-11115|
|Export Wizard||Teradata||Corrected an issue that caused export to fail in the Export Wizard when using a bind parameter. The error message includes the following: "A null has been specified as the value for a parameter."||QAT-11777|
|General||N/A||Toad Security is now disabled by default. To enable Toad Security, contact Quest Support.||QAT-9887|
|General||N/A||Corrected an issue that caused an error when attempting to view column information for a table when the table name was a MySQL reserved word.||QAT-8531|
|Import Wizard||SAP ASE||Corrected an issue that caused an error when attempting to import data into an identity column in an existing table. The issue involved the "Identity Inserts" option in the Import Wizard.||QAT-10370|
|Installation||N/A||Corrected an issue that cause a "Could not load the DLL library ...TempCustomActions.dll" error during installation for some users in a Windows 7 environment.||QAT-10707|
|Job Manager||N/A||Corrected an issue that caused an error in the Task List pane in the Job Manager window when attempting to use the Job Manager.||QAT-10492|
|Job Manager||N/A||Corrected an issue that caused an error in the Job Manager. The error occurred after selecting a computer/server in the Windows Tasks tab.||QAT-10780|
|Migration||N/A||Customized toolbars are now migrated correctly from the previous version when a new version is installed.||QAT-10676|
|Migration||SQL Server||Customized Editor Highlighting Styles for SQL Server are now migrated correctly from the previous version when a new version is installed.||QAT-10621|
|Migration||N/A||Corrected an issue that prevented several user settings files from migrating correctly from a previous version when a new version was installed.||QAT-10979|
|Object Explorer||SAP IQ||Support for Int and Integer for column type in the Create Table editor.||QAT-10356|
|Options||N/A||Corrected an issue that for some users caused an error after clicking "Restore Defaults" in the Options dialog.||QAT-11195|
|Pivot Grid||N/A||You can now edit the "Grand Total" label in a pivot grid.||QAT-10721|
|Pivot Grid||N/A||Enhancement: You can now export to an Excel pivot table from a Toad Pivot Grid.||QAT-8334|
|Pivot Grid||Oracle||Corrected an issue that prevented values from being displayed for a calculated column which did not have an alias.||QAT-9178|
|Pivot Grid||N/A||Corrected an issue in which the underlying query was not sent to the Pivot Grid along with the result set from the Query Builder.||QAT-11038|
|Query Builder||N/A||Corrected an issue where upper/lower case was used inconsistently when applying and referencing the name of a calculated field.||QAT-9997|
|Query Builder||Oracle Cross-Connection||Corrected an issue that caused an "Invalid data source definition: ORA-01005" error when attempting to view the Venn diagram for a join in an Oracle cross-connection. This issue occurred with an Oracle connection using Windows Authentication.||QAT-10695|
|Query Builder||Teradata||Corrected an issue that resulted in additional quotes around date values in the WHERE clause for the query generated in the Query tab.||QAT-11186|
|Query Builder||N/A||User Interface: When the Query Builder Diagram contains multiple joins, attempting to remove a join removes the selected join as expected.||QAT-11491|
|Query Builder||N/A||Corrected an issue in which Toad removed the "NOT" operator in this special case after the user attempted to Visualize the SQL statement after pasting it into the Query tab of the Query Builder.||QAT-10752|
|Query Builder||Netezza||Added support for reverse engineering for Netezza connections.||QAT-11796|
|SQL Editor||N/A||Corrected an issue that prevented some users from successfully opening a .sql file while Toad had an open connection. In this case, Toad would unexpectedly hang. This issue was encountered with a MySQL connection.||QAT-10502|
|SQL Editor||N/A||Corrected an issue that caused an unexpected delay for some users when attempting to execute SQL in the SQL Editor. This issue was encountered with an Oracle connection.||QAT-10850|
|SQL Editor||IBM DB2 LUW||Corrected an issue that caused Toad to pause indefinitely after applying the row limit to the Editor in Options | Database | General and then executing a query in the Editor. This issue was encountered only with an IBM DB2 LUW connection.||QAT-11250|
|SQL Editor||N/A||A SQL Editor custom toolbar is now migrated when you upgrade to a new release of Toad if the bitness is the same. Note: A custom toolbar is not migrated if upgrading to different bitness of Toad, i.e., 32-bit to 64-bit or vice versa.||QAT-11377|
|Toad Intelligence Central||N/A||Run Automation Script activity: When publishing a script containing a Run Automation Script activity and the child script includes a connection, the connection is now included in the Publishing dialog and the published script as expected.||QAT-10427, QAT-10010|
|Toad Intelligence Central||N/A||You can no longer publish an Automation script that uses a macro-enable Excel file if the file is stored locally. To successfully publish, the .xlsm file must use a Network path.||QAT-10688, QAT-10774|
|Toad Intelligence Central||N/A||If an Automation Script running in Intelligence Central executes a macro in an Excel spreadsheet, then Microsoft Excel must be installed on the Intelligence Central host computer. If Excel is not installed, Toad now displays a descriptive error message.||QAT-10688, QAT-10774|
|Toad Intelligence Central||N/A||Automation - Dimensional Viewer activity: Corrected an issue that caused the connection information in the "Export to Intelligence Central" fields in this activity to be included in the Publishing dialog, even the fields were disabled by the user.||QAT-10294|
|Toad Intelligence Central||N/A||Automation - Dimensional Viewer activity: Corrected an issue that prevented the user from publishing a script in which the Dimensional Viewer file used a cross-connection query. A message displayed indicating the script contained a Local Storage connection.||QAT-10293|
|Toad Intelligence Central||N/A||Enhancement: You can now easily edit an object description. In the Object Explorer, right-click an object and select Operations | Edit Description.||QAT-7277|
|Toad Intelligence Central||SAP IQ, SAP HANA||Corrected an issue that caused an error when attempting to publish a view containing a bind variable to Intelligence Central from an SAP IQ or SAP HANA connection.||QAT-10333|
|Toad Intelligence Central||N/A||Significantly improved performance when publishing a very large number of rows (in this case, more than one million) as a View to Intelligence Central.||QAT-10440|
|Toad Intelligence Central||N/A||Corrected an issue that caused a Timeout error when attempting to publish a very large number of rows to Intelligence Central as a dataset or as a snapshot.||QAT-10908|
|Toad Intelligence Central||Oracle||You now encounter an error if attempting to publish an unsupported data type. Previously this issue resulted in publishing an object with an inaccurate number of rows. This issue was encountered when publishing a View.||QAT-10099|
|Toad Intelligence Central||N/A||If an Automation Script running in Intelligence Central executes a macro in an Excel spreadsheet and the user account specified to run this script is not configured to execute macros in Excel, Toad now displays a descriptive error message. Instructions to resolve this issue are now included in the Help file.||QAT-10993, QAT-10688|
|Toad Intelligence Central||SQL Server||You cannot publish from a SQL Server connection that uses Windows Authentication. If you attempt to do so, the Publishing dialog now provides an informative error message.||QAT-10066|
|Toad Intelligence Central||SQL Server||To successfully publish from a SQL Server connection that uses SQL Server Authentication, the SQL Server user account must have db_datareader privileges and the view permission.||QAT-10066|
|Toad Intelligence Central||Oracle||You cannot publish from an Oracle connection that uses Windows Authentication. If you attempt to do so, the Publishing dialog now displays an informative message.||QAT-10942|
|Toad Intelligence Central||Oracle||Corrected an issue which prevented the user's Oracle ODBC driver from displaying in the Oracle drop-down list in the Advanced tab of the Intelligence Central Connection Properties dialog.||QAT-11155|
|Toad Intelligence Central||Oracle||Corrected an issue that prevented publishing from an Oracle table with a non-standard, lower-case name.||QAT-11172|
|Toad Intelligence Central||N/A||Corrected an issue that prevented successful publishing for SQL containing a WITH clause. Now a WITH clause can be published, with some restrictions (see the online Help). This issue was encountered when publishing an Oracle WITH clause.||QAT-11159|
|Toad Intelligence Central||N/A||Corrected an issue that caused only a partial refresh of the Automation scripts window after pressing F5 (Refresh).||QAT-11252|
|Toad Views||N/A||Creating a new Toad View by right-clicking and selecting "New Toad View" in the Toad View manager pane now works as expected.||QAT-10959|
|Transform and Cleanse||N/A||Corrected an issue that could cause an error message to display when closing Toad after using the Transform and Cleanse or the Data Profiling tool.||QAT-10967|
|User Interface||N/A||In the File | Recent Files list and the Recent Documents list, the entire file name is now displayed.||QAT-9830|
|User Interface||N/A||Dimensional Viewer: The Detail Grid window (right-click | Show Details) now includes a horizontal scroll bar for easier viewing.||QAT-8571|
|User Interface||N/A||Corrected spelling error in an ODBC message.||QAT-10981|
|User Interface||N/A||Corrected an issue which for some users caused an inactive SQL Editor window to unexpectedly gain focus even though another window was active at the time.||QAT-10419|
Note: This list does not include every resolved issue for this release. To inquiry about an issue not listed here, please contact the Toad Data Point Team at the Toad Data Point community Web site.
Toad Intelligence Central: If you are publishing objects to Intelligence Central, review the Toad Intelligence Central - Release Notes.
The following is a list of issues known to exist at the time of this release.
Currently, if you open a Toad file in Toad Data Point 3.0 or later that contains a connection to Sybase ASE and was saved in Toad for Data Analysts 2.7 (or earlier) the file opens in an untitled Editor window. Use the following workaround which is for a Query Builder file, but a similar method can be used for any Toad file.
|General||Excel||If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662.||ST42486|
After successfully changing the password or token for a Salesforce connection in Toad, attempting to open a Toad document created in a previous version (3.7 or earlier) using this connection results in a "Could not resolve connection" error.
Workaround: Recreate the Toad document (Import/Export template, Query Builder file, Automation script, etc.) using Toad Data Point 3.8 or later.
(MSI installs on Windows Vista and 7) If you are using MSI to install Toad on Windows Vista or 7 with UAC enabled, you can install a file that adds a "Run as administrator" option when right-clicking the MSI file:
Toad Data Point does not support installation paths that contain UNICODE characters.
|Toad Data Point 3.0 or later doesn’t support User IDs that contain Unicode characters.||ST90367, ST90372|
|The Toad Data Point Read Only installation is read-only for all databases, with the exception of MySQL. If you are using a Read Only installation of Toad Data Point, you will be able to modify a MySQL (and only MySQL) database.||N/A|
Currently, you cannot install Toad Data Point to a path that contains non-English characters. By default, Toad Data Point installs IBM DB2 merge modules as part of the standard installation process. These merge modules only support English characters.
Workaround (Stand-alone installation):
During installation on Windows 8, some users might encounter a prompt from Windows to install .Net Framework 3.5.
Workaround: In the Windows prompt, click Skip this installation to instruct Windows Not to install .Net Framework 3.5.
(Windows Vista on Toad client only) From the Client Configuration Wizard, when exporting the DB2 catalog profile as a standard user, the profile should be saved to the default installation directory in C:\Program Files\.
However, a standard user does not have write privileges in Vista to C:\Program Files so the catalog profile is saved to the following directory instead:
C:\Users\db2admin\AppData\Local\VirtualStore\Program Files\Quest Software\Toad Data Point 4.3
Currently, Toad does not support ODBC connections to the following databases:
Currently, for a password-protected Access database, selecting Save password in the Connection Properties dialog does not preserve the password for the next Toad session.
Note: This will allow you to connect to the database and save the password for this session of Toad. Repeat the procedure if you re-launch Toad.
When using the Vertica ODBC driver version 6.1.1, data containing UTE-8 characters does not display correctly.
Workaround: Right-click the Vertica ODBC connection in the Connections Manager and select Properties. In the Connection Properties dialog, in the General tab, enter the following in the ConnectionString field:
|Connections||Amazon Redshift||You might experience problems after a Redshift connection is unexpectedly dropped.||QAT-2194|
|Connections||Amazon Redshift||After canceling a Redshift query it might continue to run on the server.||QAT-2195|
When a Redshift connection in Toad is inactive for a period of time, attempting to access the connection can result in an error.
Workaround: Change the Windows TCP/IP timeout settings as recommended by Redshift. See "To change TCP/IP timeout settings" at http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-firewall-guidance.html.
Caution: Editing your Registry incorrectly can cause serious, system-wide problems. It is advised that you back up your registry before modifying it.
Exported connections: A connection file exported from Toad Data Point 3.6 or later cannot be imported into version 3.5 or earlier.
|Connections||MongoDB||For a MongoDB 3.0 (or later) connection, the user must have Read/Write privileges in the MongoDB database in order to view sub-tables (MongoDB embedded documents).||
If Toad Data Point 4.3 is launched as administrator on Windows 7/Vista systems with UAC turned on and Outlook running, the auto-populate SMTP server info and contact list in Automation Email and Error Emails does not function properly.
Submit this information manually. Another option is to either run Toad Data Point 4.3 not as administrator, or turn UAC off, or close Outlook when adding the Send Email activity in Automation.
When Toad runs as an application in a Citrix environment, scheduled scripts might not execute if the user who scheduled the tasks is not logged on. In addition, an "Access Denied" error is logged for the scheduled task in the Windows Scheduler.
Workaround: Install and run Toad as a desktop when using Toad with Citrix.
ODBC - Ingress
In some cases, earlier Ingress ODBC drivers display an "Invalid number of columns or parameters specified" error message when displaying data that has Unicode characters.
|Execution Plan||SQL Server||
You cannot generate an estimated execution plan for a local temporary table because the execution plan uses a different connection to generate the plan and does not know about the temp table.
|Export Wizard/ One Click Export||Access, Excel
Limitations when exporting fractional seconds:
Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error.
|Attempting to import data from a template that contains multiple worksheets results in an error.
ODBC - DB2 iSeries, Netezza
Currently, the Truncate table checkbox is disabled on the Select Target page when using an ODBC connection to a DB2 iSeries or Netezza database.
|Oracle, DB2||When importing data using the Add Query feature, BLOB data is not imported even though the dialog and log indicate that the import was successful.||ST77255|
A UAC setting at the highest level might interfere with the ability to drag a file to the Library window (from Windows Explorer) to add it to the Library.
Workaround: Set UAC to the default level to enable adding a file by dragging it to the Library window.
Issue: Local Storage is incompatible with previous versions of Toad.
If you upgrade to Toad Data Point 3.6 from a previous version, Local Storage upgrades silently and can no longer be used by the previous version of Toad Data Point (3.5 or earlier).
If you plan to uninstall 3.6 after installing it and then resume using a previous version, backup your Local Storage data prior to installing 3.6.
To backup Local Storage data
|Object Explorer/ Database Explorer||Sybase ASE||When viewing a table that contains a BIGTIME data type column, attempting to select the Data tab causes Toad to unexpectedly quit.||
|Object Explorer/ Database Explorer||Sybase ASE||Currently, only foreign key constraints can be added or modified for existing Sybase ASE tables.||ST55111|
On the Create/Alter User window, if you are modifying a password, you must enter the password in the proper case. You do not need to surround the password with double quotes.
If you enter the password in lowercase on the Create/Alter User window, and the generated script has a SQL command containing the password in lowercase, you will need to type the password in lowercase to login.
If you enter the password in uppercase on the Create/Alter User window, and the generated script has a SQL command containing the uppercase in lowercase, then you will need to type the password in uppercase to login.
|The Query Builder currently uses a 24-hour format for timestamps. Attempting to run a query with a date range that includes a 12-hour timestamp format results in incorrect formatting of the timestamp.||ST78729|
|Local Storage||Currently, in a cross-connection query using Local Storage, Toad does not support quoted table alias names (example, the table alias "foo bar"). Quoted column names are supported.||ST86483|
|Toad Intelligence Central||All||
When data includes high-precision numbers (i.e., those with a large number of decimal places), results from publishing to Intelligence Central may not always be as expected. In some cases, data may be truncated to include not more than 15 significant digits.
|Toad Intelligence Central||N/A||
Background: In Toad Data Point 3.5 or later, your Intelligence Central user name must be lower-case.
Issue: In Toad Data Point 3.5 (or later), if you attempt to open a previously-saved connection to Intelligence Central 2.2 (or earlier) in which the user name contains upper-case letters, the connection will error.
Solution: Upgrade to Intelligence Central 2.3.
Issue: Toolbar sub-menus and buttons disappear when selected. If you experience this issue, use the following workaround.