Toad Data Point 6.2.3

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Advanced Analytics

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

In the Connection or Navigation Manager, open a Local Storage connection.
From the main menu select View | Code Snippets to open the Code Snippets window.
Expand the SQL (Local Storage) node to reveal the Advanced Analytics folder. Open the folder and select from the Advanced Analytics functions.
Double-click a function or drag it to an Editor window to use the function in a SQL statement. See Insert Code Snippets for more information.

Advanced Analytics Functions

See Advanced Analytics Functions for detailed descriptions of the functions, including syntax and code examples.

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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Point 6.2.3 - User Guide

Advanced Analytics