Toad Data Point 6.2 - User Guide

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

Profiling Options

Use this page of the Options dialog to specify default values to use with the Data Profiling tool. The settings you specify here apply to new Data Profiling sessions. You can override these settings at the session level. See Profiling Options for more information about session-level data profiling options.

To specify Profiling options

Select Tools | Options | Environment | Profiling.
Specify options to use in new Data Profiling sessions. Review the following for additional information:
- Basic Analysis—Always selected.
- Distinct Analysis—Processes distinct, duplicates, non-unique, unique, and repeated rows.
- Pattern and String Analysis—Pattern analysis of string values.
- Domain Analysis—Identifies a matching domain and domain patterns.
- Enable Drill-Down of Actual Values—Select this option to display the sampled data.
  - If this option is not selected, the All Data and Selected tabs do not display.
  - Deselect this option to reduce the file size of the Toad Profiling Report.

Tips:

To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).
To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.

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 - User Guide

Profiling Options