| CA |
5.0 Installation Considerations
5.1 Installing API Components
دانلود نرم افزار مدل سازی CA AllFusion ERwin Data Modeler, نرم افزار مدل سازی و طراحی پایگاه داده CA AllFusion ERwin Data Modeler. Data Modeling Tools. Data modeling has always been the best way to understand complex data sources and automate design standards and integrity rules. Today, the role of data modeling has expanded as the central point of collaboration between data generators, stewards and consumers. That’s because data modeling is the best way to visualize. CA ERwin Data Modeler is a program that provides a powerful way to visualize data from multiple sources across the. A free antivirus protecting your.
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
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.
- 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.
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.
Erwin Data Modeler 7.1 Free Download
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.
Erwin Data Modeler 7.1 Free Download Windows 10
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.
Erwin Data Modeler Download
In addition to the English release of this product, Computer Associates supports only those languages listed in the following table.
Erwin Data Modeler 7.1 Free Download Free
| Internationalized | Translated | |
|---|---|---|
| Brazilian-Portuguese | Yes | No |
| Chinese (Simplified) | Yes | No |
| Chinese (Traditional) | Yes | No |
| Czech | Yes | No |
| Danish | Yes | No |
| Dutch | Yes | No |
| Finnish | Yes | No |
| French | Yes | No |
| German | Yes | No |
| Greek | Yes | No |
| Hungarian | Yes | No |
| Italian | Yes | No |
| Japanese | Yes | Yes |
| Korean | Yes | No |
| Norwegian | Yes | No |
| Polish | Yes | No |
| Russian | Yes | No |
| Spanish | Yes | No |
| Swedish | Yes | No |
| Turkish | Yes | No |
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:
| File Name | |
|---|---|
| AllFusion ERwin Data Modeler Getting Started Guide | ERwin_GSG.PDF |
| AllFusion ERwin Data Modeler Methods Guide | ERMethods.PDF |
| AllFusion ERwin Data Modeler Release Summary | ERwin_RelSum.PDF |
| AllFusion ERwin Data Modeler API Reference Guide | ERwin_API_Ref.PDF |
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.
Download Erwin Data Modeler Free
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
Copyright © 2006 CA. All rights reserved.