Chat now with support
Chat with Support

Toad Intelligence Central 3.3 - Release Notes

Release Notes

Toad® Intelligence Central 3.3.1

Release Notes

August 2017

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 and Admin Console 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
  • Hive™
  • Microsoft® Analysis Services
  • OData - Generic for any OData service versions 1, 2, 3 and 4.

 

Intelligence Central 3.3.1 is a maintenance release. See Resolved issues.

 

New Features

Toad Intelligence Central 3.3.1 is a maintenance release. See Resolved issues for a list of resolved issues and minor enhancements in this release.

Toad Intelligence Central 3.3 includes the following new features and enhancements.

Toad Data Point

Enter Variable Value

For views and Automation scripts that were published with variables, Intelligence Central prompts the user for values at run time.

Views with Variables

This release of Toad Intelligence Central includes an exciting new feature. When you download or filter a published View in which the defining SQL contains a variable*, Intelligence Central prompts you for the variable value. This is useful as it allows data consumers to provide their own variable value at the time they execute the View. Data consumers have a choice to use the default value or enter a new value.

The new value entered applies to the current download only. Each variable has a default value. The default value is specified by the publisher at the time of publishing and can be modified through Toad Data Point.

Note: *This feature is only available for Views published from Toad Data Point 4.2 or later. The associated Toad Data Point features—the ability to publish a View containing a variable and the ability to modify the default value—are available only in Toad Data Point 4.2 or later.

Automation Scripts with Variables

When you manually run a published Automation script** which executes SQL containing a variable, Intelligence Central prompts you to enter a variable value. You can enter a new value or use the default. The value entered is used in the current manual execution only .

  • For scheduled scripts, Intelligence Central uses the default value. The default value is specified by the publisher at the time of publishing and can be modified through Toad Data Point.

Highlights:

  • The default value is used by scheduled scripts, eliminating the need to prompt for a variable value.
  • You can modify the default value for a published script at any time through Toad Data Point (View Details | Variables).
  • You can manually run an Automation script through the Web interface and supply a new variable value (for the current run only).

Note: **The Enter Variables feature is only enabled for Automation scripts published from Toad Data Point 4.2 or later. The associated Toad Data Point feature—the ability to modify the default value for a published Automation script— is available only in Toad Data Point 4.2 or later.

Filtering Data

You will find the following new enhancements when filtering data to download from a data object (view, snapshot, dataset).

OR Operator

  • When creating a filter with more than one condition, you can now apply the OR operation.

Quick Filtering and Data Preview

In the data preview window, you can quickly filter a column by entering a value in the text box below the column header. Now the filter is not applied until after you press ENTER, resulting in a smoother data preview process.

To quickly filter a column in the preview window

  1. Enter a value in the text box below the column header.
  2. Press ENTER. The filter is applied to the sample data.

Email Notifications and Error Alerts

This release of Intelligence Central includes several new enhancements that provide added functionality in the area of email notifications and error alerts.

Add Email Address for Administrator (root) User

You can now specify an email address for the Administrator (root) account. Only the Administrator (root) user can add the email address for this account. To add an email address for the Administrator (root), do the following:

  1. In the Web interface select Administration | Users.
  2. Select the Administrator (root) user to display the account details in the right pane.
  3. Click Edit in the Details pane. Then enter an email address in the Details dialog.

Receive Error Alerts

You can now receive an error alert by email when Automation script execution or snapshot refresh fails for an object you own or manage. To enable error alerts for your user account, do the following:

  1. In the Web interface, go to Administration | Users.
  2. Select your user name.
  3. Click Change subscription in the Details pane.
  4. Select Error Alerts.

Unsubscribe to the Personal Digest through the Web Interface

Users can now subscribe/unsubscribe to the Personal Digest email through the Web interface. In the previous release, a user could only unsubscribe through their Personal Digest email (using the Unsubscribe link).

  1. In the Web interface, go to Administration | Users.
  2. Select your user name.
  3. Click Change subscription in the Details pane.
  4. Clear the Personal Digest check box to unsubscribe.

New Intelligence Central Admin Daily/Weekly Digest Email

Users with the Administrator role can now receive an Intelligence Central Admin Digest email. This email is similar to the Personal Daily Digest, but contains information relevant to the Administrator role. Users can elect to receive this digest on a daily or a weekly basis.

  • To enable the Admin Digest for an Administrator user, in the Web interface select Administration | Users. Select a user and then click Change subscription in the Details pane. In the Email Subscription dialog, select Admin Digest (Daily) or Admin Digest (Weekly) or both. If both check boxes are cleared, this user receives no Admin Digest.
  • The Admin Digest provides a summary of daily or weekly activities relevant to Administrator users.
  • Note: Email Notifications must be enabled on the Intelligence Central server before the Admin Digest can be sent to Administrator users.

Administrator Role Can Configure Email Notifications for Other Users

Users with the Administrator role can subscribe/unsubscribe other users to the email notifications, which include:

  • Personal Digest
  • Error Alerts
  • Daily Admin Digest
  • Weekly Admin Digest

Connections

OData Version 4. This release includes support for OData version 4.

Installation

System Requirements. Beginning with this release, Microsoft .NET Framework 4.5.1 is required.

General

Simplified Support Bundle Process. The process of generating a support bundle has been simplified. The support bundle now automatically includes debug-level information. It is no longer necessary to enable Debug mode prior to generating a support bundle. The debug-level information is already included in the log.

  • To generate a support bundle, open the About box and select Contact | Generate a support bundle.

The Run in debug mode option has been removed from the Web console. Improved logging strategies and archiving methods make it unnecessary to require enabling/disabling of Debug mode. For more information, see Deprecated Features.

See Resolved issues for more enhancements and resolved issues in this release of Toad Intelligence Central.

Deprecated Features

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.

Product Licensing through the Admin Console. The Admin Console can no longer be used to add / remove Toad Intelligence Central licenses. Use your web browser instead.

Azure DataMarket. You can no longer map an Azure DataMarket data source in the Admin Console.

Resolved Issues

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

Resolved Issues in 3.3.1

Resolved Issue Issue ID
Web Server: This enhancement limits access to view the query text for a view or snapshot. Now only the object owner, the Administrator (root), users with the Administrator role, and other users with Manage privileges to the object can view the query text for a view or snapshot. TIC-7190
Web Server: This enhancement limits access to the detailed Automation script log. Now only the object owner, the Administrator (root), users with the Administrator role, and other users with Manage privileges to the object can view the detailed execution log for an Automation script. TIC-7519

Resolved Issues in 3.3

Resolved Issue Issue ID
Access: Corrected an issue that caused a "4200 bad allocation" error when executing a cross-connection query using a 64-bit Access ODBC driver. TIC-6233
Access: Corrected an issue that caused an error when using a 32-bit ODBC driver when querying a mapped table from an Access database. TIC-6090
Administrator Role: A user with the Administrator role has Manage privileges on all Toad Data Point documents and scripts, including the ability to execute an Automation script which has a "Private" Sharing/Visibility option, as expected. TIC-7001
Apache Hive: Data in Array data type columns now displays as expected in the Toad Data Point Database Explorer (Viewer), Data tab. TIC-6417
Apache Hive: Added support for Hive split() function. TIC-6304
OData: Added support for OData version 4. TIC-6377
Oracle: Corrected an issue that caused an error because portions of the SQL query were not pushed down to Oracle as expected. TIC-6772
Query: Corrected an issue that prevented a query containing a CASE statement from executing successfully. TIC-6332
Query: Improved data type mapping, specifically "unsigned" data type. TIC-6040
Snapshot Refresh: Corrected an issue that caused a "Column message cannot be null" in Event Viewer. Scheduled snapshots were running on schedule and executing successfully. TIC-6415
User Interface (Web server): Corrected an issue in which charts were not refreshed if the selected time period had no data. TIC-6253
User Management: Corrected an issue in which privileges were not granted again when a disabled user was re-enabled. TIC-6256
Web Server: When filtering data in the preview window, the filter is now applied after the user presses ENTER, resulting in a better user experience. TIC-6455
Web Server: Corrected an issue that caused an error and prevented an Active Directory user from downloading a published snapshot through the Web interface The error text included the following: "The directory name is invalid. TIC-6462
Web Server: Improved Search performance on the Home page when the number of objects in Intelligence Central is very large. TIC-6313

Resolved Issues for Toad Data Point—If you are using Toad Data Point on an Intelligence Central server to run Automation scripts, or if Toad Data Point users are publishing objects to Intelligence Central, you might be interested in reviewing the Toad Data Point Release Notes.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents