Feb 20, 2020 3:15:00 AM by Jeff Surretsky
Toad Intelligence Central, a perfect companion to Toad Data Point, has a new release out--and we're pretty excited about it. Keep reading to learn and see how 6 new features work.
If you are a current user of Toad Intelligence Central (TIC), you’ll be very excited to see these newly-added enhancements in 5.1. If you aren’t a Toad Intelligence Central user, what are you waiting for?!?
Toad Intelligence Central 5.1 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 data sets, queries and Toad files and providing a secure, established way to manage your data sprawl.
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.
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.
Now you can transfer ownership of a group to another TIC user. Here's how:
Admin users now can specify which user roles are allowed to can create user groups. Here's how:
This new release of Toad Intelligence Central 5.1 includes a new enhancement that admin user can update object owner/run as by batch in TIC web console. Here's how:
Update owner for snapshots/datasets/views
Update owner/run as/credential for automation scripts
We created a new restful interface for running Toad Intelligence Central from a command line.
To execute via a command line
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
This new release of Toad Intelligence Central 5.1 includes a new enhancement that admin user can set default email subscription for new added user.
Toad Intelligence Central 5.1 enables you and your team to be more productive by empowering you to be more collaborative. Whether you’re sharing data, reports, graphs or any other artifact produced to Toad Data Point, your team can access these from any browser. You can even use the Toad Intelligence Central server for centralized automation of these artifacts!
It’s an optional add-on that most of our users can’t live without!
Is Toad Intelligence Central new to you? Get to know this helpful product so you can access and prepare data quickly and efficiently. Try if for free for 30 days.
If you're in a trial and Toad Intelligence Central is helping you access and prepare data for faster business insights, buy it now or contact a sales representative.
If you've already purchased Toad Intelligence Central, upgrade to the newest version now.
More useful resources3-minute video: Toad Intelligence Central Product Overview Step-by-step installation tutorial video: How to set up Toad Intelligence Central Blog: Learn how to Publish Toad Data Point Automation Scripts to Intelligence Central Case study: Dell: Reports Automation Saves Hours of Analysis Data sheet: Toad Intelligence Central Product page: Learn more about how you can become data-driven with data prep and provisioning across data systems. |
If you have any questions, please post them to the Toad Intelligence Central forum. Have a great idea you want us incorporate into our product? Submit new product enhancement ideas directly to the development team, you can even vote on ideas submitted by others in our Idea Pond.
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Tags: Toad Data Point Toad Intelligence Central Analysis cross platform Data Prep collaborate data cleansing
Written by Jeff Surretsky
Jeffrey Surretsky has been working at Quest since 2000 as a Sales Engineer focusing on a wide variety of solutions including Foglight, SharePlex and the TOAD Family of Products. Before working at Quest, he was a DBA for various organizations spanning a diverse range of industries including but not limited to Insurance and Telephony . With almost 35 years of experience in the Information Technology industry, Jeffrey has a Bachelor’s Degree in Computer Science and a Masters Degree in Management of Information Systems.
We use cookies to improve your experience with our site. By continuing to use this site, you consent to our use of cookies. Learn more.