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.

Toad Data Point 4.0 - Release Notes

Release Notes

Toad™ Data Point 4.0.1

Release Notes

Friday, September 30, 2016

About Toad Data Point

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:

  • Connect to almost any database or ODBC data source (see the Release Notes for a list of tested ODBC connections)
  • Write SQL queries and join data across all platforms
  • Automate and schedule frequent and repetitive tasks
  • Streamline data collection
  • Collaborate with team members
  • Export data in a variety of file formats

Toad Data Point provides a full-featured Database Explorer, Query Builder, and Editor for the following databases:

  • Oracle®
  • SQL Server® and SQL Azure
  • IBM® DB2® (LUW and z/OS)
  • SAP® ASE, IQ, SQL Anywhere, and HANA
  • Teradata®
  • MySQL

Toad Data Point also provides querying and reporting functionality via the following provider types:

  • ODBC
  • Business Intelligence and NoSQL data sources
  • Microsoft® Excel®
  • Microsoft Access®

ODBC Connections

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:

Business Intelligence

Oracle Business Intelligence Enterprise Edition (OBIEE), SAP Business Objects™, Salesforce®, Microsoft SQL Server Analysis Services, Azure DataMarket, Google Analytics™, OData, and SharePoint®

NoSQL

Azure Table Services, Cassandra™, Cloudera Impala, DynamoDB, HBASE™, Hive™, MongoDB™



Was this topic helpful?

[Select Rating]



New Features

New Features

 

Toad Data Point 4.0.1

Toad Data Point 4.0.1 includes the following new features.

Toad World Registration

Now you can easily register or sign in to Toad World from within the Toad Data Point application.

  • To register, click the Toad World link located beside the search box above the main toolbar in Toad. Provide your email address and a user name. You will receive an email containing your new password.
  • To sign in to Toad World after you are registered, click the Toad World link beside the search box. Then click the Sign In link and enter your Toad World credentials.
  • When you are signed in through Toad, a special toolbar displays beside your user name providing convenient links to Toad World pages. Click the Show Tips button to display helpful tips about Toad Data Point features.

Toad Data Point 4.0 - Professional Edition

The Toad Data Point Professional edition includes the following new features and enhancements.

Toad Intelligence Central

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.

  • Publishing transform and cleanse rules (transforms) is supported in Toad Intelligence Central 3.0 or later.

Dataset Data Source Name

  • For published datasets, Toad now provides the data source name. You can find this information by viewing the dataset in the Database Explorer. In the Object Explorer, right-click the dataset and select View Details. Then select the Information tab.

Script Owner Can Delete Logs on Intelligence Central

  • In addition to the root user, the script owner can now delete the saved script execution logs for an Automation script running on Intelligence Central. In the Script Manager, right-click a script and select Operations | Delete History. This is useful for a script that runs frequently or that accumulates a very large log history. You can delete the logs for scripts that you own or scripts for which you have Manage privileges.

Notification of Automation Script Errors

  • If an Automation script errors when executed on Intelligence Central, notification of the error is included in the Daily Digest email sent to users with Manage privileges to the script. This feature is supported in Toad Intelligence Central 3.0 or later. See "Notifications" in the Toad Intelligence Central 3.0 Deployment Guide for more information.

Data Management

Transform and Cleanse Data

This release includes several enhancements to the Transform and Cleanse tool.

  • You can now publish a Transform and Cleanse document to Intelligence Central (in addition to publishing your transformed data). In the Transform and Cleanse window, click Publish File in the Wizard bar or select Transform and Cleanse | Publish File.
  • 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.

  • Extract Date. The new Extract Date rule allows you to extract individual date and time components from a date/time field. Each extracted component creates a new column.
    • To create this new rule, right-click a date column and select Extract Date.
    • New columns are numeric, by default. This is useful if you want to use the values in a calculated column.
    • Alternatively, new columns can contain descriptive names (string values). For example, the Month column would contain the value May instead of 5.
  • Transforms Repository. The Library pane in the Transform and Cleanse window is now the Transforms Repository.
    • 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.

    • You can now publish transform and cleanse rules (transforms) to Intelligence Central to share with other Toad users. See the Toad Intelligence Central new features section above for more information.
  • Exception Handling. Transform and Cleanse provides several new features to help you identify and resolve errors/exceptions produced in transformed data.
    • If a rule produces errors/exceptions, the rule is flagged in the Steps tab and a tool tip displays the error information.
    • When an exception-generating rule is applied, a Rows with Exceptions tab displays listing the exception rows and the issue.
    • Toad can export the exception rows to a .csv file. In Transform and Cleanse, click Edit Sample to specify an Error file location.
    • You can specify default error values to use in the data when rules applied produce errors/exceptions. Click Edit Sample to specify error options.
  • 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.

  • Next and Prior Functions. Two additional functions have been added to the Calculated Column rule editor, Next and Prior. Find these functions in the Miscellaneous category. To display the Miscellaneous category, clear the Use SQL Transforms check box.
  • After a rule is applied to a column, the column now remains selected and in view in the Transform and Cleanse window. This is useful when your data grid contains a very large number of columns. This action is enabled for rules that can apply to a single column.
  • Find and Replace. In the Find and Replace rule editor, the Find field now provides a list of column values from which to select. In addition, you can enter a partial search string to find values.
  • Load All Distinct Values. In the rule editors that provide a list of column values from which to select, if you are using a reduced sample size, you can now populate the list with all column values. Click the Load All Distinct Values link. Toad populates the list with all distinct column values, regardless of your sample size.

Dimensional Viewer

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.

  • View data details for an aggregate value. When a value in a view is based on aggregated data, you can now drill down to view the data details. Right-click the value in the view and select Show Details. This action opens a Detail Grid displaying the rows on which the aggregate value is based.
  • Wizard Bar. Additional functionality has been added to the Dimensional Viewer and can be accessed through the Wizard bar.

    • Click Arrange to organize your views in the work area.
    • Click Add to Project to save the file as a Dimensional View document and add it to the currently-open project in the Project Manager.
    • Click Publish File to publish the Dimensional View document to Intelligence Central.
  • Create Column Alias. You can create an alias name for a column. Right-click a column in the Field List or a view and select Column Alias.
  • Header as Worksheet Name. The name you enter in the view Header is now used as the worksheet name when you export the view data grid to Excel.
  • Create Local Filter. Now to create a local filter in a view, right-click a column and select the Column Filter action. In the previous release the action was Filter Editor.
  • Default Display Format. In the Dimensional Viewer, the default format for a data type now uses the format specified in Tools | Options | Environment | Grid. As before, you can change the formats used in your Dimensional View document/window. Right-click a column in the Field List or view and select Display Format.

Connections

Cloudera Impala

Toad Data Point is now certified by Cloudera.

In addition, this release includes several enhancements to the Cloudera Impala ODBC connection.

  • In the Object Explorer, Impala tables and Impala databases now display as expected.
  • In the code completion dialog in the Editor, tables and databases are now displayed correctly in the treelist and include the correct icons.
  • To create a new Cloudera Impala connection, select Cloudera Impala from the Group list in the Create New Connection dialog. Cloudera Impala is listed with the NoSQL Data Sources. You must install the Cloudera ODBC Driver for Impala and configure a DSN.
  • Please see the "Resolved Issues" section in the Toad Data Point Release Notes for more Cloudera Impala improvements in Toad.

Notes:

  • Toad Data Point was tested and certified using the Cloudera ODBC Driver for Impala: ClouderaImpalaODBC32.msi.
  • The Data Grid is read-only for Impala connections 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.

Teradata

  • 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.

Netezza ODBC

This release includes several enhancements to the Netezza ODBC connection.

  • In this release, support for Netezza synonyms is improved. The Database Explorer (Viewer) now includes a Script tab for Netezza synonyms. In addition, the Query Builder now supports synonyms.
  • Multi-line strings are now highlighted correctly.
  • In the Import Wizard, when importing into a new table in Netezza 7.0.3 or later, you can now select a schema and a database.

SAP HANA

  • The native SAP HANA connection in Toad now supports HANA Views (Analytic, Calculation, and Attribute). HANA Views are now visible in the Object Explorer and code completion list when using this type of connection.

Apache Hive (HiveServer2)

  • When creating a HiveServer2 connection, you can select a default schema to open upon connection. In addition, Toad now lists all available schemas in the Object Explorer allowing you to filter by a different schema after connecting.
  • Index and partition information is now displayed for HiveServer2 objects in the Database Explorer. In the Object Explorer, right-click a HiveServer2 table and select View Details. Then select the Indexes or Partitions tab.

Automation

Publish File Activity

  • This release includes a new Automation activity which allows you to publish one or more files to Intelligence Central. You can publish files produced by previous activities in the Automation script, or you can publish other existing files.
  • To use this activity, drag it to the script design area from the Automation toolbox.
  • Click Manage Files to select the files to publish. Click Publishing Wizard to select an Intelligence Central connection and specify publishing options.

 

Toad Data Point 4.0 - Base and Professional Editions

The Base and the Professional editions of Toad Data Point contain the following new features and enhancements.

Query Development

Editor

Automatic Syntax Checking Options

  • If you enable automatic syntax checking, you can now enable or disable displaying syntax errors in the Results pane. Go to Tools | Options | Editor | Tools and select (or deselect) Show syntax check messages in Results.
  • 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.

Table Hint

  • 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.

Data Management

Pivot Grid

  • You now have the option to print the chart or graph when you print the pivot grid. After you right-click the pivot grid and select Print, Toad prompts you to include the pivot grid's chart/graph.

Automation

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

  • When you elect to send an email when a script errors, the script name is now included in the Subject line of the error email.
  • Entering settings in an Email activity now auto-populates the same fields in the script's error email if those fields are empty. The values in the To and From fields and in the Email Server Settings are the values sent to the error email. Entering new values overrides the auto-populated settings.
  • You can now define a root path in both Test settings and Production settings. Then use the ROOT_PATH variable in your script wherever you want to apply the path. The path applied depends on the setting you select, Test or Production.

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

  • 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.

Connections

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.

Import and Export

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.

  1. To use this new workflow, select Tools | Import Export Data | Import Export Data or click the Import Export button on the main toolbar.

  2. 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.

  3. Click Next. If the action is data import, the Import Wizard automatically opens to the required page. If the action is data export, the Export Wizard automatically opens to the required page. Finish the wizard as you normally would.

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 Wizard

  • 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.

General

Job Manager

This release includes the following enhancements to the Job Manager.

  • The New Task dialog has been updated. This dialog is used in the Job Manager to create a new Windows Scheduling Task. Windows Scheduling Tasks are used by Toad to schedule Automation scripts.
    • To open this dialog to create a new task, in the Job Manager right-click the server and select New Task.
    • To open this dialog to edit an existing task, in the Job Manager right-click the task and select Edit Task.
    • When you schedule a script from the Automation window, this dialog opens with the required fields pre-populated.
  • Script and task scheduling. When using this dialog, task scheduling information is now added or edited through the Triggers tab.
    • To create a new schedule for a task, click New in the Triggers tab in the New Task dialog.
    • To modify the schedule for an existing scheduled Automation script, right-click the script/task in the Job Manager and select Edit Task. In the Triggers tab, select the schedule/trigger and click Edit.
  • Run program options. The run program command and run options are now specified through the Actions tab. You can use this tab to edit run actions for an existing scheduled Automation script. For example, you might want to manually change the version of Toad under which a script runs.
  • The New Task dialog now includes more options for customizing your task. The dialog now includes a Settings tab and a Conditions tab, both with additional options.

See Resolved Issues for more enhancements and resolved issues in this release of Toad Data Point.


 

Idea Pond

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.

Learn More

Remember, you can find blogs, videos, and forums at the Toad Data Point Community.

  • Learn about new features from product video demos.
  • Find answers to your questions in the forums.
  • Learn tips and tricks from blog posts.
  • Find product documentation


Was this topic helpful?

[Select Rating]



Resolved Issues

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad Data Point.

Resolved Issues in 4.0.1

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

Resolved Issues in 4.0

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/.



Was this topic helpful?

[Select Rating]



Known Issues

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature

Platform

Known Issue

Defect ID

General Sybase ASE

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.

Workaround 1:

  1. If you receive a message stating that the saved file cannot be opened, close the message pop-up. You will see that your Toad Query Builder document is open in an Editor window. Send this document to the Query Builder (Editor | Send to Query Builder).
  2. Save the new Query Builder document as a new Toad file.

Workaround 2:

  1. Open the Toad file in Notepad.
  2. Use Find and Replace to change all instances of "sybase" (all lowercase) to "Sybase" (first character uppercase, with the rest lowercase).
N/A
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
General Salesforce

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.

N/A

Installation/

Upgrade

All

(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:

http://www.symantec.com/connect/downloads/msi-run-administrator-context-menu-vista

 

N/A

Toad Data Point does not support installation paths that contain UNICODE characters.

N/A

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):

In the Destination Folder page of the installer, only use a destination directory that contains English characters

ST66330
Installation n/a

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.

N/A
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

Startup

DB2

(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

N/A

Connections

ODBC

Currently, Toad does not support ODBC connections to the following databases:

  • Sybase Advantage

  • Oracle RDB

  • Progress OpenEdge

  • MySQL ODBC (The ODBC 3.51.17.0 driver is not supported, and attempting to connect using this driver results in columns not displaying for tables.)

    Workaround:

    Upgrade the MySQL ODBC driver to 3.51.27.00 or later to display table columns.

ST69744

Access

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.

Workaround:

  1. To open a password-protected Access connection, right-click the connection in the Navigation manager and select Properties.
  2. Select the Advanced tab and enter the password.
  3. Select the Save password checkbox and click Connect.

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.

ST94125
Connections Vertica ODBC

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:

ColumnsAsChar=0

ST109484
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
Connections Amazon Redshift

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.

QAT-8875
Connections N/A

Exported connections: A connection file exported from Toad Data Point 3.6 or later cannot be imported into version 3.5 or earlier.

N/A

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).

TIC-5520

Automation   All

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.

Workaround:

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.

  ST80857
Automation All

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.

N/A

Data

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.

Workaround:
Download the latest Ingres 9.3 ODBC driver.

N/A

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.

Workaround:
Use the actual execution plan button to generate execution plans for SQL that contains a temp table.

N/A
Export Wizard/ One Click Export Access, Excel

 

Limitations when exporting fractional seconds:

  • When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.

  • When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.

N/A

 

Import Wizard

Excel

Attempting to import data that was exported to an Excel instance where the fractional seconds were truncated results in an error.

N/A

Attempting to import data from a template that contains multiple worksheets results in an error.

 

ST77978

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.

ST77986

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
Library N/A

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.

N/A

Local Storage N/A

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

  1. Navigate to C:\Users\username\AppData\Local\Quest Software\Toad Data Point Hub Data.
  2. Make a copy of the Toad Data Point Hub Data folder and save it using a new name (such as Toad Data Point Hub Data 3.5 backup). If you uninstall 3.6, just move this copy back and use the original folder name.
QAT-3812
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.

N/A

Object Explorer/ Database Explorer Sybase ASE Currently, only foreign key constraints can be added or modified for existing Sybase ASE tables. ST55111
Oracle 11g

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.

ST66705

Query/
Query Builder

All

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
Query/
Query Builder
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.

N/A
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.

N/A
User Interface N/A

Issue: Toolbar sub-menus and buttons disappear when selected. If you experience this issue, use the following workaround.

Workaround:

  1. In Toad, select Help | About and select the Application Data Directory link to open this directory. Then exit Toad.
  2. In the App Data directory, open the Session sub-directory and delete the Analyst.tss file. Restart Toad.
  3. In Toad, select Tools | Configuration Wizard. Click Finish to close the wizard without selecting an option. The default option will be applied.
QAT-6045


Was this topic helpful?

[Select Rating]



Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Related Documents