WIXLIB

PRODUCT BRIEF: CA ERWIN DATA MODELER R7.3CA ERwin Data Modeler r7.3CA ERWIN DATA MODELER (CA ERWIN DM) IS AN INDUSTRY-LEADING DATA MODELINGSOLUTION 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 INFORMATIONINFRASTRUCTURE WITH THE BUSINESS IT SUPPORTS.OverviewMaintaining a competitivestance in today’s informationdriven economy requiresquick, well-planned decisionsthat are bolstered by accuratedata. To this end,organizations must develophigh-performance businessapplications that transformdata into a strategic asset.And to do so, they need toleverage a solid databasefoundation that enables agilitywhile controlling the total costof ownership (TCO) over thelifecycle of all data assets.BenefitsCA ERwin DM providesthe data models that helpimprove the quality ofbusiness information, as wellas the efficiency with whichit is delivered. In this way,CA ERwin DM aligns businessrules and requirementswith technical databaseimplementation, ensuring thatyour business needs are metand your data is designedand structured in an efficientmanner. Moreover, CA ERwinDM assists in the creationof standards that improvequality and consistency,while reducing costs.The CA AdvantageCA ERwin DM combinesyears of data modeling anddevelopment experience intoa best-of-breed product witha flexible, open architecturethat allows you to integratethe information from yourdata model with a varietyof tools and applications —making your data model thecenter of your informationarchitecture. And as a corecomponent of CA’s ERwinModeling family, CA ERwinDM becomes a key pieceof the CA DatabaseManagement (CA DBM)solution, which enhancesand simplifies informationmanagement.

CA ERwin DM Enables Critical Data Management ProcessesCA ERwin DM allows you to visualize your organization’s complex data structures,create a comprehensive inventory of information assets and establish enterprise-wide datamanagement standards. To this end, CA ERwin DM helps you design, generate and manageyour organization’s transactional systems, data marts and DWs — as well as the business rulesand definitions supporting them. Whether for a business intelligence (BI) application, a masterdata management (MDM) project or an enterprise-wide modeling initiative, CA ERwinprovides tools and functionality to support the architectural foundation of your informationmanagement needs.Through an easy-to-use graphical interface that simplifies database design and automatesmany time-consuming tasks, CA ERwin DM accelerates the creation of high-quality,high-performance transactional databases and DWs. What’s more, this cost-efficient productassists data modelers in visualizing requirements, promotes effective communication betweendata management teams and stakeholders and enables database developers to address designissues and concerns prior to any significant resource investments. What’s more, CA ERwin DMhighlights the impact of modifying information assets and allows you to quickly review andimplement changes — helping your organization respond faster to evolving business needs.Key Features of CA ERwin DMCA ERwin DM includes a host of features that work in concert to deliver a robust,comprehensive data modeling tool that can easily support database, DW and enterprisedata model creation and maintenance.DESIGN LAYER ARCHITECTURECA ERwin DM aligns data models with business requirements at the logical level and with thedatabase design at the physical level through support for separate logical and physical modelsand the traditional, combined logical-physical model. In addition, CA ERwin DM maintains arecord of relationships and design decisions, allowing you to quickly resolve the impact ofchanges from one design layer to the next.2 PRODUCT BRIEF: CA ERWIN DATA MODELER R7.3

FIGURE ADESIGN LAYER ARCHITECTUREWith CA ERwin DM, you can createseparate logical and physical datamodels, as well as new models basedon existing structures.STANDARDS DEFINITIONCA ERwin DM supports the definition and maintenance of standards through its domaindictionary, naming standards editor and data type standards editor. The domain dictionarycontains reusable model attributes that help ensure consistent naming and definitionconventions across your organization. The naming standards editor enables you to create aglossary of valid words, abbreviations and rules for use within the model. And the data typestandards editor helps you define the standards for mapping both user-defined and defaultdata types to specific database management system data types.LARGE MODEL MANAGEMENTWith its subject areas and stored displays functionality, CA ERwin DM simplifies the processof managing the vast number of data model objects common in large enterprises. Subjectareas divide the model into smaller, more manageable subsets, providing a focused view forindividual modelers. Stored displays offer multiple graphical views of the model or its subjectareas, facilitating information exchange between and among specialized user groups.COMPLETE COMPAREThis powerful feature automates the bidirectional synchronization of models, scripts anddatabases. It compares items, displays their differences and allows you to select whichdifferences are moved and in which direction. In addition, should model changes be movedto a database, CA ERwin DM can automatically generate a database ALTER script.DATABASE DESIGN GENERATIONOptimized referential integrity-trigger templates and a rich cross-database macrolanguage provide triggers and stored procedures you can tailor to your business needs.In addition, customizable templates facilitate the generation of a model’s complete physicaldesign and definitions — as appropriate for the target database.PRODUCT BRIEF: CA ERWIN DATA MODELER R7.3 3

DATA WAREHOUSE AND DATA MART DESIGNCA ERwin DM supports data warehousing-specific modeling techniques — including starschema and snowflake dimensional modeling — optimizing the DW and data mart to yourorganization’s specific performance and analysis needs. It also captures and documents a richset of information about the warehouse, including data sources, transformation logic and datamanagement rules.TRANSFORM TECHNOLOGYPhysical database designs rarely match the original logical data design because businessconsiderations and performance requirements often dictate the need to de-normalize tables.To help, CA ERwin DM’s transform technology facilitates the implementation of these changeswhile maintaining the integrity of the original design.REPORTING AND PUBLICATIONTo promote better communication and collaboration, CA ERwin DM provides flexible,customizable reporting and printing capabilities that generate in a variety of formats, includinghypertext markup language (HTML), portable document format (PDF), rich text format (RTF)and text files (.TXT). In addition, integration with Business Objects Crystal Reports providesgreater reporting flexibility by allowing you to use the open database connectivity (ODBC)option to develop customized reports.FIGURE BDATA MODEL AND DATABASE DESIGN VISUALIZATIONDrawing objects improve modelreadability and aid in communicatingbusiness rules and constructs acrossthe enterprise.CUSTOMIZATIONCA ERwin DM provides forward-engineering templates that help you tailor the generation ofthe data definition language (DDL) to your business needs.4 PRODUCT BRIEF: CA ERWIN DATA MODELER R7.3

OPEN AND INTEGRATED ARCHITECTUREThrough the use of third-party metadata integrations and our robust application programinterface (API), the value of CA ERwin DM can be extended across your enterprise.Specific functionality includes: Metadata integration and exchange API and add-in managerProvides wizard-guided import and exportcapabilities for an out-of-the-box exchange of model metadata between more than70 industry-standard modeling, design and metadata management formats, including theUnified Modeling Language (UML), Common Warehouse Metamodel (CWM), ExtensibleMarkup Language (XML), Extract, Transform, Load (ETL), Enterprise Information Integration(EII), BI tools and various metadata repository solutions.METADATA INTEGRATION AND EXCHANGEAPI AND ADD-IN MANAGER Allows you to work with additional third-party softwareapplications to perform specific tasks that fall outside the boundaries and offerings includedin CA ERwin Modeling family.EXTENSIVE PRODUCT FAMILY COMPANION TOOLSThe CA ERwin Modeling family offers a wide range of complementary tools that allow you toleverage the information in your data models in other programs and initiatives, and increasethe quality of both your data and your database design. These products include: CA ERwin Model Manager (CA ERwin MM) CA ERwin Data Profiler (CA ERwin DP) CA ERwin Data Model Validator (CA ERwin DMV) CA ERwin Process Modeler (CA ERwin PM) CA ERwin Saphir1 Option CA ERwin Model Navigator (CA ERwin MN)CA ERWIN MMEnables you to manage multi-user collaboration and model and metadatamanagement.CA ERWIN DP Performs data profiling, cross-system analysis and primary/foreign key discoverywith metadata export to CA ERwin DM.Checks the structural integrity of data models and validates them against therules of relational theory.CA ERWIN DMVDocuments key business processes and visualizes the impact and relationshipof these processes with data objects modeled in CA ERwin DM.CA ERWIN PMExtracts and stores detailed metadata from enterprise resourceplanning (ERP) applications — including SAP R/3, SAP BW, Oracle PeopleSoft Enterprise,Oracle JD Edwards Enterprise One, Oracle Siebel and Oracle eBusiness Suite — and translatesthe often-confusing naming conventions common in these systems into more user-friendlyvalues.CA ERWIN SAPHIR OPTIONCA ERWIN MNProvides read-only model access to a variety of business and technical users.PRODUCT BRIEF: CA ERWIN DATA MODELER R7.3 5

What’s New in CA ERwin DM r7.3CA ERwin DM r7.3, the latest iteration of CA ERwin DM, includes a host of new featuresand functionality designed to help you further enhance your data management capabilities.Notable capabilities include: Enhanced database currency and support Enhanced metadata exchange Flexible reporting capability SQL query tool Customizable forward-engineering templates Microsoft Visual Studio Team System Database Edition 2008 (VSTS DB Edition) integration Complete compare improvementsENHANCED DATABASE CURRENCY AND SUPPORTCA ERwin DM now delivers enhanced out-of–the-box relational support for Teradata v2.6and v12, DB2 z/os v9, Oracle 11.x, as well as new support for SQL Server 2008. In addition,database currency and support encompasses forward engineering (FE), reverse engineering(RE), complete compare (CC) and user interface (UI) improvements.ENHANCED METADATA EXCHANGECA ERwin DM r7.3 provides improved bidirectional metadata exchange via support for thefollowing new interfaces: Cognos ReportNet QueryStudio Oracle Business Intelligence Answers Oracle Business Intelligence Enterprise Edition Oracle Business Intelligence Server Oracle Warehouse Builder SAP MDM Hub Sypherlink HarvesterFLEXIBLE REPORTING CAPABILITYCA ERwin DM r7.3 offers a new ODBC-based reporting feature, coupled with Crystal Reports2008, that provides a simple mechanism to produce pre-defined and ad-hoc reports that canfilter, format, select, manage and publish specific metadata information — from any model inyour environment.SQL QUERY TOOLThe new SQL query tool improves the effectiveness of modeling activities by empoweringusers to query database and catalog information, quickly browse model metadata and validatereporting syntax — without the need to learn and use a different product for each task. Inaddition, all queries can be saved, shared and reused between and among modelers, modelsand program features.6 PRODUCT BRIEF: CA ERWIN DATA MODELER R7.3