JoinTool

JoinTool

Table and View Join Development Environment

JoinTool is included in the following products


JoinTool's intuitive user interface walks you through creating a join. Execute or explain as you build the join so that you can validate and evaluate the results. Use AtanaSuite Expression Helper to aid in the construction of join on and other clause expressions.

Easily create complex joins within JoinTool!

Using JoinTool is fast, easy and fun - build multiple table or view join queries in a matter of seconds. Right mouse click in the join on condition, where clause or other clause edit areas to use AtanaSuite Expression Helper to quickly put together expressions for the tables or views selected. Click a button to save as an AtanaSuite Active Script job, or test and evaluate the join using explain and visual explain.

Reduce time spent building and testing join queries. Forget about trying to remember the exact syntax needed for putting together join conditions. Let JoinTool with Expression Helper speed join query building and testing for you today.

JoinTool Screenshots

Click on an image below to expand.

JoinTool

Design

JoinTool Explain

Explain

JoinTool Results

Results

JoinTool Features

Some of the key features within AtanaSuite JoinTool

Feature
Integrated Join Development Environment
Easily develop complex Teradata table and view joins using a simple point and click GUI tailored specifically for this task. Execute explains and test runs as you work to verify complicated logic.
Feature
Results Grouping
Easily view results by dynamically grouping the columns.
Feature
Drag-n-drop Column Ordering
Easily re-order selected values and even add casting options.
Feature
AtanaSuite Expression Helper
Simple point and click to develop on clause and related syntax.
Feature
Results Export
Save results to Excel for use elsewhere.
Feature
Results Column Filter
Refine your results display by specifying column filters.
Feature
Preview SQL
See the join as it is being created and click to send to QueryTool or save to clipboard.
Feature
Tool-to-Tool Integration
Just a click sends the join to QueryTool for additional analysis and editing.
Feature
Alias Support
Select a table or view and specify an alias to have it applied within the join.