New Features
Publish View with Variable in SQL
-You can now publish a view that contains a variable. This new feature allows data providers to include variables in a published view so data consumers can change the value prior to viewing the result set. After publishing, the View owner or users with Manage privileges can modify the default value. In this way users can enter their own variable values prior to viewing the result set.
Note: This new feature is supported in Intelligence Central 3.3 or later.
Prompt for Variable Value when Running Published Automation Scripts
Note: This new feature is supported in Intelligence Central 3.3 or later.
-Automation scripts that allows you to instruct Toad to prompt for a variable value at run time (for manually-executed scripts). This feature is supported for an Automation script executed locally or for a published script executed in Intelligence Central.
This feature applies to the following types of scripts:
•An Automation script containing a Set Variable activity. The Prompt during run option must be selected.
•An Automation script containing a Send Email activity. The Prompt option must be selected. Toad Data Point 4.2 Release Notes
Prompt for run-time value
-When a user manually executes the published script, Toad prompts for a run-time value for each variable in the script. The new value is used in this execution only and the default remains unchanged.
Publish Data from Dimensional Viewer Using Automation
- Automation activity which allows you to export or publish data from a Dimensional View. Use this new activity in Automation workflows such as the following:
•Publish Dimensional Viewer data to Intelligence Central as a dataset. You can publish each view (container) in the Dimensional Viewer document to a separate dataset.
•Publish Dimensional Viewer data to an Excel file. Then add a Publish File activity to your script to publish the Excel file to Intelligence Central.
Dimensional Viewer
-This release includes several new enhancements to the Dimensional Viewer. You can now export all views to a file or location, publish data to Intelligence Central, and edit the underlying query.
•Export All Views to Excel or Local Storage. You can now export all views (containers). Multiple views can be exported to multiple worksheets in an Excel file or to multiple tables in Local Storage.
•To export to Excel, click Export All in the Wizard bar.
•To save to Local Storage, click Local Storage in the Wizard bar.
•Publish Data to Toad Intelligence Central. You can now publish view data to Intelligence Central as a dataset. Publish either a single view or publish multiple (or all) views. Each view is published as an individual dataset.
•To publish a single view, right-click within the view and select Send To | Publish Container.
Connections
-ODBC Connections - Enable Disk Caching to Improve Performance
•For ODBC connections, you can now instruct Toad to cache object metadata and retain it between Toad sessions. Using this option can improve performance in future requests.
Automation
Dimensional View Activity
-This release includes a new Automation activity for exporting data from a Dimensional View. This new activity allows you to open an existing Dimensional View file, execute the query, and export the data to Excel, Local Storage, or Intelligence Central.
*******
Additional information relating to the new features in version 4.2 can be found in the Toad Data Point 4.2 Release Notes or in the 'New in this
release' subtopic in the 'Welcome to Toad' Chapter of the Help. (includes instructions and screenshots)