What’s new in Toad Data Point 4.1? (4258403)

General

Beginning with release 4.1, Toad Data Point is now available in a 64-bit version of the application, as well as a 32-bit version. Make your selection, 32-bit or 64-bit, during installation in a 64-bit operating system.

Note: If you have an ODBC connection defined in a previous release (32-bit), you must define a 64-bit ODBC DSN to use the connection in the 64-bit version of Toad Data Point. Or you can use the 32-bit version of Toad Data Point.

• Benefits of 64-bit Toad Data Point. Use the 64-bit version of Toad Data Point to take advantage of performance benefits in a 64-bit environment. The 64-bit version of Toad provides users with improved speeds in many areas of the application (up to 33% faster). In addition, the 64-bit version provides significantly smaller memory usage.
•  Side-by-side testing of 32-bit and 64-bit Toad was performed and included the following areas: the SQL Editor, Import/Export, Query Builder, publishing to Intelligence Central, Automation, Data Compare, Dimensional Viewer, and Visualization.

Installation

Use the single Toad Data Point installer to install either the 64-bit version or the 32-bit version. If you are installing in a 64-bit operating system, the installer allows you to select which version to install.  In a 64-bit environment, run the combined installer. On the Choose Installer page, select Install 64-bit Toad Data Point.

• Use 64-bit ODBC drivers. If you are using one or more ODBC drivers for connections in Toad Data Point, then you must have the 64-bit version of that driver installed to use 64-bit Toad Data Point. For example, ensure that you have the corresponding 64-bit ODBC driver installed if you use any of the following connections: Netezza, IBM iSeries, Ingres, Vertica, or PostgreSQL.

• Use 64-bit IBM DB2 client. The bitness (architecture) of your DB2 client must match the bitness of Toad Data Point. To use a DB2 client with 64-bit Toad Data Point, you must have a 64-bit version of the DB2 client installed.

                -32-bit Oracle client. You can use a 32-bit Oracle client with the 64-bit version of Toad Data Point.

                -Side-by-side installation. Toad Data Point 4.1 (or later) supports side-by-side installation of versions with different bitness (architecture) as long as they are also different releases (e.g., 4.0 and 4.1) or different editions (e.g., Commercial and Beta).

For example, you could install the following side-by-side:

                A 32-bit 4.1 Commercial edition and a 64-bit 4.1 Beta edition

                A 32-bit 4.0 Commercial edition and a 64-bit 4.1 Commercial edition

Look Up Database Errors

Toad allows you to easily search Toad World and Toad Knowledge Base articles whenever you encounter a database error.

•  In the database error message, click Look Up Error to open a page displaying multiple search results from a variety of sources.
• Toad returns search results from Toad World and Toad Knowledge Base articles. In addition, links to searches from a variety of search engines, such as Google, are also provided. Open these Web Search links to display search results from the Web.

Use the search results to find more information about the specific database error you encountered.You can modify the search string to customize your search results or to remove object names and other internal information.

SQL Editor - Option to Disable Schema/Instance Selection

For ODBC connections, Toad now provides an option in the schema/instance drop-down list that allows you to bypass selecting a schema/instance, and instead, specify this information through the script. This is useful if your script executes SQL against multiple schemas.

•  To use this feature, select I will set schema/instance in the script from the schema/instance drop-down list in the SQL Editor window. Then specify schema/instance through your script.

Note: When this option is selected, some code completion features, object actions, and object information tool tips are unavailable for that specific SQL Editor window.

Script Environment Settings Persist

If you specify Test environment and Production environment settings in an Automation script, now when you open a new script window, the previously-specified values are automatically loaded into these fields. This is convenient when you want to use the same values repeatedly. The Email to and Root path values are retained.

Export Wizard Default Folder

• You can now specify a default folder to use each time you export to a file with the Export Wizard. Specify the default folder in the Options dialog (Tools | Options | Environment | Export). Then when you open the Export Wizard to create a new export template, the destination field is pre-populated with the default folder name and path.

Custom Grid Formatting is Retained

• Any custom formats you specify for the data grid through the Options dialog (Options | Environment | Grid) are now applied when you export to an Excel file using the Quick Export command.
• These custom formats are also applied when exporting to Excel using the Export Wizard, but can be overwritten if necessary by applying formatting through the wizard.