Applications > EZDD Database Reporting

 

This section will cover some basic information useful for doing any kind of reporting off of the EZDD Database. This includes an outline of the structure of the database, the information included in each table, and directions for doing ad-hoc reporting off the database.

 

Structure of Database

The structure of the EZDD database is fairly straightforward and easy to understand, with table and column names clearly describing the contained information. There are two main types of information being stored in the EZDD database, the metadata for the included databases, and the interface information that maps data between databases that can be used by the EZETL tools or to define reports.

Key fields tie the various tables to each other based mainly on the Database Number, which directly references a particular included database. The main tables in the database are described below.

 

The Entity Relationship Diagram of the full database is shown below.

 

Visio ERD of Database

 

 

Ad Hoc Reporting

Many times it is helpful to create an ad-hoc report from the metadata in the EZDD database. Doing this can provide information about an included database in a form that is easily understood and stored as documentation. It's easy to create an ad-hoc report on any database included in the EZDD Database by using any SQL reporting tool, such as Crystal Reports, Business Objects, Impromptu, etc..

In the following example, Microsoft Access will be used, simply because it is readily available to everyone, and there is already a sample in the default EZDD database in Microsoft Access.

First open the EZDD Database using Microsoft Access. This database is found in the Databases directory of the EZDD installed location, by default C:\EZDD\Rel2010\Databases\EZDataDictionary_2010.mdb. This location will be different if for EZ Data Dictionary® is installed at a different location.

Open the query "EZDD_Tables_and_Columns", and this screen will display:

 

To execute this query, answer the prompted questions as indicated: Database: 2, Table: Customers. When the query completes, the following results will appear:

 

This query can be modified to appear however is desired by using the Design mode of Microsoft Access. And in a similar way, additional queries can be written against any of the metadata in the EZDD database to produce informational reports or documentation about any included database.