Wednesday, July 24, 2019
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®.
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.
A valid data connectivity license supports the following Business Intelligence Data Sources.
Intelligence Central 5.0.6 is a minor release, with enhanced features and functionality. See New features.
This release of Toad Intelligence Central includes the following new features and enhancements.
Toad Intelligence Central 5.0.6 is a minor release and includes resolved issues. See Resolved Issues and Enhancements for more information.
Toad Intelligence Central 5.0.5 is a minor release and includes resolved issues. See Resolved Issues and Enhancements for more information.
Support for Additional Cassandra Data Types. This release includes support for the following data types in Apache Cassandra: date, decimal, duration, inet, smallint, time, tinyint, and varint.
Support for Cassandra Materialized Views. This release includes support for Materialized Views, introduced in Apache Cassandra 3.0.
Deploy Toad Intelligence Central from Azure Marketplace. Toad Intelligence Central is now available in the Microsoft Azure Marketplace. This pre-installed offering provides a quicker, more-simplified deployment of Intelligence Central in Azure. To locate Toad Intelligence Central in the Azure Marketplace, go to Microsoft Azure Marketplace and search for Quest Toad Intelligence Central. For more information about deploying Intelligence Central in Azure, see the Toad Intelligence Central Deployment Guide.
This release includes a sweeping new feature: Secured Folders. Secured folders are special folders in Toad Intelligence Central. Secured folders have visibility (sharing), manage, and publish privileges assigned to them. When an object is published to a secured folder, the object automatically inherits the sharing (visibility) and manage privileges of the secured folder.
Secured folders are identified by a red folder icon.
The secured folder feature is enabled at the server level. An Intelligence Central server can contain both secured folders and non-secured folders, or just one type of folder. In addition, you can restrict the number of users who can create and initially configure secured folders. This restriction is controlled by means of the user roles.
This new feature helps you and your organization define a methodology for controlling and regulating the sharing and management of objects, files, and data in Intelligence Central.
Managers of secured folders can modify folder privileges in the same way that object managers modify object privileges.
Secured Folder Restrictions
View Folder Information. You can now view detailed information about folders in the Details pane, including folder name, date created, date modified, as well as the user who modified the folder.
To view folder information, open the Web Console and select a folder on the Home page. Folder information is displayed in the Folder Details pane.
Users Can Now Move Folders. The ability to move folders is no longer restricted to Administrators only. Standard and Power users can now move a folder in which all objects are owned by or managed by the user.
Users Can Now Move Objects. The ability to move objects is no longer restricted to Administrators only. Standard and Power users can move objects owned by or managed by the user.
"Not NULL" Variable Value is Now Available
You can now select "Not NULL" for the variable value when downloading or filtering a published View or when modifying the View's variable default value. To use the "Not NULL" value, select it from the drop-down list.
Technical Documentation. You can now go directly to Toad Intelligence Central technical documentation on the Support Portal from within the Web Console.
On the Support Portal you can find the Release Notes, the User Guide, the Deployment Guide (installation and Administrator information), and What's New in This Release for the current and earlier versions of Intelligence Central.
In the Web Console, click and select Technical Documentation.
User Forum. You can now go directly to the Toad Intelligence Central User Forum on Toad World from within the Web Console.
This release of Toad Intelligence Central includes a new report that provides user activity statistics. The User Activity report allows you to identify which users are the most-active publishers and the most-active users, as well as what objects each user is publishing or downloading/querying. This report is designed mainly for Administrators, but all users can view and export user activity data.
View a Summary of Errors / Exceptions
The Health Check Dashboard page now displays a summary of objects with current errors in Intelligence Central.
Users with the Administrator role can view the list of current errors.
Objects with errors are displayed along with the error message and the time of the last error. Objects are grouped by object type. For objects with consecutive errors, only the last error is displayed.
Find Unused Temp Tables
You can now use a Health Check analysis to find unused temp tables. Unused temp tables can result from a query that is canceled in Toad Data Point. If an unused temp table is found, it is listed in the results in the Health Check Dashboard page of the Web Console.
Users with the Administrator role can run a Health Check and repair objects.
Transfer Objects to a New Owner
A Health Check analysis now finds objects owned by accounts that no longer exist or are no longer enabled in Intelligence Central. This allows you to easily reassign those objects to a new owner. For example, you might want to reassign objects owned by an account for an employee no longer in your organization.
Users with the Administrator role can run a Health Check and transfer object owner.
When the Health Check is finished, select the Object Owner Transfer tab.
To transfer an object to another owner, click Transfer to new owner in the row for that object. Then select a user to serve as the new owner.
This release includes changes to the relationship between the Unsubscribed list and an individual user's list of email subscriptions, which results in the following changes to Intelligence Central behavior:
You can now schedule an Active Directory synchronization. This allows you to perform the synchronization overnight or when activity is low.
SharePoint Online. This release includes support for SharePoint Online.
MongoDB Authentication. The following authentication/connection methods are now supported for MongoDB connections: Kerberos, LDAP, SSL, and x.509 certificate authentication.
Web Server. The Intelligence Central Web Server is now installed automatically as part of the Intelligence Central Server installation process. In addition, the Web Server installation directory is now under the Toad Intelligence Central installation directory.
C:\Program Files\Quest Software\Toad Intelligence Central\webserver
During installation, a Toad Intelligence Central Web Server shortcut is automatically added to the desktop.
See Resolved issues for more enhancements and resolved issues in this release of Toad Intelligence Central.
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 following is a list of issues addressed and enhancements implemented in this release of Intelligence Central.
|Resolved Issue||Issue ID|
|Firewall rules have been improved.||TIC-11613|
|Cross-Connection queries on SAP ASE now work correctly with encryption. EncryptPassword=1 has been added to connection strings.||QAT-14575|
|Resolved Issue||Issue ID|
|This release includes support for Oracle Business Intelligence Enterprise Edition 220.127.116.11.0. This corrects an issue in which values were incorrectly displayed as null when connected to an OBIEE 18.104.22.168.0 data source.||TIC-11461, TIC-11520|
|Resolved Issue||Issue ID|
|Web Console: Corrected an issue which caused an error when attempting to alter Authentication through the Web Console for a MongoDB datasource that uses the SSL or x.509 certificate authentication method.||TIC-10864|
|Active Directory Users: Corrected an issue in which a disabled user was unexpectedly enabled in Intelligence Central after synchronizing with the Active Directory domain.||TIC-11097|
|Snapshot Refresh: Corrected an issue in which the data type of a column in a published snapshot unexpectedly changed to varchar after the snapshot was refreshed.||TIC-11224|
|Corrected an issue which caused reduced performance when attempting to access folders containing large objects or files in Toad Intelligence Central. This issue was encountered in Toad Data Point.||TIC-11225|
|Corrected an issue which prevented the retrieval of column information from tables with the JsonSerDe row format in Hive 3.0 or later. This issue was encountered in Toad Data Point in areas such as the Database Explorer (Viewer).||TIC-11299|
|Automation Script Execution: Corrected an issue which caused an Automation script containing a Data Compare activity with a very large Data Compare file to fail while running on Intelligence Central.||TIC-11335|
|Resolved Issue||Issue ID|
|Administration | Users: The Edit button is now disabled for a user whose status is "Disabled."||TIC-6565|
|Automation Script: Corrected an issue that allowed a user to edit the default variable value in a script during the initial phase of execution.||TIC-7550|
|Automation Script: Corrected an issue which caused an incorrect "Next run" date to display when the schedule specified an execution frequency as well as a date at which to run once.||TIC-7373|
|Automation Script: If a script is not scheduled, the object details no longer display a "Next run" date.||TIC-7374|
|Automation Scripts: Corrected an issue in which the status of "Running" was displayed for a script that was cancelled abnormally, such as when stopping the process in Toad Data Point. This resolution requires Toad Data Point 5.0 (or later) and Intelligence Central 5.0 (or later).||TIC-9122|
|Backup: The Intelligence Central backup script (backup.bat) now stops all services, not just the Toad Database Server service.||TIC-9990|
|Dataset: Corrected issues found for data containing image columns when the dataset was previewed or downloaded to a CSV file.||TIC-7537|
|Email Notifications: Corrected an issue that unexpectedly added a user to the email subscription list after the user's role was changed from Standard to Administrator. This issue was encountered only after an Intelligence Central upgrade.||TIC-7516|
|Enhancement: You can now edit the variable description through the Web Console. A user must have manage privileges to the object to edit the variable description.||TIC-9028|
|Excel Cross-Connection Query: Corrected an issue that caused the following error in a cross-connection query with an Excel table: "Server error 4208: ODBC data source returned an error: COUNT field incorrect."||TIC-7640|
|Excel: Corrected an issue that resulted in truncated data in a VARCHAR column when data was published as a dataset from Excel.||TIC-6185|
|Folders: While an object is being published, if the target folder is deleted before the process is finished, the process fails with an error message.||TIC-7963|
|General: Improved precision for data values in SSAS, Salesforce, Google Analytics, and Hive.||TIC-9921|
|Health Check Dashboard: Corrected an issue that caused an error if the weekly health check analysis executes while a manual health check is currently in process.||TIC-8838|
|Health Check Dashboard: You no longer need to restart the service to enable "Auto Run" for the Health Check report after changing the system date.||TIC-8396|
|Home Page (Search Results): Corrected some issues related to moving objects and creating folders when using the list of results returned from a Search.||TIC-8499|
|Installation: Corrected an issue that caused installation to fail when the user entered a password containing special characters.||TIC-7415|
|Installation: Corrected an issue which caused Toad Data Point installation to fail after a successful Intelligence Central installation. The following error message was displayed: "Unable to cast object of type 'System.Byte' to type 'System.String."||TIC-9717|
|Log in: Corrected an issue that prevented successful log in to the Web Console by an Active Directory user with limited privileges.||TIC-10344|
|Migration: Corrected an issue in which Automation scripts did not run successfully after migrating Intelligence Central data files to a new server. This resolution requires Toad Data Point 5.0 (or later) and Toad Intelligence Central 5.0 (or later).||TIC-9904|
|MySQL: Corrected an issue that caused the number of digits to be trimmed from values in a MySQL INT column when data was published as a snapshot or view.||TIC-6100|
|MySQL: Corrected an issue that caused the number of digits to be trimmed from values in a MySQL SMALLINT column when data was published as a snapshot or view.||TIC-6098|
|MySQL: Corrected an issue that caused the number of digits to be trimmed from values in a MySQL TINYINT column when data was published as a snapshot or view.||TIC-6097|
|Query (Supported Syntax): Corrected an issue that caused a SQL syntax error when executing SQL in which the LIKE clause contained the "||" character.||TIC-8866|
|Query (Supported Syntax): Corrected an issue that caused an error when attempting to query a view using a Select statement that includes "Limit 0".||TIC-7856|
|Query (Supported Syntax): Corrected an issue that returned incorrect results for some statements in which the WHERE clause included a LIKE condition.||TIC-7981|
|Query: Corrected an issue that caused an "ORA-00904: invalid identifier" error when attempting to query (using Toad Data Point) a published view that uses UNION to join more than two sub-queries.||TIC-9671|
|Reports: Corrected an issue in which inaccurate statistics were displayed in the graph when server and client are in different time zones.||TIC-7029|
|SAP ASE: Corrected an issue that caused values in a decimal datatype column to be truncated in a published snapshot. This issue was encountered when publishing data from an SAP ASE data source as a snapshot using Toad Data Point.||TIC-6178|
|SharePoint Online: (Enhancement) This release includes support for SharePoint Online.||TIC-9465|
|Snapshot Refresh: If a snapshot is scheduled to refresh every x weeks, it now refreshes at the expected interval, instead of weekly.||TIC-7357|
|Snapshot: Corrected an issue that caused an error when publishing a snapshot from data in which the row size is very large (over 8126 bytes). If an issue is encountered in this scenario, it is recommended to reduce the number of varchar columns to not more than 10.||TIC-8388|
|Snapshot: Corrected an issue that caused Intelligence Central to quit unexpectedly after a scheduled snapshot was deleted using Toad Data Point. This issue resolution requires Toad Data Point 5.0 (or later) and Intelligence Central 5.0 (or later).||TIC-10222|
|SQL Server: Corrected an issue that resulted in truncated data in SQL Server VARCHAR(MAX) and NVARCHAR(MAX) columns when data was published as a snapshot or dataset.||TIC-6095|
|User Interface: An informative error message now displays if the user attempts to modify an object and one of the Toad Intelligence Central server services is not available.||TIC-7490|
|User Interface: Resolved issues with the display of text in the Query tab of the Details pane when Internet Explorer is used.||TIC-7544|
|Variables: When downloading or filtering an object containing a variable, entering a space for the variable value no longer causes an error.||TIC-8216|
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.