Table and View Data Browser and Editor

DataTool is included in the following subscription product

DataGEM DataTool allows you to browse and edit data within your ODBC 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 DataGEM tools to have the data for that object automatically displayed!

DataTool Screenshots

Click on an image below to expand.


Table Browse


Where Clause Filter

DataTool Edit Mode

Edit Mode

DataTool Features

Some of the key features within DataGEM DataTool

Fast and Simple Data Display and Editing
Database 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 and export features also provided.
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 file or clipboard. Delimited and Excel formats supported.
Tool-to-Tool Integration
QueryTool can bring up DataTool with a click of the button.
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.
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 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.
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.
Easily apply bulk changes by using this handy feature.