Datatific Review 1.5.0
Features 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.
(12MB, Extension: EXE)
Download alternate to Datatific Review solution
Look at the free or trial alternatives and similar apps to Datatific Review software by the tags. It's possible also to find substitutes for the most popular titles in the Internet & Network category.
| View Data | Sql Editor | Database Comparison Tool | Compare Two Tables | Compare Two Database | Compare Sql Data Free | Compare Database Tables | Compare Database Schemas | Compare Database Free | Analyze Data |
History updates (Complete changelogs since the listing on this site)
- Added MySQL, ODBC and text data sources. Supported data source types include Access, Excel, MySQL, Oracle, ODBC, SQL Server and text data.
- Added 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.
- Simplified compare setup
- Allow comparing single column lists
- Improved data source setup
- Display data source information in tree root
- Various visual enhancements
- Improved performance with Oracle and SQL Server
- Fixed error with nulls in compare keys
Predicted future versions and notices:
The doDownload.com constantly monitors the update of all programs, including information from the Datatific Review 1.5.1 changelog file, however sometimes it can happen that data are not complete or are outdated.We assume that author continue's to develop 1.6.0 version with further advanced features, and soon you will be informed. Equally important 2.0.0 upgrades of the program we will continue to monitor. Full Datatific Review description has been compared with the overall software database and our algorithm has found the following applications (are showed below).