ERWIN Data Modeler

CA ERWIN® DATA MODELER (CA ERWIN DM) IS AN INDUSTRY-LEADING DATA MODELING SOLUTION THAT ENABLES YOU TO CREATE AND MAINTAIN DATABASES, DATA WAREHOUSES (DWS) AND ENTERPRISE DATA MODELS — HELPING YOU BETTER MODERATE DATA COMPLEXITIES, EFFECTIVELY MANAGE DATABASE TECHNOLOGIES AND PROPERLY ALIGN YOUR INFORMATION INFRASTRUCTURE WITH THE BUSINESS IT SUPPORTS.

Maintaining a competitive stance in today’s informationdriven economy requires quick, well-planned decisions that are bolstered by accurate data. To this end, organizations must develop high-performance business applications that transform data into a strategic asset. And to do so, they need to leverage a solid database foundation that enables agility while controlling the total cost of ownership (TCO) over the lifecycle of all data assets.

•Design Layer Architecture: Aligns data models with business requirements at the logical level with the database design at the physical level. CA ERwin Data Modeler maintains a record of relationships and design decisions, allowing you to quickly resolve the impact of changes from one design layer to the next.
•Database Design Generation: Forward and Reverse Engineering capabilities allow you to create an inventory of existing database structures, and generate new structures from your model design. Customizable templates facilitate the generation of a model’s complete physical design and definitions.
•Complete Compare: Automates the bidirectional synchronization of models, scripts and databases. It compares items, displays their differences and allows you to select which differences are moved and in which direction. In addition, should model changes be moved to a database, CA ERwin Data Modeler can automatically generate a database ALTER script.
•Metadata Integration and Exchange: Provides wizard-guided import and export capabilities for an out-of-the-box exchange of model metadata between more than 70 industry-standard modeling, design and metadata management formats, including the Unified Modeling Language (UML), Common Warehouse Metamodel (CWM), Extensible Markup Language (XML), Extract, Transform, Load (ETL), Enterprise Information Integration (EII), BI tools and various metadata repository solutions.
•Standards Definition: Supports the definition and maintenance of standards through its domain dictionary, naming standards editor and data type standards editor.
•Reporting and Publication: Offers flexible,customizable reporting and printing capabilities that generate in a variety of formats, including HTML and PDF. Integration with Business Objects Crystal Reports provides reporting flexibility by allowing you to use the open database connectivity (ODBC) option to develop customized reports.
 

CA ERwin Data Modeler supports full forward and reverse engineering capabilities for the following database platforms:

•Access
•DB2 (z/OS and UDB)
•FoxPro
•Informix
•Ingres
•iSeries
•MySQL
•ODBC (Generic)
 •Oracle
•Progress
•RedBrick
•SAS
•SQL Server
•Sybase
•Sybase IQ
•Teradata