ER/Studio is a powerful and complete solution for modeling, architecture, and creating physical database designs
The ER/Studio® XE3 is the most innovative and intuitive modeling and information architecture solution on the market. Combining process, data, application modeling and reporting into a multi-level design environment, ER/Studio XE3 enables you to understand, design and communicate complex systems and architecture faster and easier.
Manage all of your database designs and models from multiple database platforms in a single window
ER/Studio provides multi-platform DBMS support across your heterogeneous DBMS environment. ER/Studio supports InterBase®, Oracle®, DB2®, Sybase®, SQL Server, Netezza, Teradata, MySQL®, PostgreSQL, and more, all from a single window.
Reduce redundant data by leveraging fully separated logical and physical models
ER/Studio supports both logical (non-DBMS or technology-specific) modeling and physical (DBMS-specific) modeling. It is designed to allow organizations the flexibility to analyze and design a business problem or application logically and generate as many different physical interpretations from the logical model as you want. Multiple physical models can also be generated from the logical model for the same DBMS or other DBMSs.
Easily create highly readable, highly navigable diagrams
ER/Studio's progressive interface and simplicity has been designed to effectively address the ease-of-use issues which have plagued data modeling and CASE tools for the past decade and more. The application equips you to create, understand, and manage the life-cycle of mission-critical database designs and business metadata within the enterprise.
Ensure standardization across your SOA implementations with XSD 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. This allows for the re-use of existing metadata and ensures corporate standards are enforced.
Improve communication and documentation with automatic report generation
Facilitate communication with non-users of ER/Studio by publishing data models and metadata directly to a corporate intranet or website for review by executive management or business analysts. ER/Studio's documentation generator enables users to automatically create reports in HTML or RTF that provide simple navigability through data models and model metadata. Take search and reporting capabilities even further with ER/Studio Portal.
Visually trace and document data origins across systems
The visual data lineage functionality provides data professionals with more flexibility, richer metadata and a visual representation of data movement between databases, flat files and XML structures. 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.
Increase productivity and collaboration through team modeling environment
The ER/Studio server-side repository is designed to distribute work across modeling team members in a safe and controlled way, facilitating a real-time collaborative modeling environment and increasing productivity for teams out of the box. It implements utilities and features that enable concurrent modeling, version management for model and model objects, establishment of continually reusable data elements, and is fully integrated with the current, natural workflow in ER/Studio.
Shrink data footprint through component sharing and data reuse
The ER/Studio Enterprise Data Dictionary introduces productivity capabilities stressing the elimination of data redundancy and enforcement of data element standards across projects. Easily create and implement pre-defined data dictionaries that can be re-used and globally updated throughout any diagrams distributed to the repository.
Manage large enterprise models into smaller functional areas for a greater level of detail and accuracy
ER/Studio allows the creation of multileveled submodels, merging of submodel properties across existing models, and synchronization of submodel hierarchies across disparate models. This enables users to break down a large, complicated main model in order to focus on a specific area for a greater level of detail and accuracy.