Toad Intelligence Central 5.0 - Release Notes

Release Notes

Toad® Intelligence Central 5.0.6

Release Notes

Wednesday, July 24, 2019

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.

  • Dell® Boomi
  • 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 5.0.6 is a minor release, with enhanced features and functionality. See New features.

 

New Features

New Features

This release of Toad Intelligence Central includes the following new features and enhancements.

Toad Intelligence Central 5.0.6

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

Toad Intelligence Central 5.0.5 is a minor release and includes resolved issues. See Resolved Issues and Enhancements for more information.

Toad Intelligence Central 5.0.3

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.

Toad Intelligence Central 5.0

Secured Folders in Intelligence Central

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.

Highlights

  • Users with certain privileges can create and configure secured folders.
  • Users can see only the secured folders that have been shared with them. By contrast, non-secured folders are visible to all users.
  • An object published to a secured folder inherits the secured folder's visibility and manager privileges.
  • Managers of secured folders can modify folder privileges in the same way that object managers modify object privileges.

  • A secured folder manager can easily change the visibility and manage privileges for all objects within a secured folder at one time by changing the privileges on the secured folder.
  • In addition to visibility and manage privileges, a secured folder has publish privileges. Folder managers can specify which users are allowed to publish objects to the secured folder.
  • Subfolders are not affected by changes to the parent secured folder.
  • After moving an object into a secured folder, the object's visibility (sharing) and manage privileges are automatically modified to match those of the folder.
  • Secured folder activity can trigger email notifications to applicable users.
  • Users with the Administrator role can determine what type of folders can be created: secured, non-secured, or both.
  • Users with the Administrator role can specify which user role (or roles) are allowed to create secured folders.

Secured Folder Restrictions

  • A secured folder cannot contain a non-secured folder. A non-secured folder cannot contain a secured folder.
  • To move a secured folder, a user must have the Administrator role or manage privileges to the secured folder and all its subfolders.
  • Only Intelligence Central Administrators can configure secured folder settings at the server level.

Folders in Intelligence Central

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.

Downloading Data

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

Find Help

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.

  • In the Web Console, click and select User Forum.

New Report Provides User Activity Information

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.

Details

  1. To open the User Activity report, select Reports | User Activity.
  2. Select a time period to display a list of the top 10 most-active users during this period.
  3. Then filter the list to show either the most-active Publishers or most-active Consumers.
  4. Click N Active Users to display an expanded list of user activity. You can export data from the Active Users page.
  5. Click a user name to display all activity for that user. You can export data from the user page.

Administrator Activities

Health Check Enhancements

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.

  1. To view errors, select Administration | Server | Health Check Dashboard and then select the Exception tab.
  2. 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.

  3. Click the object name to go to the object on the Home page where you can use object information and execution logs (Automation script) to troubleshoot the issue. An object is removed from the list after a subsequent successful execution or successful download.

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.

  1. To check for unused temp tables, select Administration | Server | Health Check Dashboard in the Web Console.
  2. Click Run Health Check.
  3. When the Health Check is finished, any unused temp tables found are listed in the Data Integrity tab. To delete an unused temp table, click Repair in the row for that table.

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.

  1. Open the Web Console and select Administration | Server | Health Check Dashboard.
  2. Click Run Health Check.
  3. When the Health Check is finished, select the Object Owner Transfer tab.

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

Email Notification Changes

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:

  • If all types of email subscriptions are removed from a user's profile (Administration | Users), the user is no longer automatically moved to the Unsubscribed list in (Administration | Server | Notifications). To disable email notifications for a user, move the user to the Unsubscribed list.

Schedule Active Directory Synchronization

You can now schedule an Active Directory synchronization. This allows you to perform the synchronization overnight or when activity is low.

  • In the Authenticate to Active Directory dialog, when you select Remember these credentials on server for future Active Directory access and synchronization, Intelligence Central allows you to enter scheduling information.
  • After a synchronization is scheduled, the scheduling information and status are displayed in Administration | Server | Users. From this page, a user with the Administrator role can edit the schedule.

Connections

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.

Installation

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.

Deprecated Features

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.

Resolved Issues

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Intelligence Central.

Resolved Issues in 5.0.6

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 Issues in 5.0.5

Resolved Issue Issue ID
This release includes support for Oracle Business Intelligence Enterprise Edition 12.2.1.4.0. This corrects an issue in which values were incorrectly displayed as null when connected to an OBIEE 12.2.1.4.0 data source. TIC-11461, TIC-11520

Resolved Issues in 5.0.3

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 Issues in 5.0

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.

Herramientas de autoservicio
Base de conocimientos
Notificaciones y alertas
Suporte de productos
Descargas de software
Documentación técnica
Foros de usuarios
Tutoriales en video
Comuníquese con nosotros
Obtenga asistencia con las licencias
Soporte Técnico
Ver todos
Documentos relacionados