ERwin Data Modeler Download the latest version for Windows. It is separate installation configuration without complete connection ERwin Data Modeler. 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.
Who’s No. 1? We are! We don’t mean to brag (well, maybe a little), but data modeling remains the best way to design and deploy relational databases and support application development, and erwin Data Modeler (DM) continues to be the award-winning gold standard. The world’s largest organizations and top brands use it to discover, design, visualize, standardize and deploy high-quality data assets through an intuitive, graphical interface. With erwin DM, view “any data” from “anywhere” for consistency, clarity and artifact reuse across large-scale data integration, master data management, Big Data and business intelligence/analytics initiatives. Visibility into where and how data should be used as part of a central repository makes erwin DM key to effective data governance.
Manage any type of structured or unstructured data regardless of where it’s stored – from any type of relational database to data warehouses or in the cloud.
Give stakeholders an integrated view of conceptual, logical and physical models, so both business and technical users can collaborate across your enterprise.
By using data models to define and deploy your enterprise data standards, you’ll realize more consistency and higher quality in data management.
erwin DM Standard Edition
erwin DM Standard Edition is our flagship data modeling solution for creating and deploying visual data models for hybrid data infrastructures. Users automatically generate data models with a simple, graphical display to visualize a wide range of enterprise data sources. Increase quality and efficiency with reusable standards, including model templates, domains, automation macros, naming standards and datatype standards.
erwin DM Workgroup Edition
erwin DM Workgroup Edition offers the same functionality as erwin DM Standard Edition, plus a centralized model management repository, collaborative modeling with conflict resolution, and change management with audit capabilities. It’s ideal for teams with multiple members working on models simultaneously and/or that need change management functionality.
erwin DM Navigator Edition
erwin DM Navigator Edition provides read-only access to erwin data models and metadata. It provides discovery, visualization and analysis capabilities for various roles within the organization who need to view specific information but don’t need to create or change data models.
Extracting Data from ERP, CRM and Other Enterprise Apps
erwin Safyr Option extracts and converts data from ERP, CRM and other enterprise apps for accurate modeling and analysis with erwin DM. This tool also can consolidate duplicate systems, reducing license costs due to M&A activity or general cost reduction.
CA |
5.0 Installation Considerations
5.1 Installing API Components
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
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.
AllFusion ERwin Data Modeler (AllFusion ERwin DM) requires that you have one of the following operating systems installed:
The following requirements must be met or exceeded for AllFusion ERwin DM r7 to install and run correctly:
The following list of target server databases are supported in AllFusion ERwin Data Modeler r7.
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.
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.
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.
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.
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.
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.
All published fixes for this product can be found through Published Solutions on SupportConnect.
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.
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.
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'.
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.
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.
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.
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.
Updated guides will be available at http://ca.com/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.