Release Notes
Toad® Intelligence Central 6.4.1
Release Notes
Monday, August 11, 2025
About Toad Intelligence Central
Toad® Intelligence Central enables enterprise users to be far more productive with their tools including Toad Data Point by centralizing automation workflows, accessing data directly, collaborating and sharing on datasets, queries and Toad files and providing a secure and established way to manage your data sprawl.
-
AUTOMATE - Toad users can schedule the regular automated execution of Toad Data Point automation scripts on Toad Intelligence Central.
-
ACCESS - Toad users can access Toad files and basic data files published to Toad Intelligence Central that have been shared with them. An additional data connectivity license extends Toad Intelligence Central to work across a wide range of data stores including relational database models, data warehouses, No SQL and Business Intelligence data sources like OBIEE and SAP®.
- SHARE - Objects can be shared amongst users and groups and organized collectively in a familiar folder structure, assigned tags and given a description for easy search retrieval. Administration of users and groups can be managed locally or users and groups can be imported from Active Directory®.
-
SECURE - Toad Intelligence Central provides a centrally managed, secure, stable and accessible system.
Distributions of Toad Intelligence Central include a Web Server for administrative and general user access. In addition, Toad Data Point and other collaborative Toad products can directly access Toad Intelligence Central. Data on Toad Intelligence Central can be accessed via a third party product such as Tableau for further data processing and visualization.
Data Connectivity
A valid data connectivity license supports the following Business Intelligence Data Sources.
- Google Analytics™
- Oracle® Business Intelligence Enterprise Edition 10g and 11g
- SAP® Business Objects Query as a Web Service (QAAWS) XI 3.0, 3.1 and 4.1
- Salesforce.com®
- SharePoint® Lists using Data Services over SharePoint Server 2010 and later via OData. Also, SharePoint Online.
- Hive™
- Microsoft® Analysis Services
- OData - Generic for any OData service versions 1, 2, 3 and 4.
Intelligence Central 6.4.1 is a minor release, with enhanced features and functionality. See New features.
New Features
This release of Toad Intelligence Central includes new features and enhancements.
Custom List of Values for Bind Variables
This feature allows you to define a list of specific values for bind variables, providing you with predefined options to choose from when generating reports. It ensures data integrity by making sure that valid and relevant variable values are selected, reducing errors in reports.
This process is a logical continuation of the workflow that starts with defining the list of predefined variable values in Toad Data Point or Toad Workbook, followed by publishing the object to Toad Intelligence Central. Once published, users can work with these values directly in TIC.
For more details about this feature, see the Quick Start Guide, section Objects > Custom List of Values for Bind Variables.
Support for CSV and Excel Files on SharePoint Online File System
In Toad Intelligence Central 6.4.1, users can runand manage objects published from Toad Data Point that utilize CSV and Excel files stored on SharePoint Online, allowing for easy access, import, export, and sharing of data.
For more information on working with files stored on SharePoint Online, see the Toad Data Point User Guide.
Snowflake KeyPair Authentication Support for Published Objects
Toad Intelligence Central now supports working with objects published from Toad Data Point or Toad Workbook using Snowflake KeyPair authentication. This includes running Workbooks and Automation scripts published with this authentication type directly on TIC. Publishing Views and Snapshots with Snowflake KeyPair authentication is not yet supported; this capability will be introduced in a future release.
When working with or publishing objects using a Snowflake connection, it is recommended to use KeyPair authentication in TDP, as Snowflake plans to discontinue password-based sign-ins. This will help maintain compatibility and prevent future connection issues.
See Resolved issues for enhancements and resolved issues in this release of Toad Intelligence Central.
Deprecated Features
Integration with Toad for Oracle has been discontinued. The Toad for Oracle Code Quality, Code Analysis, Code Tester, Team Coding, and DB Health Check pages have been removed in Toad Intelligence Central 5.0. Beginning with Toad for Oracle 13.1, you can no longer connect to Toad Intelligence Central and you cannot publish scripts, files, Code Analysis results, and other resources to a Toad Intelligence Central server.
The Admin Console. Beginning with Toad Intelligence Central 4.3, the Admin Console is no longer required and is not included in the Toad Intelligence Central installation. The administrative functionality of the Admin Console is now superseded by the Web Server (Web Console). The activity of mapping/editing data objects is best performed through Toad Data Point.
After installing Intelligence Central 4.3 or later, it is recommended that you uninstall any earlier version of the Admin Console as some functionality may no longer be supported.
Authentication Keys for Views. Beginning with Toad Intelligence Central 4.3, a view can now have only one type of key, personal or shared. This change is designed to simplify the process of Authentication. If you are upgrading from Intelligence Central 3.3 or earlier, please see the Upgrade section of the Toad Intelligence Central Deployment Guide for more information.
Toad for Oracle Installation. Beginning with Toad Intelligence Central 4.3, Toad for Oracle is no longer installed as part of the Toad Intelligence Central installation.
Run in Debug Mode. In Toad Intelligence Central 3.3, the Run in debug mode option was removed from the Web console (Web server). It is no longer necessary to enable/disable debug mode. Debug-level information is always logged and automatically included in the support bundle. This release also includes improved logging strategies and archiving methods.
The use of SSL 3.0, TLS 1.0 and TLS 1.1 has been discontinued.
The use of RC4 cipher has been discontinued.
The use of SWEET32 medium strength cipher has been discontinued.
Resolved Issues
Resolved Issues and Enhancements
The following is a list of issues addressed and enhancements implemented in this release of Toad Intelligence Central:
| Resolved Issue | Issue ID |
|---|---|
|
"Error refreshing '<variable name>' variable" error is encountered when refreshing the prompt list values for the bind variable in the automation script |
TIC-14422 |
|
Date values change format when refreshing the prompt list value dropdown for the bind variable |
TIC-14411 |
|
"A character string failed conversion to a numeric value" error is encountered after refreshing the prompt list for Date variable and selecting a new value on Toad Intelligence Central |
TIC-14409 |
|
Sort and search options are missing in the prompt list values dropdown list for the bind variable |
TIC-14393 |
|
"Wrong username or password" error is encountered when refreshing the prompt list for a bind variable defined via 'Specify value(s)' option |
TIC-14460 |
|
"Error refreshing 'VariableName' variable: Wrong username or password" error is encountered when refreshing the prompt list values for the bind variables in Workbook, Automation Script, or View on Toad Intelligence Central |
TIC-14429 |
|
"Tried opening a closed connection" error is encountered intermittently when running automation scripts with consecutive steps sharing the same connection |
TIC-14467 |
|
The prompt variable list dropdown closes automatically when the search returns no match |
TIC-14462 |
|
"Error Fail to get artifact exception list. undefined" error is encountered when clicking the Exception tab in Health Check Dashboard on Toad Intelligence Central |
TIC-14423 |
|
Error is encountered when viewing data for View with a long-running query on Toad Intelligence Central |
TIC-14439 |
|
The last two columns in the Toad Intelligence Central variable window are not fully visible |
TIC-14390 |
Resolved Issues in Toad Data Point—If you are using Toad Data Point to publish objects to Intelligence Central or to run Automation scripts on Intelligence Central, you might want to also review resolved issues in the Toad Data Point Release Notes.
Enhancements
Improved Home Tab Load Time Performance
Overview
This release introduces a backend performance enhancement aimed at significantly improving the load time of the Home tab in Toad Intelligence Central (TIC), especially in environments with a high volume of users and published/shared objects.
Background
Previously, TIC loaded all folders, subfolders, and files shared with a logged-in user during the initial load of the Home tab. As the number of users and shared objects increased, this process led to substantial delays, with loading times exceeding 15 minutes in some cases.
Enhancement Details
- Optimized the loading behavior by initially retrieving only the top-level shared folders. The contents of subfolders are now loaded on demand (when expanded), significantly reducing initial data volume.
- Streamlined and reduced data in API calls to avoid unnecessary payload and improve response times.
- Identified and optimized database views and stored procedures that were previously inefficient when handling large datasets.
- Refactored UI and API logic to eliminate bottlenecks without altering the user experience.