Jet Profiler
Jet Profiler is a real-time performance and diagnostic tool for ... with high activity, and identify possible bottlenecks. The profiler collects server activity without requiring changes to the ...

Datamartist is a visual desktop tool for data profiling and ETL. Its drag-and-drop workspace helps users build transformation workflows, define categories and hierarchies, create calculated columns, and apply rules to segment records. It can process large datasets, map duplicates to designated master records, and combine reference data with source information. Imports include SQL Server, ODBC, Access and delimited text; results can be exported to Excel.
| Author: | nModal Solutions Inc. |
| License: | Trialware |
| Price: | $349.00 |
| Released: | Jan 30, 2015 |
| File size: | 7.00 MB |
| Downloads: | 371 |
| Keywords: | data profiler, data deduplication, data profiling software, data mart creation, profiler, ETL tool, data transformation, visual data profiling, transformation, data management, nModal Solutions Inc., etl software, visual data modeling, management, data transformation tool, Datamartist, data categorization |
| Author URL: | http://www.datamartist.com/ |
Datamartist is a visual data profiling and ETL application for analysts and data managers who need to inspect, reshape and prepare information for analysis. Its desktop workspace represents transformation steps graphically, so users can build and manage a data workflow by arranging operations rather than writing every step as code. It is intended for work that takes data from source files or databases through cleanup and categorization to analysis-ready output.
The drag-and-drop environment supports multiple transformation paths. Users can define hierarchies to drill into data, add categories, and revise labels and names to suit the way information should be explored. Rules divide records into meaningful segments, while the calculation engine creates new columns and applies conditions. These tools help turn raw fields into structured values that can be examined or summarized according to a project's needs.
For record cleanup, Datamartist can identify duplicate entries by letting users designate master records and map duplicates to them. It can also combine reference data with source records to build data marts. The application handles large datasets, including millions of rows, and can summarize them into smaller analysis sets. This makes it possible to retain detailed source data during processing while producing more manageable results for downstream review.
Data can be imported from SQL Server, ODBC connections, Microsoft Access databases and delimited text files. Users can export results to Excel at different points in a workflow, which is useful for further analysis or for continuing a transformation outside the application. Exporting intermediate results also gives teams a way to inspect prepared data before completing later processing steps.
Datamartist is trialware. Its workflow is suited to profiling, categorizing, deduplicating and preparing business data from supported database and file sources. The supplied platform information covers older Windows releases, so compatibility with current Windows systems should be checked before installation. The application's focus is visual data preparation rather than general-purpose spreadsheet editing or database administration.