Enterprise Data Modeling | ER/Studio Data Architect

design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it TE build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build itEH run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run itSER/Studio® Data Architectdesign it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it TAA build E it n ∙ trun er it p ∙ ridesign se Dit a ∙ tbuild a Mit ∙ o run delit i∙ ndesign git ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build itD run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run itDATA ARCHITECTEmbarcadero® ER/Studio® Data Architect is a industry-leading Product Editionsdata modeling tool that helps companies discover, document, and re-use data assets. With round-trip database support, data ER/Studio® Data ArchitectProvides complete environment BUSINESS ER/STUDIOSOFTWARE ARCHITECTARCHITECTarchitects have the power to easily reverse-engineer, analyze, for analyzing, designing, ENEand optimize existing databases. Productivity gains and creating, and maintaining T E R PRISenforcement of organizational standards can be achieved with database applications.ER/Studio’s strong collaboration capabilities.ER/Studio® EnterpriseREPOSITORYPORTALUpgrade from ER/Studio Data Visual Data Architect to Embarcadero’s lineage provides • Document and enhance existing source-to-target modeling and architecture suite databasesmappingsthat combines process, data, application modeling and a • Improve data consistencybusiness intelligence engine • Effectively communicate models into a powerful multi-level across the enterprisedesign environment. • Trace data origins and whereabouts to Related Productsenhance data integration and accuracyER/Studio® Repository• Model more than your dataA scalable, server-based, model management systemDocUMEnt AnD EnhAncE ExiSting DAtABASESER/Studio® PortalA browser-based solution ER/Studio provides an easy-to-use visual interface to allowing organizations to document, understand, and publish information share, browse, and report on about existing databases so that they can be better information contained in the harnessed to support business objectives. Powerful ER/Studio Repositoryreverse engineering of industry-leading database systems allow a data modeler to An easy-to-use user interface to document, design, and ER/Studio® compare and consolidate common data structures without creating unnecessary communicate data assetsBusiness Architectduplication. Using industry standard notations, data modelers can create an Business modeling tool for information hub by importing, analyzing, and repurposing metadata from data sources such as business linking process and dataintelligence applications, ETL environments, XML documents, and other modeling solutions.ER/Studio® iMPRoVE DAtA conSiStEncySoftware ArchitectObject-oriented modeling tool Knowledge workers can spend significant amounts of time looking through data sources, researching what to visually analyze, design and information means, and find that it is not being used appropriately. ER/Studio helps data architects define implement complex application and reuse common data elements and modeling components across projects to establish standards in and data structures.their modeling practices. By enforcing standards, and being able to analyze and document data elements, corporations can better understand and utilize their data and reduce redundancy., ER/Studio® ViewerView, navigate and print ER/EffEctiVEly coMMUnicAtE MoDElS AcRoSS thE EntERPRiSEStudio models in a view-only environmentER/Studio brings clarity to models and to complex business rule enforcement. The multilevel design layers allow for the accurate visualization of data, which promotes communication between business and ER/Studio® MetaWizardIntegrate metadata across technical users. Streamlined navigational aids, diagram layout utilities, and powerful report publishing modeling tools, business functions simplify the communication of designs within and beyond the data modeling group. ER/Studio intelligence, ETL platforms and makes it easier to understand and communicate the current state of data throughout the enterprise, industry-standard exchange maintain corporate standards, and encourage appropriate data usage. Bringing all metadata into a central formats (XMI, XML and XSD)repository helps the transfer of knowledge among stakeholders, and allows users to easily see relationships and business rules that relate to their data.ER/Studio® Universal Data ModelstRAcE DAtA oRiginS AnD WhEREABoUtS to EnhAncE Standard and industry data DAtA intEgRAtion AnD AccURAcy model templates for ER/Studio that reduce development time With a clear understanding of where data originated and where it is used, organizations can be assured and facilitate standardizationthat they know what their data actually means and how it can best be utilized. The ER/Studio visual data lineage functionality provides data professionals with the ability to document how data flows through the Embarcadero® organization. Attachments also allow organizations to append specific information to their models, thus Schema Examinerenhancing documentation.Automate error-checking and corrections for database MoDEl MoRE thAn yoUR DAtAschema to quickly and easily improve data quality and Modeling isn’t just for data and databases. Modeling provides a picture of relationships that can be easily system performanceunderstood, used for impact analysis, and helps make your organization more efficient. With ER/Studio you can use modeling to produce XML schemas to ensure the benefits of modeling are applied to applications and projects such as Service Oriented Architecture (SOA).Select FeaturesER/Studio Data ArchitectHighly Productive Model-driven Design EnvironmentAdvanced Graphics and Layout Automatical y creates highly readable, highly navigable diagramsMultilevel Design Capabilities Al ows many physical designs from a core logical architectureAutomated and Custom Streamlines the derivation of a physical design from a logical one and checks for normalization and compliance with the target database Transformation platform. Custom data type mapping and naming standards templates further streamlines this processDenormalization Mapping Al ows physical database designers to optimize a physical design while maintaining ties to the logical artifactsExtensible Automation Automates tedious, routine tasks such as coloring tables, enforcing and applying naming standards, global y updating storage Interface parameters and integrating with other desktop applications such as Microsoft® Excel®, Word, or AccessUndo/Redo Reverses the most recent sequence of operations in chronological orderBi-Directional Object Add workflow comments to model objects for documentation needs or for communicating ideas when col aborating on models. CommentingComments are shared and accessed in both the Portal and the ER/Studio clientMultiple Presentation Formats Publishes models and reports in a variety of formats including HTML, RTF, XML Schema, PNG, JPEG, DTD Output, and ER/Studio ViewerBusiness Intel igence Portal Online BI portal al owing organizations to query, analyze, browse, report and share information contained in the ER/Studio Repository. ER/Studio Portal is available in ER/Studio EnterpriseComplete Database Lifecycle SupportForward-engineering Generates source code for some database designsReverse-engineering Constructs a graphical model from an existing database or schemaDatabase Modification Al ows design changes made to the data model to be applied directly to a database by formulating intel igent alteration codeEnterprise Model ManagementAdvanced Compare Enables advanced, bi-directional comparisons and merges of model and database structures such as logical-to-physical, and Merge physical-to-physical, physical-to-database, etc.Submodel Management Al ows creation of multileveled submodels, merging of submodel properties across existing models, and synchronization submodel hierarchies across disparate modelsMetadata Integration Imports and exports metadata from a variety of sources including BI platforms, UML and data modeling solutions, XML schemas, and CWM (common warehouse metamodel) to create a metadata hubData Dictionary Standardization, Helps define and enforce standard data elements, naming standards, reference values and many other objects across any project. Facilitates Enforcement and Reuse impact analysis and support of standards across multiple models with domain inheritance, reusable objects, and automatic updates.“Where Used” Analysis with Displays the mappings between logical entities and attributes and their implementation across physical designs. User-defined Mapping Al ows data architects to customize the mapping of logical and physical artifacts for informational purposes.XML Schema Generation Ensure XML projects such as those using Service Oriented Architecture (SOA) are based on the same standards and metadata as your data models by modeling them in ER/Studio and generating XSD from either the physical or logical model.Repository for Team-centric Provides organizations using ER/Studio with a scalable, server-side, model management system that includes model and object version Col aborative Modeling management, security management, and the ability to branch and merge models. ER/Studio Repository is available in the Enterprise edition.Data Warehouse and Integration SupportVisual Data Lineage Visual y documents source/target mapping and sourcing rules for data movement across systemsDimensional Modeling Leverages complex star and snowflake schema designs and supports the importation of its rich dimensional metadata from a variety of BI and data warehouse platformsQuality Database DesignModel Completion Validation Automates model reviews and enforces standards with more than 50 checks to validate logical and physical models for missing object definitions, unused domains, identical unique indexes, and circular relationshipsAutomatic Migration of Maintains foreign keys to ensure referential integrity in designsForeign Keys Capacity Planning Manages row count and growth rates for tables and can calculate future storage requirements and forecasts future needsSecurity Design and AssessmentData Classification Categorizes and labels data and objects according the level of security and privacy that should be applied to that informationPermission Management Enables users, roles, and permissions modeling at the logical and physical levelDBMS SupportSystem Requirements• Hitachi® HiRDB• Microsoft® Access 2.0, • PostgreSQL 8.xClient System Requirements:Server Repository Requirements:• IBM® DB2®: 5.x, 6.x, 95, 97, 2000• Sybase® Adaptive • 100 MB of hard disk storage• Pentium IV-class processor or higher7.x, 8.x, 9.x for LUW; • Microsoft SQL Server Server® Enterprise • 1 GB of RAM minimum, 2 GIG of RAM recommended • 50MB hard disk storage for 5.x, 6.x, 7.x, 8.x, 9.x 7, 2000, 2005, 2008(ASE) 11.9.2, 12.x, • Pentium III, 600 MHz or higherinstal ation requiredfor z/OS®; and iSeries • Microsoft Visual 12.5, 15.0• 1024x768 display resolution recommended• 2 GB of RAMV4R5 and V5R2FoxPro® 3, 4, 5• Sybase Adaptive • Windows 2000 Pro Server, Windows XP Professional, • Windows 2000, Windows XP, • Informix® OnLine • MySQL® 3.x, 4.x, 5.xServer Anywhere Windows 2003 (32-bit mode), and Windows Vista Windows 2003 Server, Windows and SE• NCR® Teradata® V2R4, (ASA) 5, 6, 7, 8, 9, 10• Native Connections: Oracle, DB2 UDB (LUW, iSeries, Vista• Informix 9.x dynamic V2R5, V2R6, 12.0• Sybase IQ 12.5and z/OS), SQL Server, and Sybase client libraries • Native Connections: Oracle, DB2 server• Oracle® 7.3.x, 8.x, 9i, • Sybase Watcom SQLrequired UDB (LUW, iSeries, and z/OS), SQL • InterBase® 4, 2007, 10g, 11g• ODBC Connections: For databases ER/Studio Server, and Sybase client libraries 2009supports via ODBC, a valid ODBC driver is requiredrequiredDownload 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. ERSDA/DS/2009/09/26