Datatific Review - View and Compare Data

"Datatific Review saves time and money."
Datatific Review

Datatific Review is a data application used to view and compare data in Access, Excel, MySQL, Oracle, SQL Server, ODBC, OLEDB and text data. It is visually appealing, easy to use and rich with features.

  • Compare two tables or versions of data
  • Explore data quickly and easily
  • Dynamically discover data in a tree control
  • Perform queries and DBMS commands
  • Search data across columns
  • Examine database metadata

Whether you are browsing data, searching for a needle in a haystack or comparing data for differences, Datatific Review will save you time. Try it for free!

Buy now
Try for free
Introduction Video
Screenshots
Screenshots
Buy now
Try for free
Watch in Action
Screenshots
Learn

Preview Datatific Review in Action

New: Watch Estimating demo!

What Can You Do With Datatific Review?

Datatific Review Open multiple databases and database types View and compare data in Access, Excel, MySQL, Oracle, SQL Server, ODBC, OLEDB and text data.
Datatific Review View data quickly and easily using innovative data tree "Walk" the database by drilling through tables, columns and values. You decide where to start and how to navigate. Very powerful! Tutorial Video
Datatific Review Compare two versions of a database table or spreadsheet See what records have been added, changed, and/or deleted. Differences are highlighted for easy viewing. Tutorial Video
Datatific Review Perform estimates The innovative data tree lets you dynamically examine data to make estimating a breeze. You can also compare estimates. Video
Datatific Review Compare dissimilar data Map columns to compare. Columns can have different names and data types. Differences are highlighted for easy viewing. Tutorial Video
Datatific Review Search data and highlight results Search, mark and filter data using regular expressions. Tutorial
Datatific Review Execute SQL queries and commands Perform queries for viewing and DBMS commands for managing data. You can insert and update data as well as create, alter and drop tables and views.
Datatific Review Copy data Quickly copy data from the spreadsheet-like grid and paste in the application of your choice.
Datatific Review Export data Export data to a variety of formats.
Datatific Review Compare database structure Compare table and column definitions. Differences are highlighted for easy viewing.
Datatific Review Much more... Datatific Review is rich with features and open to a variety of possibilities.

Features

Data Explorer
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 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
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
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
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
Filter and Sort

The filter and sort features let you organize data through simple menu commands.

Column Formats
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

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 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
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
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
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
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
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
Options

Use Options to change the application look and feel, the behavior of the Data Explorer and default options for Compare.