Mar 12, 2020 3:07:00 AM by Jeff Surretsky
In this release of Toad Data Point Workbook, the most noticeable enhancement will be the newly redesigned Workbook. Other updates include new features, security enhancements, and resolved issues.
Specific features we'll explore in this blog are:
Toad® Data Point is a multi-platform database query tool built for anyone who needs to access data, understand data relationships, and quickly produce reports.
The purpose of the ODBC provider is to offer basic connection and querying capabilities to any database that supports an ODBC 3.0 or later driver. For a list of databases tested with the ODBC provider, see the System Requirements in the Release Notes. This form of connectivity allows connections to databases such as Netezza, IBM iSeries, Ingres, and Vertica™. Because this form of connectivity is generic, it is not full-featured and may not be as robust as the fully-exploited providers for the other databases.
Toad Data Point provides users with the ability to connect to non-traditional data sources, such as Business Intelligence and NoSQL sources. You can connect to these data sources and explore data and objects, query data, report results, and automate tasks.
The following data sources are supported:
Try Toad Data Point Workbook for free
If you think you're ready to get started now, try Toad Data Point Workbook out with our free 30-day trial.
If you're a loyal fan of Toad Data Point contact support to update/renew your license.
Just click the arrows to display actions available for each of the steps.
Simply left-click to drag and drop any workflow exactly where you want it.
Right-click any workflow step such as Pivot Grid or Transformation and Cleanse and select Copy step and then right-click the place where you want to insert a copy of your step and select Paste step.
You cannot copy and paste Query Builder or Editor query steps but you can clone them into a new workflow. Right-click a workflow query step and select Clone to a new workflow and a new workflow that begins with the duplicated query step will be created.
We optimized performance of Workbook especially when working with large workflows that contain many steps.
Use the following parameter to run Workbook silently from a command line:
e.g. "C:\Program Files\Quest Software\Toad Data Point 5.1\toad.exe" --batch=true "C:\Workbook\MyWorkbook.twf"
We added new options for Group By functions. Right-click a column header and Select from the available Group By options according to your data.
We improved selection of aggregate values of columns. By default, there is no aggregate value set anymore. You can display all available aggregate values when you expand the selection in the field list.
You can set a custom character if you use modified ODBC drivers for connection to your database,
Set it in Tools | Options | Database | ODBC.
For this release of Toad Data Point we have provided internal security adjustments. We have revised a list of third party components in use according to their known and potential vulnerabilities. Toad uses only reliable and safe components by third party vendors. See the list of third party components in Toad Data Point help file, section About Us | Third Party Components.
Our Toad installers are now based on the Wix Toolset , which improves user experience and performance of the installation process.
Workbook is a feature in Toad Data Point. Toad Workbook helps you simplify your report-building process, build reusable workflows and run them all using a single button and output to several locations at once.
Watch this video about Toad Data Point Workbook and learn how to access and prepare data for faster business insights.
Remember, you can find blogs, videos, and forums in the Toad World community.
I hope this blog is useful to you. If you have any questions, please post questions to the Toad Data Point forum on Toad World.
If you think your colleagues would benefit from the this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
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.