Overview
Go Up to User Guide
ER Studio Data Architect is an industry-leading data modeling tool for designing and understanding databases, helping companies discover, document, and re-use data assets. With round-trip database support, you can reverse-engineer, analyze, and optimize existing databases. Productivity gains and organizational standards enforcement can be achieved with ER Studio Data Architect's strong collaboration capabilities.
ER Studio Data Architect offers:
- Model-driven design environment
- Complete database life cycle support
- Enterprise model management
- Data lineage documentation
- Enterprise communication capabilities
- Data warehouse and integration support
- Quality database designs
This overview provides a basic introduction to ER Studio Data Architect, the products in the ER Studio Data Architect family, and Embarcadero applications that can further enable data architects.
ER/Studio Family Products
There are several products in the immediate ER/Studio family:
- ER Studio Data Architect : Provides a complete environment for analyzing, designing, creating, and maintaining database applications.
- ER/Studio Repository : (Repository) Productivity gains and enforcement of organizational standards can be achieved with strong collaboration capabilities offered by ER/Studio Repository, a version-control application. ER/Studio DA and ER/Studio Business Architect users connect to the Repository to get a data model revision, check in changes, compare and merge local copies of the data model to a version in the Repository, and run various usage reports. ER/Studio Viewer and ER/Studio Team Server users have read-only access to the Repository.
- ER/Studio Viewer : (Viewer) ER/Studio Viewer provides an interactive environment for accessing ER Studio Data Architect data models, offering the same sophisticated navigational features of ER Studio Data Architect to members of the modeling team that want advanced viewing, navigation and printing functionality but do not require the ability to edit the models.
- ER/Studio Team Server : ER/Studio TS allows easy distribution of data governance repository metadata to the enterprise. ER/Studio TS lets you make use of datasource definitions stored centrally, as well as letting you search, browse, and report on the information contained on ER/Studio TS.
- Universal Data Models : Standard and Industry data model templates for ER Studio Data Architect that reduce the development time of database-related projects by an average of 60 percent, as well as improve the quality of existing and new data models.
- MetaWizard : Integrates metadata across modeling tools, business intelligence, ETL platforms and industry-standard exchange formats (XMI, XML and XSD). This tool enables ER Studio Data Architect to integrate with more than seventy other applications by sharing metadata through an import-export capability.
In addition to the products above, Embarcadero also offers the following complementary applications:
- ER/Studio Business Architect: A business modeling tool for creating a graphical representation of your business from the core concepts that describe the business, to the processes that detail how your business operates. The product allows you to easily model your business processes and how those processes use data. The product's Conceptual Modeling provides an intuitive way to outline subject areas and concepts that can then drive the creation of detailed data models. ER/Studio Business Architect is now bundled with ER/Studio Repository.
Application Design
The following diagram shows the functional relationship among ER/Studio components and with the software components of a typical development system.
