DataGEM
DataGEM Desktop Tools enable You to browse, query, analyze, copy, compare, export and visualize Information from ODBC databases. Save commonly used queries, results, charts, exports and comparisons for reuse and scheduling later to save time and increase productivity.

Tools

DataGEM contains the following tools. Click on a tool to get additional information.

Data Visualization Development

Active Script Job and Chart Scheduling on your Desktop!

SQL Query Development

Table and View Data Comparison

Table and View Data Import

Table and View Data Browser and Editor

Active Script Job and Run Management

Features

Innovations, technology, components and design elements that truly make DataGEM a leader in database analytics.

Feature
Table and View Data Comparison
Compare data in tables and views with ease and display easy to read results that can be saved to Excel for testing and auditing purposes. Automatically generate a sync script to bring the comparison table in sync with the reference. Even perform these comparisons across servers quickly and easily.
Feature
Unparalleled Flexibility and Productivity
Achieved through simultaneous connections to multiple tools, servers and databases.
Feature
“Easy as Pie (Chart)!” Visualization Development
3 step wizard walks you through transforming query results into powerful and insightful visualizations.
Feature
SQL Formatting
Consistent, customizable formatting that can instantly beautify the ugliest SQL mess.
Feature
DataGEM Active Script Job and Run Management
DataGEM Active Script jobs and runs are easily managed within this point and click GUI. Just a few clicks is all it takes to browse, open, review, edit and execute previously created Active Script jobs and runs.
Feature
Tool-based Design
The DataGEM tool-based graphical user interface is designed to help guide users to the specific tool for a specific task or set of tasks common to warehouse query and analytics. In doing so, it helps to support and promote a multi-tasking, more productive and collaborative work environment. Many experienced professionals have adopted it as their must have in working with database analytics on a day to day basis.
Feature
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.
Feature
Tool-to-Tool Integration
The DataGEM environment is designed to help get you to the right tool for the job by providing toolbar buttons that enable context aware loading of information from one tool to another.
Feature
Multi-Threaded Architecture
Compare tables on one server while executing SQL against another with this feature and take your productivity to another level.
Feature
Advanced SQL Query Development Environment
A complete, very sophisticated SQL editor with advanced editing features like colored syntax highlighting, formatting, line numbers, bookmarks, automatic outlining and more.
Feature
SQL Helper
Common object and attribute information browsing with drag-n-drop instant SQL command generation.
Feature
Data Browser
Quickly browse selected table and view information with this handy feature.
Feature
Schedule Desktop Active Script Jobs and Charts
Quickly schedule and define execution parameters for Active Script Jobs and Charts by using Desktop Scheduler’s Schedule Job dialog within JobTool and ChartTool.
Feature
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
User Customizable Connection Navigator
Take advantage of this unique feature to create and save connection information utilizing inheritable folder properties that make it a snap to copy and modify almost any aspect of a database connection.