Frequently Asked Questions

Q. We are starting a data warehousing project, but we don't believe we need a tool like this. Why would we need it?

A. You don't need EZ Data Dictionary® to build your warehouse, but you will probably find that your systems and business users would like to look at your product before you finalize the design. After each major revision of your database, EZ Data Dictionary® provides an easy way to convey to users the value of the changes. This tool will help them to understand your data structures, to find the information they need, and it can allow them to add their own notes and keywords to make using your warehouse even easier to use as time goes on.

Q. I use a product like Erwin® (a copyright of Computer Associates International, Inc.®), why would I need EZ Data Dictionary®?

A. Most of our clients already use Erwin® and find that often it does not reflect the current reality of the production database, because changes were made to their original design. EZ Data Dictionary® does not replace Erwin® but provides a friendly, easy-to-use interface for adding definitions and distributing information about the different versions (i.e. Production, QA, Development, etc.) of the database. With EZ Data Dictionary®, the users have a way to access information without having the ability to change any of the data structures. Most DBA's prefer EZ Data Dictionary® over Data Modeling tools like Erwin® as an end user tool.

Q. Are there administrative functions that allow a person to set up definitions, user notes and keywords? Are casual users prevented from being able to use these functions?

A. Yes to all of these questions! EZ Data Dictionary® provides a sign-on facility with multi-level user authorities. With the proper authorization, users can add their own notes, assign searchable keywords to make finding data easy, and add or modify column (attribute) definitions.

Q. We have many databases that are already built, and are being used. Is there function in the product to populate the table names and field names automatically?

A. Yes! EZ Data Dictionary® can do this for databases built in Microsoft SQL Server®, Oracle®, UDB® for windows (by IBM®), Microsoft Access®, Sybase®, Pervasive® and others. The Administration function will automatically populate information about table names, column (attribute) names, column (attribute) types (numeric, character, etc.), column (attribute) sizes, etc. Even with only this basic information, users will find EZ Data Dictionary to be useful, because it allows viewing of the data structures and easy browsing of the data. The primary user task is to populate the attribute definitions, which will greatly enhance the understanding and resultant value of your databases. If the definitions are available from a data source like Microsoft Excel® or Microsoft Access® they can be automatically loaded into the EZ Data Dictionary®.

Q. Is there a reporting capability to generate documentation?

A. Since all the data is in the ODBC compliant database, it is easy to use any of your standard query and reporting tools (such as Crystal Reports®, Business Objects®, Impromptu®, etc) to create reports about the data. A sample report in Microsoft Access® is provided and can be a great starting point that is easy to modify. You can create queries against the EZ Data Dictionary® Database, which has friendly table names and column names.

Q. We have a conversion project coming up. How would this tool apply to such a project?

A. We encourage you to watch our video on conversions. It shows how we can use our Extract, Transformation and Load (ETL) utility programs to actually move the data after you describe the interface in EZ Data Dictionary®.

Video Demo