ER/Studio vs. IBM Rational Data Architect

TEEHSCompetitive AnalysisTAADER/Studio® vs IBM® Rational Data ArchitectEmbarcadero ER/Studio helps companies Feature/FunctionalityER/Studio IBM RDAdocument and enhance existing databases, Undo/Redoxximprove data consistency, effectively communicate On Screen Editing, Attribute Copy/Move, xmodels across the enterprise, and model more Primary Key Creationthan just data. With many additional features Zoom and Overview Navigational Windowsxxlacking in IBM Rational Data Architect, ER/Studio Multiple Auto-layout Algorithms xbrings clarity to complex data models.Industry and Subject Area Data Model xTemplatesOVERVIEWNaming Standardsxx“Where Used” AnalysisxInformation management and data architecture teams globally are faced with Logical Data Modelingxxstandardization, governance, and metadata Physical Data Modelingxxchallenges as they manage and optimize their IT infrastructure. Embarcadero ER/Dimensional ModelingxxStudio is an industry-leading cross-platform Compare and Mergexxdata modeling tool that helps users overcome these challenges. Model Diff ReportingxDDL GenerationxxER/Studio possesses powerful features like nested sub-models, “where used” analysis, Reverse Engineeringxxdata lineage documentation, an extensible ALTER Generationxxrepository, navigational aids, and an auto-layout engine that make working Documenting source/target Collaborative Repositoryxmapping and sourcing rules helps with even the most complex data models data professionals trace data Enterprise Data Dictionary Systemxeasy. It allows companies to define and movement across systems.reuse common data elements across projects XML Schema Creationxxto promote standardization while sophisticated naming standards HMTL and RTF Reportingxxstreamline the translation between the logical and physical design layers. Consolidating all metadata into a central repository, users can Programmatic Access to Application (SDK)xxtransfer knowledge among stakeholders and easily see relationships Model Validationxxand business rules that relate to their data. ER/Studio expands beyond traditional data modeling, allowing users to generate XML schemas Process & Conceptual Modeling*xxfrom either logical or physical models. Template models, which Schema Validation and Testing**xsupport key data subject areas as well as specific industries, jumpstart any project and increase productivity.* Process & Conceptual Modeling through EA/Studio** Schema validation and test through Schema ExaminerCASE STUDYWhen one of the largest financial services company in the world need In the end, ER/Studio was chosen for its superior model management to retool its metadata management and modeling tools, the internal and integration capabilities, cross-platform support, and high-quality Data Management Services group distributed a comprehensive RFP, analysis and reporting. In addition, the highly readable visual format evaluating multi-platform support, improved delivery, and enhanced made it easy to use and communicate across functions.functionality for business and IT partners.“Embarcadero clearly offered the best data modeling solution The team tested a number of data modeling and repository solutions to meet our requirements,” said the Senior Designer in the Data against the department’s specific functionality requirements –Management Services team. “ER/Studio matched our high-priority comprehensive database lifecycle support, impact analysis, open APIs, functional requirements including high-quality HTML, mapping forward and reverse engineering capabilities, model management, functions, and good metadata repository capabilities. Embarcadero powerful communication functionality, and high quality database ER/Studio does exactly what it says, and stood up against our high design features. A proof of concept project was then carried out expectations.”between the short-listed vendors to further investigate how particular solutions addressed the requirements.Download a Free Trial at www.embarcadero.comCorporate Headquarters | Embarcadero Technologies | 100 California Street, 12th Floor | San Francisco, CA 94111 | www.embarcadero.com | sales@embarcadero.com© 2009 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero Technologies logos, and al other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. Al other trademarks are property of their respective owners. ERSIBM/CA/2009/04/02