Analyzer for Big Data 161026

Rating: No reviews yet
Downloads: 686
Released: Oct 23, 2016
Updated: Oct 27, 2016 by strive4peace
Dev status: Stable Help Icon

Recommended Download

Application Analyzer_161026_BigData_s4p.zip
application, 3228K, uploaded Oct 27, 2016 - 686 downloads

Release Notes

This version of the Analyzer is specifically designed to help analyze big data, like databases that have links to SQL Server tables. Controls that show the number of records, and maximum size of values, are wider

Additionally, reports have been added to help find things that need to be corrected.

New Reports:
  • Fields in >1 Table
  • Fields With Captions
  • Fields With DefaultValue =0
  • Foreign Key Fields
  • Percent Unique Values in Fields
  • Required Fields
  • Unique Indexes

It is a good idea to keep a blank copy of the Analyzer and make a copy of for analyzing a group of databases that are related.

New Combined Reports for all databases analyzed:
  • All Deep Analysis
  • All Fields
  • All Fields in >1 Table
  • All Percent Unique Values in Fields
  • All Table Summary

There are more statistics including the number of tables with the same field name.

There is more criteria for reports including being able to specify = or <> for many options including wildcard searches.

To document your SQL Server databases:
  1. create an Access database with links to your SQL Server tables
  2. be sure to save the username and password in the connect string -- it can be read-only (after the Analyzer is done, you can delete the Access database if desired)
  3. Close the database with links.
  4. Download the free Analyzer for Microsoft Access https://analyzer.codeplex.com/
  5. Open the Analyzer
  6. Browse to the Access database with linked tables
  7. Run the Analyzer (It takes awhile to run if you have a lot of data and choose the Value Analysis test. While running, you will see "Not Responding". This is normal and nothing to be concerned about.)
  8. Look at reports

You will see reports for tables and how many records they each have. The Deep Analysis report gives you a data dictionary (names, data types, sizes) and a value analysis for each field: maximum, minimum, and other statistics; most characters used; how many values are filled; etc. The indexes report shows all indexes that are defined, what type of index they are (ie: Unique), and what fields are in the index.

The Analyzer has more than 50 defined reports. You can also make your own queries and reports, export to Excel, save as PDF, and do whatever else you want!

To save a report as a PDF file:
  1. right click on a report when you are looking at it in Print Preview
  2. choose Export > PDF
  3. Browse to (or paste path) where you want to put the file

Reviews for this release

No reviews yet for this release.