- 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?
- 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?
- We are starting a data warehousing project, but we don't believe we need a tool like this. Why would we need it?
- I use a product like Erwin® (a copyright of Computer Associates International, Inc.®), why would I need EZ Data Dictionary®?
- We have a conversion project coming up. How would this tool apply to such a project?
- How do I set up the information for a Report Template?
- How do I set up the information for an EZETL program?
- Are there any videos that I can watch?
- How do I get more help?
Are there administrative functions that allow a person to set up definitions, user notes and
Are casual users prevented from being able to use these functions?
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.
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?
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®.
We are starting a data warehousing project, but we don't believe we need a tool like this.
Why would we need it?
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.
I use a product like Erwin® (a copyright of Computer Associates International, Inc.®),
why would I need EZ Data Dictionary®?
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.
We encourage you to watch our video on conversions. It shows how we can use our Easy to Use Extract, Transformation and Load (EZETL) utility programs to actually move the data after you describe the interface in EZ Data Dictionary®.
First create a new interface, and make the source database your desired database (such as Northwind), and the target database as the EZDD database. Set the table name as REPORT_TEMPLATE from the EZDD database using this screen:
Once these values are assigned correctly, clicking on the Create button will direct the user to the Interface Columns Maintenance screen where the columns can be mapped from the fields in the database to the columns in the report.
The most common use of the interfaces capability is to map an interface from one database to another. In this example, an interface is created to map data from the customers table in the Northwind database in Access to the customers table in Northwind's SQL Server database:
Once this Interface is defined, the Interface Columns Maintenance screen is used to map each of the columns from the old customers table to the new customers table.
Yes, the following videos are available on www.ezdatadictionary.com:
The EZ Data Dictionary® Inquiry Module
The EZ Data Dictionary® Admin Module
The EZ Data Dictionary® Conversion Video (using EZDD and EZETL for a conversion)
If you have additional questions please contact ICC:
Call us toll free: 877-436-1919.
Or e-mail us at firstname.lastname@example.org
Investment Conversions & Consulting, Inc.®
8920 Wood Rose Loop,
Portland, Oregon 97229-7518