Chat now with support
Chat with Support

Toad Intelligence Central 5.1 - Release Notes

Release Notes

Toad® Intelligence Central 5.1.x

Release Notes

Wednesday, January 22, 2020

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 5.1.3 is a patch release, with resolved issued, enhanced features and new functionality.

 

New Features

New Features

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

Toad Intelligence Central 5.1

Modify timeout values

Admin users now can update session timeout value.

  1. Select Administration | Server in Web Console
  2. Administrator users can update the “Session timeout” and “Remember me interval” values

b) At the bottom of the Settings tab,

Automatic backup for Toad Intelligence Central upgrade

When you decide to upgrade your installation of Toad Intelligence Central, you can choose to have the server installer auto back up the data folders and use them to roll back the user data in case of any errors.

The upgrade wizard of Toad Intelligence Central provides an option to backup data folder automatically, you can select another folder for backup.

Transfer group owner

Now you can transfer ownership of a group to another TIC user.

  1. Select Administration | Groups in Web Console
  2. Select a group, which you want to modify
  3. Transfer owner to assign ownership permissions

Create user group

Admin users now can specify which user roles are allowed to create user groups.

  1. Use a web browser to log in to Toad Intelligence Central as a user with the Administrator role
  2. Select Administration | Server | Permissions
  3. Select an option in New Group Creation

Update object owner

This release of Intelligence Central includes a new enhancement that admin user can update object owner/run as by batch in TIC web console.

Update owner for snapshots/datasets/views

  1. In the Web Console select Administration | Objects, select the Object Management tab.
  2. Filter the objects by object name or owner name, then tick the objects that need to be changed owner.
  3. Click the Transfer Owner button to select the new owner for the selected objects.

Update owner/run as/credential for automation scripts

  1. In the Web Console select the Administration | Objects, select the Automation Script Management tab.
  2. Filter the automation scripts by script name or owner name, then tick the automation scripts that need to be update.
  3. Click the “Update” button to popup the automation script management window.
  4. Select the new owner in the “Select a new owner” tab, user can also just skip this operation(do not change the owner) and click “Next” button.
  5. Input the new run as credential info in the “Update run as credential”, user can also just skip this operation(do not change the run as) and click “Next” button.
  6. Update the connection credential for the automation script in “Update connection credential” tab if needed.
  7. Then click “Done” button to finish the workflow.

Execute automation script via command line

We created a new restful interface for running TIC from a command line.

To execute via a command line

  • Install curl, download it from https://curl.haxx.se/windows/. Some versions of Windows ships with a copy of curl (for example, Windows 10, version 1803 or later).
  • Input the curl cmd in windows command line console. General guide line , we need to provide a Toad Intelligence Central user account/password, script folder and script name to execute the script.

Note: The user account must be the account that the automation script has been shared with, means the user login TIC web console can see the automation script in home page, e.g. - user name: root , password: 123 , script folder: /parent_folder/sub_folder , script name: script_sample.

Command - curl -X POST -i -u root:123 -H "Content-Type:application/json" -k -d "{\"scripts\":[{\"folder\":\"/parent_folder/sub_folder\",\"script_names\":[\"script_sample\"]}]}" https://localhost:8066/tic/v1/script/run

More samples:

Sample1 - user name: vincent , password: 123 , script folder: /No folder assigned , script name: query_order

Command - curl -X POST -i -u vincent:123 -H "Content-Type:application/json" -k -d "{\"scripts\":[{\"folder\":\"/No folder assigned\",\"script_names\":[\"query_order\"]}]}" https://localhost:8066/tic/v1/script/run

Sample2 - user name: root , password: 123 , script folder: /No folder assigned , script name: query_order

Command - curl -X POST -i -u root:123 -H "Content-Type:application/json" -k -d "{\"scripts\":[{\"folder\":\"/Sales\",\"script_names\":[\"query_order\"]}]}" https://localhost:8066/tic/v1/script/run

Add default email subscription for new added user

This release of Intelligence Central includes a new enhancement that admin user can set default email subscription for new added user.

  1. In Web Console select the Administration | Server
  2. Select Notifications, the default email subscription is only available when the Email notification is on.
  3. Set up default email subscription.

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

Resolved Issue Issue ID
Guardian now supports concurrent Automation Script Execution TIC-12338/4608436
MongoDB Connection Table Display with Nested Objects TIC-12129/TIC-12333/4590621
Configure HTTPS in TIC 5.1 TIC-12332/4611636
New server option "Only the Administrator create groups" TIC-12293/4613599
Auto rollback data on failure to upgrade TIC-12289
Issue when permissions were not saved has been fixed TIC-12245/4603555
MongoDB data is now correctly fetched after a table has been mapped TIC-12218/4590621

Resolved Issues in 5.1.2

Resolved Issue Issue ID
We fixed an issue that caused FormatException in non-English environments. 11962/4580567
Renaming folders now works correctly. 12180/4586899
TIC has improved performance of publishing multiple schemas. 12043/4534571
Now you can assign a group ownership to another TIC user. 12031/4571136

Resolved Issues in 5.1

Resolved Issue Issue ID
Publishing objects to secured folder with AD user now works correctly. 11875/4586899
Automation script execution history can now be deleted automatically. 11812/4530615

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.

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