Image

DataTool

Teradata and ODBC Table and View Data Browser and Editor

Available in

AtanaSuite DataTool allows you to browse and edit data within your Teradata database. View, insert, update and delete rows directly in the spreadsheet like table without writing any SQL!

DataTool makes browsing and editing data so simple that you don't even need to know SQL!

Edit data without writing a single SQL statement!

An easy to use graphical interface lets you view, filter, sort, modify, and delete records quickly and efficiently - without writing a single line of SQL!

Editing data has never been so easy! Insert a new row, delete a row or update existing data with just a few clicks of the mouse! Absolutely no need to write any SQL! Just edit the data as you see it on the screen!

Convenient tool-to-tool integration makes viewing data from database objects simple! Just click on the DataTool icon in other AtanaSuite tools to have the data for that object automatically displayed!

Tool Screenshots

Screenshots of DataTool in action.

Key Features

Some of the key features found in DataTool.

DataTool Screenshots

Click on an image below to expand.

Image

Browse

Image

Where Clause Filter

Image

Find Dialog

DataTool Features

Some of the key features within DataTool.

Fast and Simple Data Display and Editing
Teradata table and view data display using a familiar, spreadsheet-like document interface that supports multiple document browsing and editing. Quickly retrieve and edit table data with ease. Advanced filter, edit, locking and export features also provided.
User customizable Database Display
Tree, list and favorites tabs available to suit any user or corporate installation.
Spreadsheet Interface
Easiest way to browse or edit table and view data.
Column Filter
Easily select the columns loaded for viewing or editing.
Multiple Data Export Formats
Quickly save information to Delimited, Excel, FastLoad, Text, Vartext and even as Insert statements. Did we mention - it can even create a FastLoad script in the process.
User Defined Data Save Locking
Complete control over the locks that are established for saving edited information.
Collapsible Table/View Selection List
Collapse the table/view selection area for optimum viewing or editing.
Table and View Data Browser
View only mode for quickly accessing your important information.
Data Filter
Only see the information you need by specifying a data filter.
FastLoad Script Wizard
Fill in the blanks to create a complete FastLoad script for a selected table.
Insert/Delete Rows
Insert or delete rows of data by just clicking on this toolbar button.
Color-coded Edit Tracking
Edits highlighted to help visually identify and track changes.
Edit Summary Dialog
Summary display of changes applied to database table.
Edit Confirmation Dialog
Confirm changes prior to applying them to your table.
No Teradata SQL Knowledge Required
Throw away the manuals! Point, click, edit and save - it does not get any easier than this.
Table Data Editor
Intuitive data editing without the hassle of writing complex insert, update or delete statements.
Data Column Filter
Provides additional data viewing control for loaded information.
User Defined Data Load Locking
Complete control over the locks that are established for loading information.
Row Reset
Select a row and press this button to have the selected row edits replaced with the original information.
Edit Reset
Click to reset and all changes are thrown away and the originally loaded data is restored.
Find/Replace
Easily apply bulk changes by using this handy feature.
Tool-to-Tool Integration
SchemaTool, QueryTool and SearchTool can bring up DataTool with a click of the button.

© 2002-2024 Atanasoft LLC.