Toad Data Point 6.1.2

Toad Data Point 6.1.2

Release Notes

Wednesday, September 6, 2023

Contents

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
• Snowflake®

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:

Toad Data Point 6.1.2 is a minor release with new features, security enhancements, and resolved issues.

New Features

In Toad Data Point 6.1.2 the following new features were implemented:

Snowflake connection improvements

For Snowflake users who work with large databases, we have implemented a mechanism that allows users to specify a schema that is present in the connection window, and only objects from that specific schema will be loaded and displayed in the Object Explorer panel. Adding this solution reduces connection/load times.

When the schema is not specified in the connection window, all schemas are loaded/shown in the Object Explorer panel. Expanding those schemas leads to loading objects under them.

All Optional drop-down lists are editable so the user can type in the wanted string (Role, Schema(s), Database(s), and Warehouse(s)) without expanding the drop-down lists.

When the drop-down list is expanded - all listed items (except for Role and Warehouse) have checkboxes in front of them, so that multiple items can be selected.

The default Object Explorer filter is the ''Treelist'' filter.

Objects are shown in the following hierarchy (as it is displayed in a native Snowflake connection through a browser):

• Database

• Schema

• Objects

Key pair authentication with JSON Web Token (JWT) support for Snowlake

Snowflake users use this type of authentication for a more secure connection, and for the same reason, we implemented this type of authentication in Toad Data Point and Toad Workbook. By supporting this type of authentication, we completed the native connection support for Snowflake.

Toad Data Point and Toad Workbook supports the following authentication types for Snowflake:

• Snowflake (User and Password)

• SSO (User)

• OAuth (User, Password, and Token)

• MFA (User and Password)

• Key pair (User, Private key path, and Passphrase)

The Key pair option has been added to the Authenticator drop-down list in the Connection window.

Limitation using the Key pair authentication:

Automation script, Snapshot, Workbook, and View object types cannot be published when using Key pair authentication, and an appropriate message will appear:

"SSO, MFA, OAuth or Key pair authentication cannot be used when publishing from Snowflake.

Only native Snowflake authentication is supported."

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.

• Toad Data Point Videos - Learn about new features from product video demos.
• Toad Data Point Forum - Find answers to your questions in the forums.
• Toad Data Point Blog - Learn tips and tricks from blog posts.
• Toad Data Point - Idea Pond - Submit your idea to the Development Team.

System Requirements

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Virtualization Support

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

Note: The following exceptions exist for Power Users:

• (DB2 only) A Power User can install Toad as long as this user belongs to the DB2ADMNS or DBUSERS group.

If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User—on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

• Associate file extensions.
• View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

• (DB2 only) A Windows Power User or Restricted User must belong to the DB2ADMNS or DB2USERS group. To add the user to one of these groups, select Start | Control Panel | Administrative Tools | Computer Management | System Tools | Local Users and Groups | Groups | DB2ADMNS or DB2USERS.
• (DB2 only) A Windows Power User or Restricted User does not have the authority to add or remove DB2 catalog entries using the Toad Client Configuration wizard. However, these users can use the Import Profile function in the Toad Client Configuration wizard to import catalog entries to Toad.

• (DB2 only) To take full advantage of Toad for DB2 LUW functionality, the user ID specified in the Toad connection profile for each DB2 for LUW database connection requires the authorizations listed in the following document:

  ToadDB2LUWAuthorizations.xls

• (DB2 only) As a minimum requirement to manage a DB2 for z/OS subsystem in Toad, the user ID defined in the Toad connection profile for the subsystem must either have SYSADM privileges or SELECT privileges on the DB2 catalog tables. For a complete list of authorizations (and corresponding GRANT statements) a user requires to take full advantage of Toad for DB2 z/OS functionality, refer to the following document:

  ToadDB2zOSAuthorizations.doc

• To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.

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 6.1.2