Toad's Advanced Analytics feature allows you to perform advanced, in-database analysis of your data using a repository of sophisticated functions to perform predictive modeling and data mining. These Fuzzy Logix functions are part of the embedded Local Storage database. To use these functions, you must first copy the data to the Local Storage database.
Note: This feature is only available in the Toad Data Point Professional Edition with Analytics.
To use Advanced Analytics
You must first copy to Local Storage all data on which you want to use Advanced Analytics. See Save Data to Local Storage for more information.
If you are not already connected, connect to the database in Local Storage where your data is stored.
Use the Editor or the Query Builder to compose or build statements using the Advanced Analytics functions. These functions are available through code completion in the Editor or when building a Where condition or calculated column in the Query Builder (with a Local Storage connection).
To access Advanced Analytics through the Code Snippets window
Advanced Analytics Functions
Tip: You can double-click an Advanced Analytics function in the Code Snippets window to add the function to an active open Editor window. If the active window isn't an Editor window, this action opens a new Editor window containing the function.