ER/Studio Data Architect

The Challenge of Fully Leveraging Enterprise Data

As organizations grow and data proliferates, ad hoc systems for storing, analyzing, and utilizing that data start to appear. Duplicated data infrastructures, multiple storage systems, full-time management efforts, and data correction tasks add an average of 200% to a company's data management costs.

Data management professionals face three distinct challenges:

Reduce duplication and risk associated with multiple data capture and storage environments;
Maximize data quality and re-usability across the organization;
Clearly and effectively communicating data to all users.

Accurate interpretation and re-use of essential data throughout an organization will speed better decision-making.

Recognizing the existence of complex data structures is as far as some companies get, scared off by the perceived cost of rectifying an ever-worsening situation.

ER/Studio Data Architect documents and enhances existing databases, improves data consistency and effectively communicates models across the enterprise

ER/Studio Data Architect provides an easy-to-use visual interface to document, understand, and publish information about existing databases so that they can be better harnessed to support business objectives. Powerful reverse engineering capabilities allow a data modeler to compare and consolidate common data structures without creating unnecessary duplication.

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 Data Architect 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.

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 Data Architect allows you to produce XML schemas to ensure the beneﬁts of modeling are applied to applications and projects built on Service Oriented Architecture(SOA).

Highly Productive Model-driven Design Environment
Advanced Graphics and Layout	Automatically create highly readable, highly navigable diagrams with one or a combination of layouts
Automated and Custom Transformation	Streamlines the derivation of one or more physical designs from a logical one and checks for normalization and compliance with the target database
Extensible Automation Interface	Automate tedious, routine tasks such as coloring tables, enforcing and applying naming standards, globally update storage parameters and integrate with desktop applications
Multiple Presentation Formats	Publish models and reports in a variety of formats including HTML, RTF, XML Schema, PNG, JPEG and DTD Output
Complete Database Lifecycle Support
Forward and Reverse Engineering	Generate source code from database designs. Construct graphical models from existing database or schema. Apply design changes with formulated alter code
Enterprise Model Management
Universal Mappings	Map between and within conceptual, logical and physical model objects to trace objects upstream or downstream
Advanced Compare and Merge	Enable advanced bi-directional comparisons and merges of models and database structures
Submodel Management	Allow creation of multileveled submodels, merge submodel properties across existing models and synchronize submodel hierarchies
Metadata Integration	Import and export metadata from BI Platforms, UML and data modeling solutions, XML Schemas and CWM (Common Warehouse Metamodel) to create a metadata hub
Data Dictionary Standardization	Define and enforce standard data elements, naming standards and reference values
"Where Used" Analysis	Display mappings between logical entities and attributes to their implementation across physical designs
XML Schema Generation	Ensure Service Oriented Architecture (SOA) XML projects are based on same standards as your data models
Data Warehouse and Integration Support
Visual Data Lineage	Visually document source/target mapping and sourcing rules for data movement across systems
Dimensional Modeling	Leverage complex star and snowflake schema designs and support importing rich dimensional metadata from BI and data warehouse platforms
Quality Database Design
Model Completion Validation	Automate model reviews and enforce standards by validating for missing object definitions, unused domains, identical indexes and circular relationships
Stewardship	Support for organizational roles to own specific processes
Powerful and Intuitive User Interface
Organizational Hierarchies	Project-based tree hierarchy to group multiple model types and diagrams to align with business initiatives or organizations
Automatic Migration of Foreign Keys	Maintain foreign keys to ensure referential integrity in designs
Capacity Planning	Manage row count and growth rates for tables to forecast future storage needs
Security Design and Assessment
Data Classification	Categorize and label objects according to the level of security and privacy
Permission Management	Enable user, role and group permissions at logical and physical level
DBMS Support	Hitachi, IBM DB2 (5.x…10.x), Informix (9.x), Greenplum(4.2), InterBase (4…2009), Microsoft Access(2.0…2000), Microsoft SQL Server (7…2012), Microsoft Visual FoxPro (3…5), Netezza (4.6…6.0), MySQL (3.x…5.x), NCR Teradata (V2R24…13.0), Oracle (7.3…11g), PostgreSQL (8.x, 9.x), Sybase Adaptive, Sybase Enterprise (ASE) (11.9.2…15.0), Sybase Adaptive Server (ASA) (5…10), Sybase IQ 12.5, Sybase Watcom SQL

Benefits Summary

Document and Enhance existing databases
Improve Data Consistency
Effectively Communicate Models across the enterprise
Trace Data Origins and Whereabouts to enhance Data Integration and accuracy
Model more than your data

Ready to learn more about ER/Studio?

Contact us at 1-888-233-2224 or This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

For database professionals, ask us about DB PowerStudio, the essential heterogeneous tool kit for Oracle, SQL Server, DB2, and Sybase.

"ER/Studio has been an invaluable tool for putting standards in place for designing and maintaining databases."
– Beaumont Hospital

BI/DW Resource Center

Learn best practices about data modeling for BI and data warehousing from industry experts Ralph Kimball, Bill Inmon and Claudia Imhoff

Try the ER/Studio Portal

Try our hosted web portal for free. It's like Google® for your metadata with centralized self-service reporting and searching of ER/Studio metadata.

Industry-leading data modeling tool to access, analyze, and optimize enterprise data.

The Challenge of Fully Leveraging Enterprise Data

System Requirements

Benefits Summary

Ready to learn more about ER/Studio?

BI/DW Resource Center

Try the ER/Studio Portal

ER/Studio Data Architect

ER/Studio Resources

More Information

Connect with us online

Data Modeling Articles

Announcing ER/Studio Data Architect 9.5.1

Enterprise Data – Risk and Reward

Generating Reports for Your Data Model