Infomatics Services



Products	Training	Clientele	Careers	Events

Embarcadero

ER/Studio

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 and business units. Comprehensive model management capabilities and metadata integration support simplify building and maintaining complex enterprise models. By providing improved visibility into and understanding of corporate data assets, these enterprise models promote data accuracy and data consistency.

Resource

Editions

Standard

Provides complete environment for analyzing, designing, creating, and maintaining database applications; connects to repository available with enterprise edition

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.

Highly productive model-driven design environment

	Powerful and easy-to-use user interface.
	Logical and physical design support.
	Automation and scripting support.

Complete database lifecycle support

	Reverse-engineering to seamlessly construct models from existing database and schema.
	Automatic generation database code from models, including code that reflects design changes in the model.

Enterprise model management

	Import and export metadata from a variety of sources including BI platforms, UML and data modeling solutions, XML schemas, and CWM (common warehouse metamodel).
	Key features for complex model management including sub-model management, repository(ER/Studio Enterprise), “where used” for impact analysis.

Enterprise communication capabilities

	Web publishing, RTF, XML Schema, and DTD output.
	Easy-to-read, easy-to-navigate diagrams.

Data warehouse and integration support

	Source/target mapping and sourcing rules to document data movement across systems.
	Star and snowflake schema designs for data warehouse modeling.

Quality database designs

	Validate designs and enforce referential integrity
	Capacity planning to manage growth and forecast future needs
	Security modeling; users, roles, and permissions at the logical and physical level