The Pick a Source Dialog
If you use Tools | tool name to open one of the tools listed below, Toad opens the Pick a Source ... dialog. This dialog allows you to select a source for data and then send the data to the selected tool.
This dialog is useful if you would like to first select the tool to use and then select a connection and data. New users may prefer this method as it presents all the available options for selecting data.
In addition to using the Pick a Source ... dialog, you can also send data directly to the tool from the Object Explorer or a data grid. Both of these workflows are enabled for the following modules.
- Transform and Cleanse Data
- Data Profiling
- Visualize Data
- Dimensional Viewer
- Publish to Toad Intelligence Central
Note: Publishing to Intelligence Central is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
To use the Pick a Source ... dialog
- Open the desired tool using the Tools menu.
- Tools | Transform and Cleanse
- Tools | Profile
- Tools | Dimensional
- Tools | Visualization
- Click the Publish button in the main toolbar
-
In the Pick a Source dialog, select a source from among the following tabs:
Note: The list of options presented in this dialog varies depending on the selected tool.
- Current Window—Select to use the data in the current window. This option is only available if the current window contains a data grid, result set , or query, with an associated connection (for example, the Query Builder, SQL Editor, or Viewer).
- Data Object—Select to use a database object. Select a connection first and then select an object.
-
Library—Select to use an existing Toad document in your Library to define the data to use.
- Publish to Intelligence Central—If you initially clicked the Publish toolbar button, you can publish data or a file. Select Publish Data to use the document to define the data. Select Publish File to publish the file itself.
- Query—Select to enter a query. Click
to import a query from a file. Click
to preview data.
- Options—(Transform and Cleanse or Profiling only) Click the Options link to specify options for this transform and cleanse or profiling session. See Profiling Options or Transform and Cleanse Options for more information.
- Profiling Columns—(Profiling only) Click the Profiling Columns link to select the columns to profile. Profiling Options
-
After selecting the source for your data, see one of the following for additional instructions based on the selected tool: