Installation > EZDD Database Implementation

 

This section describes the basis information for implementing the EZDD Database, including the default configuration, how to configure the EZDD.txt file and how to change the EZDD database.

 

Default Configuration

By default the EZ Data Dictionary® application will install to the C:\EZDD directory. This location may be changed by specifying a different directory during the installation process. The installed directory will contain the following five subdirectories: ASCII, Databases, Documents, Logfiles, and Programs.

In the default installation there will be no files in the ASCII and Logfiles folders. The Logfiles folder will be discussed in the Common Tasks section of this Quick Start Guide. The ASCII folder contains files when used in advanced applications addressed in the User Manual.

The Databases folder contains all the information necessary for EZ Data Dictionary® to access the three databases included in the default installation. The Programs folder includes all the files necessary to run the application.

 

Configure EZDD.txt File

When the EZ Data Dictionary® application is run, basic configuration information required by the program is supplied from the EZDD.txt file. By default this file is provided by the installation module and is located in the Programs folder of the EZDD directory. The default file will point to the various required locations as defined by the installation module and these values only need to be changed if the configuration is being modified.

Each line of the configuration file consists of a keyword recognizable to the application on the left side of the equals sign which must be maintained exactly as shown. The applicable value is assigned on the right side of the equals sign, and can be changed by the user as necessary. The information included is the location of the EZDD.txt file itself, the owner of the EZDD database, the default password for the EZDD database, the connect string to the default location of the EZDD database, the DBMS for the EZDD database, the location of the logfile, the user code, the “source records to retrieve” and the version of the software. Typically the most common line that might be changed is the EZDD_CONNECT_STRING, changed when a different EZDD database is to be used. See the documentation on EZDD_Inquiry/Table_Details for the application of the “source records to retrieve”.

This is the default EZDD.txt file:

 

EZDD.txt file=C:\EZDD\Programs\EZDD.txt
EZDD_DATABASE_OWNER=ADMIN
EZDD_DEFAULT_PASSWORD=admin
EZDD_CONNECT_STRING=Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\EZDD\Databases\EZDataDictionary_2010.mdb; Persist Security Info=False
EZDD_DBMS=ACCESS
EZDD_LOGFILES_LOCATION=C:\EZDD\Logfiles\
EZDD_USER_CODE=EZDD
SOURCE_RECORDS_TO_RETRIEVE=200
VERSION=PRODUCTION

 

Changing EZDD Database

It is entirely possible to have multiple versions of the EZDD database, whether for different departments, different applications or to include different sets of databases. Each installation will have a different EZDD.txt that specifies the location of that specific EZDD database on the line EZDD_CONNECT_STRING. The parameters of the EZDD.txt file and the EZDD_LOGFILES_LOCATION would also be different to point to the specific folder for this EZDD Database.

For example, maybe the Investment Department has its own version of the EZDD Database that does not include some technical databases that are in the IT department version. The Investment Department has their EZDD Database located in their own directory, with an EZDD.txt file that might look something like this:

EZDD.txt file=C:\INVESTMENTS\EZDD\Programs\EZDD.txt
EZDD_DATABASE_OWNER=ADMIN
EZDD_DEFAULT_PASSWORD=admin
EZDD_CONNECT_STRING=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\INVESTMENTS\EZDD\Databases\EZDataDictionary_2010.mdb;Persist Security Info=False
EZDD_DBMS=ACCESS
EZDD_LOGFILES_LOCATION=C:\INVESTMENTS\EZDD\Logfiles\
EZDD_USER_CODE=EZDD
SOURCE_RECORDS_TO_RETRIEVE=200
VERSION=PRODUCTION

For any execution of EZ Data Dictionary®, the EZDD_CONNECT_STRING line in the EZDD.txt can be changed to specify the appropriate EZDD Database. See the documentation on EZDD_Admin/ Main Screen/Change_Connnect_String_for_a_Database for a description of the ability to change the EZDD Database while within that application module.

 

Implementing EZDD Database

The EZDD Database can be easily be implemented in any DBMS desired. This section will describe a few of the most common DBMS installations.

 

Access

By default the EZDD Database is installed using Microsoft Access® and if this is the desired DBMS for the database then nothing else needs to be done.

 

SQL Server

Although by default the EZDD Database is installed using Microsoft Access as the DBMS, this database can easily be installed and maintained in SQL Server. The steps to do this would be performed by a SQL Server DBA and are outlined in detail on the following page: Implementing the EZDD Database in SQL Server.

 

Oracle

Although by default the EZDD Database is installed using Microsoft Access as the DBMS, this database can easily be installed and maintained in Oracle. The steps to do this would be performed by an Oracle DBA and are outlined in detail on the following page: Implementing the EZDD Database in Oracle.

 

Other DBMS

Although by default the EZDD Database is installed using Microsoft Access as the DBMS, this database can easily be installed and maintained in nearly any other DBMS with steps similar to those in the above sections. For more help installing the EZDD Database in another DBMS please contact ICC directly.