New in This Release
Tuesday, March 28, 2017
This release of Toad Intelligence Central includes the following new features and enhancements.
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.
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.
You will find the following new enhancements when filtering data to download from a data object (view, snapshot, dataset).
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
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:
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:
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).
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.
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:
OData Version 4. This release includes support for OData version 4.
System Requirements. Beginning with this release, Microsoft .NET Framework 4.5.1 is required.