DataProfiler™ provides a quick and easy way to perform an assessment of the business-relevance of data when preparing for the migration of data from one or more legacy systems to SAP®. The goal of data profiling is to save hours of research effort by enabling business teams to establish immediate profiling of legacy and SAP data sources. Unused tables and fields are indicated, and the DataProfiler provides quick and automated processes for identifying key data quality metrics early in the migration process. It is very important to understand that data profiling does not replace viewing and analyzing data, but is considered a value-added activity for Data Audits and can provide useful information at the beginning of a Data Migration Project.

Features:

• Lists all tables and the corresponding number of records
• Lists all fields within a table as well as the corresponding data types, data size and data scale
• Provides the minimum value, maximum value and number of blanks per column
• Stores the name and frequency of the first 5,000 unique values
• Includes a series of predefined reports by database, table, or field analysis to download to excel spreadsheets
• Supports Unicode

Benefits:

• Performs an accelerated, automated “data audit”
• It will "let the data speak for itself™"
• Identifies irrelevant data for exclusion from your data migration
• Built on the easy-to-use CranSoft® technology platform

To learn more about our products, contact us.