ER/Studio is a powerful and complete solution for modeling, architecture, and creating physical database designs
The ER/Studio® XE4 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 XE4 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, Hadoop Hive, 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.
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.
Speed comprehension and reduce the risk of data policy violations by attaching data governance policies to daily workflows with contextual alerts and tips
With CONNECT, integrate enterprise business definitions with data management tools and internal web assets to provide on-the-fly business context. In addition, with CONNECT, adhere to industry regulations and business standards regarding security and privacy by alerting users who view or modify sensitive data within integrated data management tools.
Allow any user to locate and completely utilize existing enterprise data via reports, glossaries, taxonomies and registries
With CONNECT, develop applications and analyses faster by using business terms to easily find data elements. Second, create a single searchable registry of all available data sources to reduce time spent searching for data. Next, create a tightly integrated information map by relating data models with their data sources. This brings consistency to your reporting by creating a single source of truth about your enterprise data.
Define and publish more valuable business and data definitions by leveraging integrated collaboration and social capabilities
With CONNECT, apply enterprise collaboration capabilities to capture and use corporate tribal knowledge to reduce time identifying and correcting expensive data quality issues. Second, view, classify, relate and centrally manage authoritative business definitions in a personalized enterprise glossary. Next, enhance comprehension of business terms and data elements with custom extensions.