ER/Studio, a model-driven data architecture and database design solution, helps companies discover, document, and reuse data assets. With round-trip database support, data architects have the power to thoroughly analyze existing data sources as well as design and implement high quality databases that reflect business needs. The highly-readable visual format enhances communication across job functions, from business analysts to application developers. ER/Studio Enterprise also enables team and enterprise collaboration with its repository.

• ER/Studio Standard - Provides complete environment for analyzing, designing, creating, and maintaining database applications; connects to repository available with enterprise edition.



• ER/Studio Enterprise - Provides complete environment for analyzing, designing, creating, and maintaining database applications; enables improved collaboration through a scaleable, server-side model management system for versioning, security, and component sharing, includes repository and one seat of ER/Studio client-side application. Learn more about the collaborative functionality offered by ER/Studio Enterprise.

As data volumes grow and environments become more complex corporations find it increasingly difficult to leverage their information. ER/Studio provides an easy-to-use visual medium to document, understand, and publish information about data assets so that they can be harnessed to support business objectives. Powerful reverse engineering of industry-leading database systems allow a data modeler to compare and consolidate common data structures without creating unnecessary duplication. Using industry standard notations, data modelers can create an information hub by importing, analyzing, and repurposing metadata from data sources such as business intelligence applications, ETL environments, XML documents, and other modeling solutions.

When businesses rely on information to make key decisions, the underlying data needs to be accurate and relevant. Knowledge workers can spend significant amounts of time looking through data sources, researching what information means, and find that it is not being used appropriately. ER/Studio helps data architects define and reuse common data elements and modeling components across projects to establish standards in their modeling practices. By enforcing standards, and being able to analyze and document data elements, corporations can better understand and utilize their data, reduce redundancy, and build consistency.

ER/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 technical users. Streamlined navigational aids, diagram layout utilities, and powerful report publishing functions simplify the communication of designs within and beyond the data modeling group. ER/Studio makes it easier to understand and communicate the current state of data throughout the enterprise, maintain corporate standards, and encourage appropriate data usage. Bringing all metadata into a central repository helps the transfer of knowledge among stakeholders, and allows users to easily see relationships and business rules that relate to their data.

With a clear understanding of where data originated and where it is used, organizations can be assured that they know what their data actually means and how it can best be utilized. ER/Studio.s data lineage functionality provides data professionals with the ability to document how data flows through the organization. Attachments also allow organizations to append specific information to their models to enhance documentation.

• Multilevel Design Capabilities - Allows many physical designs from a core logical architecture
• Automated Transformation - Streamlines the derivation of a physical design from a logical one and checks for normalization and compliance with the target database platform
• Denormalization Mapping - Allows physical database designers to optimize a logical design while maintaining ties to the logical artifact.
• Extensible Automation Interface - Automates tedious, routine tasks such as coloring tables, enforcing and applying naming standards, globally updating storage parameters and integrating with other desktop applications such as Microsoft Excel, Word, or Access
• Industry Standard Design Notations - Supports IDEF1X, Information Engineering (IE or "Crow's Foot") as well as Filtered IE which hides all foreign keys

• Reverse-engineering - Constructs a graphical model from an existing database or schema
• Forward-engineering - Generates source code for some database designs
• Database Modification - Allows design changes made to the data model to be applied directly to a database by formulating intelligent alteration code

• Advanced Compare and Merge - Enables advanced, bidirectional comparisons, and merges of model and database structures such as logical to physical, physical to physical, physical to database, etc.
• Submodel Management - Allows creation of multileveled submodels, merging of submodel properties across existing models, and synchronization submodel hierarchies across disparate models
• Metadata 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 hub

• Data Dictionary Standardization, Enforcement and Reuse - Helps users define and enforce standard corporate data elements, and many other objects across any project. Facilitates communication and support of standards across complex models with domain inheritance, reusable objects, and automatic updates
• "Where Used" Analysis with User-defined Mapping - Displays the mappings between logical entities and attributes and their implementation across physical designs. Allows data architects to customize the mapping of logical and physical artifacts for informational purposes
• Repository for Team-centric Collaborative Modeling - Provides organizations using ER/Studio with a scalable, server-side, model management system that includes model and object version management, security management, and the ability to branch and merge models. The repository is available in the Enterprise edition. Learn more about the collaborative functionality offered by ER/Studio Enterprise.

• Advanced Graphics and Layout - Automatically creates highly readable, highly navigable diagrams
• Automated Web Publishing - Generates HTML reports of complete diagrams that can easily be shared across an intranet
• Presentation-Quality RTF (Microsoft® Word) Reports - Delivers completely customizable RTF report output suitable for professional presentations or publications
• XML Schema and DTD Output - Offers www.w3c.org XSD (Schema) and DTD output of its data models to accommodate customer-specific extensions
• ER/Studio Viewer - Provides anyone outside the data modeling team with an interactive environment for viewing ER/Studio data models.

• Data Lineage Documenting - Documents source/target mapping and sourcing rules for data movement across systems
• Dimensional Modeling - Leverages complex star and snowflake schema designs and supports the importation of its rich dimensional metadata from variety of BI and data warehouse platforms
• Data Model Export - Supports exporting data warehouse designs to a variety of platforms and development solutions

• Automatic Migration of Foreign Keys - Maintains foreign keys to ensure referential integrity in designs
• Validation Wizards - Incorporates wizards to promote normalization of logical diagrams and ensure that physical designs comply with the syntax and naming rules of the target diagram
• Auto-documentation - Allows the addition of definitions and notes efficiently from the visual editors and constructs verb phrase sentences to clarify the purpose of relationships
• Security/Permissions Modeling - Enables users, roles, and permissions modeling at the logical and physical level
• Capacity Planning - Manages row count and growth rates for tables and can calculate future storage requirements and forecasts future needs

• Hitachi® HiRDB
• IBM® DB2® Universal Database® 5.x, 6.x, 7.x & 8.x for LUW, 5.x, 6.x, 7.x for z/OS®& iSeries V4R5 and V5R2
• Informix® OnLine and SE
• Informix 9.x dynamic server
• InterBase™ 4
• Microsoft® Access 2.0, 95, 97 & 2000
• Microsoft SQL Server 6.5, 7, 2000 & 2005
• Microsoft Visual FoxPro® 3, 4, 5
• MySQL® 3.x, 4.x
• NCR Teradata V2R4, V2R5
• Oracle® 7.3.x , 8.x, 9i, 10g
• Sybase® Adaptive Server Enterprise (ASE) 11.9.2, 12.x & 12.5
• Sybase Adaptive Server Anywhere (ASA) 5, 6, 7, 8, 9
• Sybase Watcom™ SQL

• 100 MB of hard disk storage
• 512 MB of RAM recommended (1 GB recommended for large diagrams. i.e. 1000+ entity range)
• 1024 x 768 Display Resolution recommended
• Windows 2000, Windows XP & Windows 2003 Server
• Native Connections: Oracle, DB2 UDB(LUW, iSeries and z/OS), SQL Server and Sybase client libraries required
• ODBC Connections: For databases ER/Studio supports via ODBC, a valid ODBC driver is required