5.0 Installation Considerations
5.1 Installing API Components

Erwin Data Modeler 7.1 Free Download Windows 10

6.0 General Considerations
6.1 Template Files for Customizing Model Explorer Display
6.2 Performance When Converting 4.1.4 Models to r7 Format
6.3 Understanding Complete Compare Differences After Converting Your Models
6.4 AllFusion ERwin DM API and Changes in Metadata
6.5 XML Option Sets are Database-Specific
6.6 Published Fixes

7.0 Known Issues
7.1 Requirement for Connecting to SQL Server 2005
7.2 Reverse Engineering Oracle Materialized Views
7.3 Reverse Engineering Scripts With Reserved Words
7.4 Documentation Correction

Free erwin data modeler r7.3 Download - erwin data. Process Modeler 7 ERwin Data Modeler (: ERwin), Data Model Validator (: ERwin Examiner), Model. دانلود نرم افزار مدل سازی CA AllFusion ERwin Data Modeler, نرم افزار مدل سازی و طراحی پایگاه داده CA AllFusion ERwin Data Modeler.

1.0 Welcome

Welcome to AllFusion ERwin Data Modeler r7, a member of the AllFusion Modeling Suite. This file is cumulative and contains product installation considerations, operating system support, known issues, and information about contacting Computer Associates Customer Support.

2.0 Operating System Support

AllFusion ERwin Data Modeler (AllFusion ERwin DM) requires that you have one of the following operating systems installed:

• Microsoft Windows 2003 Server
• Microsoft Windows XP (Service Pack 2)
• Microsoft Windows 2000

3.0 System Requirements

The following requirements must be met or exceeded for AllFusion ERwin DM r7 to install and run correctly:

• 85 MB Hard Disk Space
• 512 MB RAM (1 GB recommended for large models)

4.0 Supported Target Server Databases

The following list of target server databases are supported in AllFusion ERwin Data Modeler r7.

Erwin Data Modeler 7.1 free. download full

• Access (2000/2002/2003)
• Advantage Ingres (2.5, 2.6, r3)
• DB2 iSeries (5.x)
• DB2/390 (7, 8)
• DB2/UDB (8.1/8.2)
• FoxPro (stabilized support)
• Informix (7.x, 9.2/9.3, 10)
• ODBC/Generic (2.0, 3.0)
• Oracle (8i, 9.x, 10.x)
• Progress (8.x, 9.x/10.x)
• Redbrick (stabilized support, 5.x)
• SAS (stabilized support)
• SQL Server (7.0, 2000/2005)
• Sybase (12.5)
• Teradata (2.x, v2R6)

5.0 Installation Considerations

5.1 Installing API Components

The AllFusion ERwin Data Modeler API and two related components (ERwin SPY, and the ERwin Sample API Client) are included in the installation when you choose the Complete Setup Type during setup. If you choose the Custom Setup Type during setup, you can choose to customize the install location, and review the space needed to install each feature.

6.0 General Considerations

6.1 Template Files for Customizing Model Explorer Display

Two new template files are provided with r7 that allow you to customize the display of object names in the Model Explorer. By using macros in the template file, you can override the default display of selected object names.

The file ModelExplorer logical display names.tmpl includes display options for the logical model. The file ModelExplorer physical display names.tmpl includes display options for the physical model. The files are installed to the default installation directory for the product (C:Program FilesCAAllFusion ERwin Data Modeler r7).

Comments and a sample macro are provided in the file to customize the display of the parent/child relationship phrase in the Model Explorer. By default, the display is formatted to include the elements <parent name> <relationship name> <child name>. You can modify the macro to exclude one of the elements, for example if you wanted to exclude the parent name in the display.

6.2 Performance When Converting 4.1.4 Models to r7 Format

You can work with ERwin data models from version 4.1.4 in r7. When you open a 4.1.4 model for the first time in r7, there is a one-time performance cost to convert the 4.1.4 model to the new r7 format. Testing has shown the one time performance cost ranges from 50%-1000%. Individual results may vary due to differences in models and hardware.

6.3 Understanding Complete Compare Differences After Converting Your Models

If you are working with ERwin 4.1.4, you can upgrade a model by opening and saving it in r7. You can also 'round-trip' your r7 model by saving it as a 4.1.4 model and opening it again in r7. You can use Complete Compare to compare the models as you work with them in version 4.1.4 and r7.

The technical document 'Understanding Complete Compare Differences After Converting Your Models' helps you understand differences you may encounter in Complete Compare when working with 4.1.4 and r7 models. You can find the document on http://supportconnect.ca.com in the Technical Document Index on the Product Home Page for AllFusion ERwin Data Modeler.

6.4 AllFusion ERwin DM API and Changes in Metadata

There are .csv files located in the Doc directory after you install AllFusion ERwin DM that describe the changes in metadata between Version 4.1.4 and r7. Specifically, these .csv files describe changes to object type names and property type names, and also lists new and replaced object and property types.

For more information, see the AllFusion ERwin DM API Reference Guide.

Ca Erwin Data Modeler Download

6.5 XML Option Sets are Database-Specific

In r7, a new feature allows you to create custom Option Sets for Forward- and Reverse Engineering, and to save the Option Set as an XML file. Because XML Option Sets are database-specific, you cannot use an XML Option Set created for one target server with a model using another target server. To avoid an error message when you change target servers and then Forward or Reverse Engineer, create a unique XML Option Set for each target server in your modeling environment.

6.6 Published Fixes

All published fixes for this product can be found through Published Solutions on SupportConnect.

7.0 Known Issues

7.1 Requirement for Connecting to SQL Server 2005

If you are trying to connect to SQL Server 2005 from a machine that does not have the SQL Server 2000 client installed, you will not be able to connect to SQL Server 2005 using AllFusion ERwin Data Modeler or AllFusion Model Manager. AllFusion ERwin Data Modeler and AllFusion Model Manager require the use of DB-Library for connecting to SQL Server databases. SQL Server 2005 no longer distributes the DB-Library files, though DB-Library is supported for connecting to SQL Server 2005.

In order to be able to connect to SQL Server 2005, the file NTWDBLIB.DLL needs to be installed on your workstation. If you have a SQL Server 2000 installation CD, the SQL Server 2000 client can be installed from the CD by executing sqlredis.exe located on in the x86Other folder. If you do not have a SQL Server 2000 installation CD, you will need to contact Microsoft support.

7.2 Reverse Engineering Oracle Materialized Views

A known Oracle bug (4464328) creates problems when reverse engineering from an Oracle database. Materialized views that are dependent on views or materialized views not owned by the connecting user will not contain proper column information after reverse engineering.

To avoid the problem, AllFusion ERwin DM can retrieve the dependency information from the SYS.DBA_DEPENDENCIES catalog view instead of the SYS.ALL_DEPENDENCIES catalog view. However, this requires that the connecting user performing the reverse engineer has SELECT privilege on the DBA_DEPENDENCIES view. If the user does not have this privilege, AllFusion ERwin DM will use the ALL_DEPENDENCIES view.

This problem does not exist for reverse engineering materialized views that are only dependent on tables.

7.3 Reverse Engineering Scripts With Reserved Words

You cannot reverse engineer a script that includes keywords that are designated as reserved words by the target database. For example, in Oracle, reserved words like 'table', 'view', and 'order' cannot be used in the database without quotes. If you reverse engineer a script with reserved words, a generic parser error message displays, warning you of the syntax error.

To learn more about the reserved keywords for your target database, please refer to the SQL documentation provided by your database vendor.

You can enclose reserved words in quotes to avoid this problem. In the Forward Engineering dialog, use the 'Quote Names' option listed under 'Other Options'.

7.4 Documentation Correction

When you right-click within the Advisories Pane or Action Log Pane, a context menu appears. The online help for this context menu incorrectly refers to a 'Float in Main Window' option. It should refer to the 'Allow Docking' option.

If you want to reposition the pane in your workplace you can move it, dock it, undock it, or hide it.

To move the pane to another position in the workplace, click the gripper icon that appears along the edge of the pane and drag it to a new position on the workplace. To 'float' the pane in the workplace, right-click the upper area of the pane near the toolbar icons and deselect the 'Allow Docking' option in the shortcut menu. To re-dock a pane that you floated in the workplace, right-click the upper area of the pane near the toolbar icons, and select the 'Allow Docking' option. You can then drag the pane to another location in the workplace and dock it there. To hide the pane completely, right-click in the pane and choose Hide from the shortcut menu.

8.0 International Support

An internationalized product is an English product that runs correctly on local language versions of the required operating system and required third-party products, and supports local language data for input and output. Internationalized products also support the ability to specify local language conventions for date, time, currency and number formats.

A translated product (sometimes referred to as a localized product) is an internationalized product that includes local language support for the product's user interface, online help and other documentation, as well as local language default settings for date, time, currency, and number formats.

In addition to the English release of this product, Computer Associates supports only those languages listed in the following table.

Note: If you run the product in a language environment not listed in the table, you may experience problems.

9.0 Documentation

The file names for the PDF guides are as follows:

To view PDF files, you must download and install the Adobe Reader from the Adobe website if it is not already installed on your computer.

Updated guides will be available at http://ca.com/support.

10.0 Contact Customer Support

For online technical assistance and a complete list of locations, primary service hours, and telephone numbers, contact Customer Support at http://ca.com/support

Erwin Data Modeler 7.1 Free Download Free

Erwin Data Modeler 7.1 free download. software