|
Data Explorer
View data from Access, Excel, Oracle and/or SQL Server with a rich set of data tools: data tree navigation; filter and sort;
search data using regular expressions; calculate and format data; examine table and column metadata; copy and export data; and more…
|
|
Compare Data
Compare two tables or versions of data. The data can be from different sources and database types.
You can compare columns with different names and data types. Use column formats and expressions to condition
data before comparing. Data can be filtered before comparing. Select one or more columns as the unique row keys.
Results show rows that are equal, unequal or are only in one source. Unequal rows are stacked and highlighted to
show differences.
|
|
Data Navigator
The data navigator lets you explore database tables, views and metadata. Examine column data such as distinct values,
counts and totals. By continuously drilling by column and value, you can quickly filter data based on content.
|
|
SQL Editor
The SQL Editor lets you query data and perform DBMS commands for managing data. You can insert and update data as well as create, alter and
drop tables and views. Query results are displayed for viewing and can be used to compare.
|
|
Search
Perform comprehensive data searches using regular expressions. Search on a specific column or the entire table.
Options include the ability to mark (highlight) search results and filter it. Other options are Find Next, Match Case,
Match Whole Word and Wrap Search to Top.
Regular expressions provide a concise and flexible way to specify text search criteria. For example, gr[ae]y will
find both spellings of the word gray. Refer to online sources for information on how to specify regular expressions.
|
|
Filter and Sort
The filter and sort features let you organize data through simple menu commands.
|
|
Column Formats
Column formats alter how data is displayed on the screen without changing the data in source.
This is especially useful when data needs conditioning before comparing or exporting. You can format dates, numbers or text.
|
|
Expressions
Expressions create virtual in-memory columns using the result of an expression applied to other existing columns.
This lets you alter the form of the data without changing the table or view. You can express and/or combine data in a way
that the physical columns do not natively provide. For example, you can multiply the price of an item times its quantity
to get a total price. You can append units of measure to a number to express it more meaningfully. You can concatenate
multiple columns together into one. You can perform If..Then..Else logic to return values based on a Boolean expression.
|
|
Copy Data
Copy rows, columns or a range of cells. Four copy modes are available: data only,
with row headers, with column headers, or with both row and column headers. Hidden rows and columns are not copied.
You can also copy tree data to the clipboard.
|
|
Export Data
You can export data from the table panel to a file. There are four different export
file formats: Excel, Open XML (e.g., Excel 2007 – 2010), text and XML. A variety of data and format options are available.
|
|
Row Data
The Row Data feature transposes horizontal row data in the table panel to a vertical list for
easy viewing. The list is updated as you move from one row to another in the table panel. Blank values can be hidden to make
reading data even easier.
|
|
Column Metadata
The Column Metadata feature provides detailed information about column properties such as
data type, size and position. It also contains table view column property information – some of which can be modified
(namely – caption, font type, font size and format). The property information is updated as you move from one column to
another in the table view.
|
|
Data Status Bar
The Data Status Bar provides information about data in the table view. The information
includes a brief summary of any applied filters, the current column, the current row number, the number of filtered rows,
and the total number of rows in the table.
|
|
Customize Display
You can customize the data display by moving and hiding columns; freezing rows and columns;
and resizing rows and columns. These changes are automatically saved (except row sizes) in the table layout and reused the
next time you open the table for viewing. (Layouts also include column formats and properties.)
|
|
Options
Use Options to change the application look and feel, the behavior of the Data Explorer
and default options for Compare.
|
