Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.
Friday, September 30, 2016
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, Azure DataMarket, Google Analytics™, OData, and SharePoint®
Azure Table Services, Cassandra™, Cloudera Impala, DynamoDB, HBASE™, Hive™, MongoDB™
Toad Data Point 4.0.1 includes the following new features.
Now you can easily register or sign in to Toad World from within the Toad Data Point application.
The Toad Data Point Professional edition includes the following new features and enhancements.
Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
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.
To share a transform and cleanse rule, first save the rule to your Transforms Repository in the Transform and Cleanse window. Then click the Publish Transforms button in the Transforms Repository toolbar to open the Transforms window.
In the Transforms window, My Transforms tab, you can publish one or more rules, sequences, or folders from your repository to Intelligence Central.
In the Transforms window, Common Transforms tab, you can download rules, sequences, or folders from Intelligence Central to your repository.
Dataset Data Source Name
Script Owner Can Delete Logs on Intelligence Central
Notification of Automation Script Errors
Transform and Cleanse Data
This release includes several enhancements to the Transform and Cleanse tool.
Show/Hide Columns. 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.
Remove Columns. A new rule type allows you to remove one or more columns from the transformed data. To create this new rule, right-click the data grid and select Remove Column. In the rule editor, clear the check box for the columns you want to remove.
To remove the columns that are hidden, in the Show/Hide Columns pane select Remove Hidden Columns.
Split Columns. The new Split Column rule allows you to split a column into two or more new columns, up to ten columns. You can split columns based on a separator, such as a blank space, tab, new line, or string. You can also split columns at a specific position in the string.
Rename Columns. A new rule type is available for renaming columns. In the Transform and Cleanse window, right-click the data grid and select Rename Column. In the rule editor, enter a new name for each column you want to modify. You can rename one or more columns using a single rule.
You can now organize your saved transform and cleanse rules (called transforms) into folders. Click the Create New Folder icon in the Transforms Repository pane to create a new folder. Then drag saved rules into the folder.
Filter by Pattern. You can now filter the data grid by a pattern (string fields). In the Top Patterns section of the profiling information (Column tab), double-click a pattern to filter and display results in the data grid. To remove the filter, click Undo Pattern Filter.
ColMaxDate and ColMinDate Functions. Two new statistical functions have been added to the Calculated Column rule editor, ColMaxDate and ColMinDate. Use these functions with date fields instead of ColMax and ColMin. To display the Statistical category, clear the Use SQL Transforms check box.
This release includes multiple enhancements to the Dimensional Viewer.
Change Column Format in View. You can now change a column's display format after dragging it to a view. Right-click the column in the view and select Display Format.
Reuse Saved Expressions. When creating a Calculated Column, you can now save an expression to reuse in other calculated columns. In the Calculations editor after building an expression, click Add As Saved Expression. The expression is added to the Saved Expressions list and is available when you create or open another Dimensional View document.
Toad Data Point is now certified by Cloudera.
In addition, this release includes several enhancements to the Cloudera Impala ODBC connection.
Please see the "Resolved Issues" section in the Toad Data Point Release Notes for more Cloudera Impala improvements in Toad.
For best results, you might need to reduce the default string column length and the number of rows fetched per block for the Impala connection. See "Create Cloudera Impala Connections" in the online Help for more information.
See "Create Cloudera Impala Connections" in the online Help for a list of considerations to review before setting up and using a Cloudera Impala connection in Toad.
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 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.
Apache Hive (HiveServer2)
Publish File Activity
Click Manage Files to select the files to publish. Click Publishing Wizard to select an Intelligence Central connection and specify publishing options.
The Base and the Professional editions of Toad Data Point contain the following new features and enhancements.
Automatic Syntax Checking Options
You can also instruct Toad to identify the lines with errors in the Editor. Go to Tools | Options | Editor | Tools and select Highlight invalid lines in Editor.
In the Editor, you can place the cursor over a table name in a SQL statement to display the list of columns in the table.
Group Execute Pane. You can now specify a default setting to show or hide the Group Execute pane in the Editor window. Go to Tools | Options | Editor | Tools and select Show Group Execute to show the pane by default.
Run Automation Script Activity - Open Child Script
You can now open the child script directly from the Run Automation Script activity. Click the Open Script button in Activity Input tab to open the child script in a new window.
Automation Script Settings
Set Variable Activity - Link SQL File
In the Set Variable activity, if you use a file to specify a SQL query for selecting values to populate a SQL type variable, you now have the option to link the file to the activity. Select the Link SQL file check box.
Loop Dataset Activity - Link SQL File
In the Loop Dataset activity, if you use a file to specify the driving query, you now have the option to link the file to the activity. Select the Link SQL file check box.
Unique Default Variable Name
When you add an activity, then rename it, and then add another activity of the same type, the second activity now has a unique default name for its built-in variable.
Individual Script Logs Display in Log Tab
Specify Active Connection on Startup
When you designate connections to automatically open when Toad starts, now you can designate one of those as the active connection. In the Connection/Navigation Manager, right-click the connection and select Properties. In the Connection Properties dialog, select Connect on Startup and then select Make it the active connection on startup.
The last connection you specify in this manner overrides any connection you previously specified.
New Simplified Import/Export Workflow
This release includes a new enhanced workflow for importing and exporting data. Sometimes it is not convenient to open a connection, go to the target or source, and then select the import or export action. Toad now provides a new interface that streamlines these steps. Select source and destination from a single page. Based on your selections, Toad skips ahead to the appropriate page of the Import or the Export Wizard.
For new users, this dialog provides an easy way to get started with the import or export process. For experienced users, this dialog streamlines the steps of opening a connection and selecting a data source and destination. Toad automatically decides if the process is import or export.
This new dialog also allows you to import data from an object in one data source to a new or existing table in another data source.
To use this new workflow, select Tools | Import Export Data | Import Export Data or click the Import Export button on the main toolbar.
In the new dialog, select a source from which to get data (database, .csv file, query, etc.) and then a destination for the data (database table, .csv file, etc.). For database objects, you can also select the connection.
You can continue to use the previous workflow which allows you to open the Import or Export Wizard directly from an object or data grid or from the Tools menu.
Import a table. In the Import Wizard, you can now select a table (or other database object) to import as a new or existing table in the same datasource. Select the Add Table option in the Add Import Source page of the wizard.
Optimize block size. When importing data, you can allow Toad to determine the optimal block size. In the Import Wizard, select the Optimize block size option on the Select Target page. You can use this option as an alternative to specifying a processing row count.
This release includes the following enhancements to the Job Manager.
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||Corrected an issue in the Set Variable activity involving formatting in the To_date() function.||QAT-8143|
|Automation||N/A||When using the Clean Data activity in an Automation script to export to a Local Storage table, the Append Rows action now works as expected.||QAT-8194|
|Automation||N/A||An Automation script now stops after an error in the Set Variable activity as expected, when the Stop on Error option is selected.||QAT-8280|
|Automation||N/A||In the FTP activity, the File Mask value is not case sensitive when uploading or downloading.||QAT-8521, QAT-8542|
|Automation||N/A||In the FTP activity, the specified date range is retained after saving the script.||QAT-8543|
|Automation||N/A||Corrected an issue that caused an error in an Automation script that contains a Run Automation Script activity. Tn this case, the child script also contained a Run Automation Script activity and both scripts had "Embed files into Automation script" selected.||QAT-8570|
|Business Intelligence Connections||Hive||Corrected issue that prevented SQL containing a full outer join or Cast() from executing as expected in a Hive connection.||QAT-8079|
|Connections||SAP IQ||Corrected an issue in which a Select statement executed in the Editor resulted in an open transaction.||QAT-8291|
|Connections||N/A||In the Connection Manager, if you double-click a connection in which the password is not saved, the Connection Properties dialog now opens with the focus in the Password field.||QAT-8327|
|Connections||Excel||Corrected an issue that caused an error when attempting to create a new Excel connection to a .csv file.||QAT-8355|
|Connections||Excel||If the user's environment requires installation of the MS Access Database Engine in order to use Excel 2016 64-bit, then a more-informative message now displays to guide the user to the correct download site.||QAT-8383|
|Connections||CSV||Corrected an issue in which column names were not detected when connecting to a .csv file previously exported from Transform and Cleanse.||QAT-8490|
|Connections||SAP IQ||Corrected an issue that caused an SAP IQ connection to fail with a "Could not load encryption dll" error.||QAT-8511, TSY-2035|
|Cross-Connection Query||Oracle, SQL Server||This issue was fixed in release 3.8. Corrected an issue that unexpectedly removed special characters from results of a cross-connection query where the SQL Server table contained special characters.||QAT-6196|
|Database Explorer||Teradata||Teradata: Corrected an issue that caused the NUMBER data type for a View to display as "Unknown Type" in the Database Explorer (Viewer), Columns tab.||QAT-8193|
|Database Explorer||Oracle||Corrected an issue related to a line feed in the Create Table script for an Oracle table.||QAT-8466|
|Editor||N/A||Enhancement: You can now select to show or hide the table and column information tool tips in the Editor through the Options dialog (Tools | Options | Editor | Tools).||QAT-8559|
|Export Wizard||N/A||Performing a Quick Export from the Data tab of the Object Details window in the Editor now works as expected.||QAT-8337|
|Export Wizard||N/A||Corrected an issue that unexpectedly cleared conditional formatting in an existing Excel file after data was exported to the file.||QAT-8482|
|Export Wizard||SQL Server||SQL Server: Corrected an issue that caused the Money datatype column to export as text when using the Quick Export | Excel File action.||QAT-8499|
|Export Wizard||N/A||Corrected an issue that resulted in an error when attempting to export from a data grid to the SQL Script output format. This issue was discovered when using a MySQL connection.||QAT-8553|
|Export Wizard||N/A||Corrected an issue that exported (to CSV) columns that were excluded on the Select Columns page of the Export Wizard. This issue occurred when using the Export Wizard activity in an Automation script and using a query file to select objects to export.||QAT-8555|
|Export Wizard||PostGreSQL||Corrected an issue that caused an error when attempting to export using Quick Export | File. This issue was related to exporting the datetime column.||QAT-8900|
|FTP||N/A||Enhancement: You can now specify a timeout duration for an FTP connection. If you publish an Automation script containing an FTP activity to Intelligence Central, the timeout setting is applied when the script is executed.||QAT-8196|
|FTP||N/A||Corrected an issue that prevented the user from Moving files (Download operation) from a remote FTP connection.||QAT-8442|
|FTP||N/A||Corrected an issue that caused an error when attempting to open a remote nested folder with same name as the parent folder in an FTP connection.||QAT-8497|
|Import Wizard||Teradata||Teradata: Corrected an issue that caused an error when attempting to import to Teradata when the following options were used on the Select Target page of the Import Wizard: the "Not Null" check box was selected and a value was provided in the "Default on Error" field.||QAT-8121|
|Import Wizard||SQL Server||Corrected an issue that caused an error during import if the user selected to save unimported rows to a discard file (.csv) and the data included the Money data type.||QAT-8580|
|Installation||N/A||Corrected an issue in which the installation process for a fresh install unexpectedly stopped in a specific user's environment. The issue was related to the installation of an ODBC driver.||QAT-8078|
|Installation||N/A||When performing a normal install using the .msi file, the user is now informed if the installation of Visual C++ Redistributable for Visual Studio 2015 is required. Symptoms of this issue included issues with Local Storage connections, business intelligence connections, and cross-connection queries. Note: If performing a silent install using the .msi file, the user must manually check for this required software. If installing using the .exe file, the software is included in the installation.||QAT-8573|
|Job Manager||N/A||Enhancement: The Task List now includes a "Toad" column which indicates whether or not the task is a Toad task. Use this column to easily filter out non-Toad tasks.||QAT-8488|
|Pivot Grid||Oracle||Oracle: Corrected issues related to 1) opening a Toad Pivot Grid file created in a previous version and 2) number values converted to currency in exported data. Both issues encountered when the Pivot Grid Automation activity was used.||QAT-8501|
|Pivot Grid||N/A||Toad Sample Database: Corrected an issue that caused an error in the Pivot & Chart tab after modifying the layout of the window and then re-executing the query.||QAT-8520|
|Project Manager||N/A||Corrected an issue that caused a "Could not resolve connection" error when attempting to open an ER Diagram file included in the Sample Project in the Project Manager.||QAT-8502|
|Toad Intelligence Central||N/A||Automation script: Corrected an issue that caused an Automation script to hang when executing on Intelligence Central. The issue involved using the Export Wizard activity to run a macro in an Excel spreadsheet stored in a remote path.||QAT-8118, QAT-6671|
|Toad Intelligence Central||Oracle||Corrected an issue that caused an error when attempting to execute or publish SQL containing an Oracle synonym. This issue was discovered when attempting to refresh a previously-published snapshot in Intelligence Central.||QAT-8394|
|Toad Intelligence Central||N/A||Corrected an issue that prevented snapshot refresh times, such as Next Refresh, from displaying correctly.||QAT-8597|
|Toad Intelligence Central||N/A||Enhancement: Toad now informs you if your attempt to add an Index on a published data object is blocked because the object is locked by another activity.||QAT-8598|
|Toad Intelligence Central||N/A||Corrected an issue in which a snapshot renamed using special characters failed to display the correct refresh status after a manual refresh.||QAT-8931|
|User Interface||N/A||The Bind Variables dialog now displays correctly when using the Sharp Plus skin.||QAT-8436|
|User Interface||N/A||In the message that displays for an expired Beta edition, the link now opens the correct Beta download page on Toad World.||QAT-8546|
|Feature||Platform||Resolved Issue / Enhancement||Defect ID|
|Automation||N/A||Enhancement: When you add an activity, then rename it, then add another activity of the same type, the second activity now has a unique default name for its built-in variable.||QAT-4193|
|Automation||N/A||An issue is resolved that prevented successful execution of a script when the script includes an Export template that uses a query file with inline comments.||QAT-6905|
|Automation||N/A||Enhancement: In the Set Variable activity, when you use a SQL file to specify a query to use for selecting values for a SQL-type variable, you can now link the SQL file.||QAT-4917|
|Automation||N/A||Enhancement: The Log tab in each Automation script window now displays only the execution log for that individual script, even if multiple script windows (documents) are open and executing.||QAT-4342|
|Automation||N/A||Enhancement: In the Run Automation Script activity, you can now open the child script from the Run Automation Script activity.||QAT-4789|
|Automation||Excel||In the Select to File activity, attempting to execute SQL containing multiple bind variables against an Excel connection now works as expected.||QAT-3923|
|Automation||N/A||Enhancement: In the Loop Dataset activity, if you load SQL from a file, you can now link the SQL file to the activity.||QAT-7016|
|Automation||N/A||Enhancement: When you select to send an email on script error, the script name is now included in the Subject line of the error email.||QAT-3164|
|Automation||N/A||An issue that intermittenly caused one script to hang during compile when multiple scripts execute is now resolved.||QAT-7199|
|Automation||N/A||Enhancement: You can now specify different root paths to be used in the Test and Production script execution environments.||QAT-4919|
|Automation||N/A||An issue that caused an error when using the Set Variable Value activity in the Loop Dataset activity is resolved.||QAT-7158|
|Automation||N/A||Scheduled Automation scripts now adjust correctly for daylight savings time.||QAT-7482|
|Code Completion||IBM iSeries ODBC||Resolved an issue that caused Toad to quit unexpectedly when using code completion with an iSeries ODBC connection.||QAT-7063|
|Connections||Cloudera Impala||Added several enhancements to improve support for Cloudera Impala connections. See the Toad Data Point online Help for more information about creating a connection to Impala.||QAT-5779|
|Connections||Cloudera Impala||A cross-connection query in which there is a WHERE condition on the Impala table now works as expected.||QAT-6820|
|Connections||Cloudera Impala||You can now import data into an Impala database using the Import Wizard.||QAT-5944|
|Connections||Cloudera Impala||An issue that caused an error when executing a query containing an integer bind variable against an Impala connection is resolved.||QAT-6436|
|Connections||Cloudera Impala||Improved execution performance for Impala ODBC connections.||QAT-6771|
|Connections||N/A||Enhancement: When several connections are specified to connect on startup, you can now specify one as the active connection.||QAT-3814|
|Connections||Teradata||Enhancement: The Teradata Connection dialog now allows you to specify a Response Buffer Size which allows you to govern the number of rows returned per Response.||QAT-5933|
|Connections||Netezza ODBC||The "Try reopening lost connections" option in Tools | Options | Database | General now works as expected for Netezza connections.||QAT-6943|
|Connections||Netezza ODBC||Improved support for synonyms in Netezza connections. Added a Script tab for synonyms in the Database Explorer. Added support for synonyms in the Query Builder.||QAT-6682|
|Connections||Netezza ODBC||Toad no longer freezes unexpectedly after you attempt to call a procedure that returns an empty string.||QAT-6942|
|Connections||Netezza ODBC||Multi-line strings are now highlighted correctly in the Editor.||QAT-6944|
|Connections||Netezza ODBC||An issue which caused a error when attempting to view data in the Data tab in the Database Explorer (Viewer) is now resolved.||QAT-7228|
|Connections||Netezza ODBC||When calling a stored procedure, notices now display in the Messages tab and errors display in a scrollable field in the error message box.||QAT-6967|
|Connections||Cloudera Impala||When connecting to Impala, a friendly message informs the user about the default string length and provides instructions for how to avoid a possible out-of-memory error by reducing the default string column length and the number of rows fetched per block.||QAT-6826|
|Connections||HiveServer2||In a HiveServer2 connection, you can now filter tables by schema.||QAT-6168|
|Connections||PostgreSQL ODBC||An issue is resolved that caused table locks to linger after querying data.||QAT-7143|
|Connections||PostgreSQL ODBC||For this connection type, when you right-click a view and select Generate SQL | Creation Script | To Editor, this action now generates the correct DDL as expected.||QAT-7177|
|Connections||Access, Excel||Added an informative message when the user attempts to create a connection to an Excel file or Access database and the 32-bit ODBC driver is not installed.||QAT-7723, QAT-7923|
|Connections||N/A||Added a more informative message when a connection is lost and re-established by Toad.||QAT-7483|
|Connections||HiveServer2||Corrected an issue that resulted in Null values from the HiveServer2 data source showing as empty values: 0 for vector, "" for string, true for Boolean.||QAT-7247|
|Connections||SQL Server||Corrected an issue that resulted in sleeping transactions after connecting to SQL Server 2012 to view a SQL Server view.||QAT-7696|
|Data Compare||Oracle||You no longer encounter a "Cannot obtain Oracle client information" error in the New Comparison wizard when using a direct connection with a service name.||QAT-3374|
|Data Compare||Oracle||You no longer encounter an error when you run a synchronization with the "Run script immediately" option when using a 64-bit Oracle client.||QAT-3911|
|Data Compare||Oracle, Excel||You no longer encounter an error when attempting to cancel a comparison that unexpectedly hangs when comparing an Excel file against an Oracle table.||QAT-5922|
|Data Compare||DB2 and Oracle||An issue that caused an error when attempting to run the synchronize script between DB2 and Oracle databases when data includes a Timestamp column is resolved.||QAT-6990|
|Data Compare||Oracle||You no longer encounter an "Unable to generate Excel file, Probably there is not enough ram available" error when attempting to export the comparison to Excel.||TSY-1800, QAT-4632|
|Data Compare||N/A||A WHERE clause added to the Data Compare document is now saved with the file as expected. Applied formatting is now saved when results are exported to Excel.||QAT-7340|
|Data Compare||N/A||Upon opening a saved Data Compare file, you now have the option to run the comparison immediately or not.||QAT-7363|
|Data Compare||Access||Corrected an issue that prevented Access connection information from being saved correctly in a Data Compare file.||QAT-7480|
|Data Grid||SAP ASE||For numeric columns in the data grid, commas are no longer unexpectedly added when you click within a cell or when you copy the contents.||QAT-6798|
|Data Grid||N/A||For BLOB columns, you can now view all pages of a multi-page image in the data grid.||QAT-7558|
|Data Profiling||N/A||When profiling a large result set, Toad now warns if the temporary directory is low on free space.||QAT-7720|
|Database Explorer||DB2 LUW||An issue that caused an error when a limited DB2 LUW user attempted to view a table or other object DDL script in the Script tab is now resolved.||TDB-2503, TDB-2531, QAT-6903|
|Database Explorer||N/A||The Position column is once again visible in the Columns tab in the Database Explorer.||QAT-6956|
|Database Explorer||HiveServer2||Index and Partition information is now displayed for HiveServer2 connections in the Database Explorer (Indexes tab and Partitions tab).||QAT-7346|
|Dimensional View||N/A||If you change the aggregate type for a column in a view, the corresponding Percent of Total and Percent of Total Graph columns now reflect the change, as expected.||QAT-4695|
|Dimensional View||N/A||After changing the name of a calculated column in a view, the new name displays in the column in the view, as expected.||QAT-5145|
|Dimensional View||N/A||When exporting a view's data to Excel after using the Search field to filter values, the data is exported as expected.||QAT-7246|
|Editor||N/A||By default, syntax errors do not show in the Message tab of the Results pane. To instruct Toad to show syntax errors in the Messages tab, select Tools | Options | Editor | Tools||TDB-2783|
|Editor||N/A||With multiple Editor windows open, the show window list button now works as expected.||QAT-7311|
|Editor||Oracle||Added support for synonyms that point to a table using a DB Link.||QAT-7421|
|Export Wizard||N/A||Resolved an issue that caused an "Incorrect syntax" error when running an Export Wizard template in an Automation script.||QAT-7734|
|Export Wizard||N/A||When exporting from a query or query file to a Fixed Column Width output, specifying a fixed width size now works as expected.||QAT-7830|
|Export Wizard||Oracle||Corrected an issue that caused an error when using Export Wizard to Excel file or Quick Export | Excel Instance from the data grid in the Data tab.||QAT-7867|
|Export Wizard||N/A||Exporting data to an existing Excel file containing a Pareto chart now works as expected.||QAT-7338|
|Import Wizard||Netezza ODBC||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.||QAT-5292|
|Import Wizard||Oracle||Corrected an issue that caused Null values in a Date column to get imported as "1/1/0001" instead of Null when using an Oracle 64-bit client.||QAT-7948|
|Job Manager||N/A||In a Windows 7 or Windows 8 environment, enabling/disabling tasks from the Job Manager window now works as expected.||QAT-6773|
|Library||N/A||When you open the Library window, it no longer associates to the active connection.||QAT-7075|
|Local Storage||N/A||Executing SQL containing carraige returns (new lines) against Local Storage now works as expected.||QAT-7192|
|Object Explorer||SAP HANA||SAP HANA Views (Analytic, Calculation, Attribute) are now visible in the Object Explorer when using a native SAP HANA connection.||TSY-1692, QAT-6680|
|Object Explorer||IBM DB2||The Object Explorer now includes a Databases tab (node) for IBM DB2 z/OS connections.||QAT-2218|
|Object Explorer||PostgreSQL ODBC||The Object Explorer can be refreshed to display changes as expected after a change to a table.||QAT-7160|
|Object Explorer||SQL Server||Corrected an issue that caused a "VIEW DATABASE STATE permission denied" database error when attempting to connect to a SQL Server database.||QAT-7312|
|Object Explorer||MySQL||In the Alter Table dialog Columns page, the Collation field for a column now displays the current collation setting and the list of available collations, as expected.||QAT-7735|
|Object Explorer||SAP ASE||Corrected an issue that caused the following Sybase database error when the user selected a table column name in the Object Explorer: "Attempt to insert NULL value... ; column does not allow NULLS".||QAT-8182|
|Options||N/A||For users without Administrator privileges, selecting Tools | Options | Environment | Extensions no longer causes a continuous series of messages that make the application inaccessible.||QAT-6964|
|Pivot Grid||N/A||Enhancement: When printing a pivot grid, you how have the option to include the chart or graph.||QAT-3143|
|Pivot Grid||N/A||Formatting is now retained, as expected, when exporting from a Toad Pivot Grid to Excel.||QAT-7721|
|Query Builder||IBM iSeries||An issue that caused Toad to error and quit unexpectedly after attempting to edit an existing formula in a subquery in the Query Builder is now resolved.||QAT-6894|
|Query Builder||Oracle||An issue that resulted in an error and corrupted SQL after reopening a Query Builder file containing multiple Union queries in a sub-query is now resolved. This fix is implemented for new Query Builder files created using this release of Toad.||QAT-6945|
|Query Builder||Oracle||An issue that caused an "ORA-12704: Character Set Mismatch" error when attempting to use Toad Data Point 3.8 to execute a Query Builder file created in a previous version of Toad is now resolved.||QAT-7156|
|Query Builder||Oracle||An issue that caused an "ORA-009033: SQL command not properly ended" error when attempting to use Toad Data Point 3.8 to execute a Query Builder file created in a previous version of Toad is now resolved.||QAT-7159, QAT-7357|
|Query Builder||IBM iSeries ODBC||Nested subquery produced by calculated field is now modeled in the diagram as expected.||QAT-7086|
|Query Builder||SAP ASE||An issue that caused a "Domain error during explicit conversion of INT value '0' to a BIT field" error when initially using the Query Builder for a cross-connection query is resolved.||QAT-7518|
|Query Builder||Access, SQL Server||Cross-connection query: Corrected an issue that caused an error when executing a cross-connection query between Access and SQL Server.||QAT-6983|
|Query Builder||N/A||Enhancement: After you click on a join in the diagram, Toad now gives you the opportunity to confirm the action before analyzing the join and opening the Analyze Join pane. This gives you the option to cancel an analysis which might take time to process.||QAT-7334|
|Query Builder||MySQL||Retrieving the Explain Plan now works as expected.||QAT-7903|
|Query Builder||SQL Server||Corrected an issue which caused an error when executing SQL containing a WHERE clause on a bit data type column.||QAT-6987|
|Query Builder||N/A||Enhancement: If an aggregate function is selected from the Query Builder column drop-down, Toad now adds an alias to the column if one does not exist.||QAT-7069|
|Query Builder||N/A||An issue that resulted in an incorrect WHERE clause after adding a table alias is now resolved.||QAT-7276|
|Query Builder||N/A||Resolved an issue that caused the Query Builder to add extra quotes to an alias after adding an alias and then Visualizing the query.||QAT-7640|
|Query Builder||Toad Intelligence Central||Corrected an issue that caused Toad to use the same table alias in parent query and sub-query. This resulted in a syntax error.||QAT-6282|
|Toad Intelligence Central||N/A||You can now publish a snapshot when another snapshot is in the process of refreshing.||QAT-6886|
|Toad Intelligence Central||FilemakerPro ODBC||An issue that caused an error when refreshing a snapshot containing column length larger than 65535 is now resolved.||QAT-6992|
|Toad Intelligence Central||N/A||If you open the Alter Refresh Snapshot dialog and refresh a snapshot using "Now," the dialog closes after you click Execute and the snapshot refreshes in the background.||QAT-6890|
|Toad Intelligence Central||N/A||Toad now provides a more descriptive message when an Automation script fails to load or compile when attempting to run the script in Intelligence Central.||QAT-7676|
|Toad Intelligence Central||Oracle||Corrected an issue that caused an error when attempting to publish a snapshot from a query containing a PARTION BY clause.||QAT-7373|
|Toad Intelligence Central||N/A||Corrected an issue that caused an error on snapshot refresh after the object's authentication password was changed. This resolution is supported when using Intelligence Central 3.0 or later.||QAT-7515, TIC-5438|
|Toad Intelligence Central||N/A||Corrected an issue that prevented users with Administrator role from creating new Active Directory users when the "Only the Administrator can add new users" option was enabled in Intelligence Central. This resolution is supported when using Intelligence Central 3.0 or later.||QAT-7127, TIC-5125|
|Toad Intelligence Central||N/A||Corrected an issue that resulted in an error when executing a SELECT statement containing a table alias starting with a number AND a non-standard column name against an Intelligence Central object. This resolution is supported when using Intelligence Central 3.0 or later.||QAT-6296, TIC-5615|
|Toad Intelligence Central||N/A||Publishing an Automation script containing a connection which was originally in a group folder in the user's Connection Manager now works as expected.||QAT-7891|
|Toad Intelligence Central||N/A||When republishing an Automation script in which the schedule is currently disabled, the Publishing dialog now provides this information.||QAT-6552|
|Toad Intelligence Central||Netezza ODBC||You can now publish a view, snapshot, or dataset from a Netezza connection.||QAT-3510|
|Toad Intelligence Central||N/A||When re-publishing a file from the Library, the publishers Manage privileges for the object are now identified correctly.||QAT-7078|
|Toad Intelligence Central||N/A||When republishing and overwriting an existing object, the Publishing dialog gathers and displays the existing object's sharing options.||QAT-7051|
|Toad Intelligence Central||N/A||When Toad is fetching information about the debug mode for an Intelligence Central connection, a progress bar now displays in the Advanced tab of the Connection dialog.||QAT-7650|
|Toad Views||N/A||Executing a Toad View that was saved in a subfolder now works as expected.||QAT-7290|
|Transform and Cleanse||N/A||Enhancement: A new rule type is available that allows you to change column names in transformed data.||QAT-6512|
|Transform and Cleanse||N/A||Added two new statistical functions to the Calculated Column rule editor, ColMaxDate and ColMinDate to be used with date fields instead of ColMax and ColMin.||QAT-6525|
|Transform and Cleanse||N/A||For most rules, after the rule is applied to a column, the column now remains in view in the Transform and Cleanse window.||QAT-6831|
|Transform and Cleanse||N/A||When creating a Calculated Column rule, syntax checking is performed on the expression entered in the expression editor, as expected.||QAT-6519, QAT-7358|
|User Interface||N/A||The buttons to create TIC groups and add AD users now display in the Alter Visibility with extended DPI settings.||QAT-6818|
|User Interface||N/A||The Create Intelligence Central Group dialog and the Background Processes window display correctly with extended DPI settings.||QAT-6850, QAT-6840, QAT-6870|
|User Interface||N/A||Resolved several text display issues encountered when text size is set to 150% in Windows. This resolution involves the Import Connections, Settings Migration, and Options dialogs.||QAT-5915|
|User Interface||N/A||The Alter Refresh Snapshot dialog and Scheduling page of the Publishing dialog display scheduling options correctly with extended DPI settings.||QAT-6853|
|User Interface||N/A||Improved text displayed in the Where Condition dialog in the Query Builder when using extended DPI settings.||QAT-6854|
|User Interface||N/A||Improved display of text and options in the Export Wizard when using extended DPI settings.||QAT-6851|
|User Interface||N/A||Print settings are now retained between sessions without requiring the user to open the Page Setup dialog.||QAT-6051|
|User Interface||N/A||If the Navigation Manager is minimized, it does not open after creating and saving a new Export Template through the Automation activity, if "Save input files to project manager" is not selected.||QAT-7764|
|User Interface||N/A||Panes in auto-hide mode now collapse as expected when you click within an empty window (no document open).||QAT-6784|
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 Resolved Issues: If you are publishing objects to Intelligence Central and would like to review the resolved issues for a particular Toad Intelligence Central release, see http://documents.software.dell.com/toad-intelligence-central/.
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.
|Installation||n/a||For some languages (languages using double-byte character encoding) specified using the Current language for non-unicode programs option in the Windows Region and Language dialog, the trademark symbols do not display correctly in the installer.||TDB-645|
(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:
(In Toad Data Point 3.5 or later) C:\Program Files\Dell\Toad Data Point 4.0.1
(In Toad Data Point 3.4 or earlier) C:\Program Files\Quest Software\Toad Data Point <version>
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.0.1
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|
In Toad Data Point 4.0 or 4.0.1, the application might unexpectedly stop or become unresponsive when attempting to query a table in Amazon Redshift. Toad Data Point 3.8 (or earlier) is not affected by this issue.
Workaround: If you experience this issue, use Toad Data Point 3.8 (or earlier) to query a table in Amazon Redshift.
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.0.1 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.0.1 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.