Pervasive DataTools - Data Inspectors

The Pervasive Data Inspectors are the DataTools to use when you need to understand the contents of a database table, an application entity, or a data file.

Data quality is vital to the operation of any business. The Pervasive Data Inspectors are the perfect way for a data analyst to ensure that business applications contain consistent, clean, valid, and accurate data. When you need to identify data inaccuracies such as missing values, null values, data errors, and other types of invalid data, you need a Pervasive Data Inspector.

Using the Data Inspector, you can learn useful information about your data, such as finding:

  • Distinct values - a complete frequency distribution on every column!
  • Percentage of specific entries
  • Exceptions in your data
  • Inaccurate data
  • Dirty data
  • Missing values
  • Null values
  • Data that requires cleansing and transformation

The Data Inspectors are easy to use. Simply connect to your database table, application entity, or data file, select the records and fields to analyze, and click "Run". The Data Inspector will analyze the data and return the results in both a tabular and a graphical format.



Applications | SQL Databases | File Formats



Applications

A Pervasive Data Inspector is available for each of the following applications:

SQL Databases

A Pervasive Data Inspector is available for each of the following SQL databases:

File Formats

A Pervasive Data Inspector is available for each of the following file formats: