Your Cart



Need more information on this product? No Problem!

Please contact us on +44 (0)20 8733 7101 or email

  • Stock: In Stock
  • Model: ER/Studio
  • Weight: 0.00kg
  • MPN: Idera

Multi-level data modelling application for logical and physical database design and construction.

ER/Studio Enterprise Team edition provides fast, easy and collaborative way for data management professionals to build and maintain enterprise-scale data models and metadata repositories. Built-in facilities automate routine modeling tasks so users can analyse and optimise database and data warehouse designs fast. Model change management provides the ability to create and track tasks associated with data models in order to enable data architects to ensure their models stay aligned with database and application development efforts using an Agile workflow. With a repository-based model management system and Team Server web interface, ER/Studio Enterprise Team edition provides productive way to share, document and publish your models and metadata to distributed teams.

Features include:

  • Complete database lifecycle support
  • Enterprise model management
  • Enterprise communication capabilities
  • Data warehouse and integration support
  • Quality database designs
  • XML Schema generation from logical and physical models, enhanced conversion capabilities when moving between logical and physical models and strong dimensional modelling.

Embarcadero ER/Studio is available in the following Editions:

  • ER/Studio Standard: a complete environment for analysing, designing, creating and maintaining database applications
  • ER/Studio Enterprise: includes a server-side repository for enterprise collaboration and a licence for EA/Studio Business Modeler Edition.

ER/Studio - Features

ER/Studio is a data modeling application for logical and physical database design and construction. Its powerful, multi-level design environment addresses the needs of database administrators, developers and data architects who build and maintain large, complex database applications. The application offers strong logical design capabilities, bi-directional synchronisation of logical and physical designs, automatic database construction and Java application generation, accurate reverse-engineering of databases and powerful HTML-based documentation and reporting facilities.

New features in version 7 include:

  • Now users can attach rich data lineage information so they can easily track how data flows through the organizations radically reducing the amount of time researching data and increasing confidence and accuracy in the data used.
  • DBAs can understand growth requirements so that they can build high quality databases that will continue to perform optimally over time
  • Roles and permissions can be modeled at the logical level and then implanted across disparate physical platforms to simplify security management
  • Reverse engineer existing permissions to gain an understanding of existing security
  • The ability to forward engineer and synchronize security settings ensures consistency
  • Standards are much easier to enforce across large models as properties are automatically propagated across large environments
  • Model management in complex environments is simplified as DBAs can tailor standards to suit particular database platforms or environments.
  • Repository Stewards can manage complex hierarchies of diagrams to match the complexity of their business.
  • Subprojects can be created for working copies of models to allow wider audiences access to them.
  • Modelers will be able to easily manage common submodel structures across various models, allowing different modelers to work on their own areas within the larger enterprise structure
  • Object position and layout with a submodel can be synched across models reducing hours of reworking complex submodels
  • Define complex mappings between logical and physical artifacts to help your model match your business
  • Integrate disparate data models and/or project models into one enterprise model that can be leveraged across a wider team
  • Enhanced impact analysis of all dictionary objects across the repository.
  • New reporting capabilities to share valuable impact analysis metadata among team members
  • Manage multiple versions for development, test, and product models.
  • Manage separate versions of models for the next generation of the data model
  • Apply different levels of security to control which models have access to particular versions of a model
  • Seamlessly consolidate changes once a project is completed.

Features include:

  • Enterprise Data Modeling: ER/Studio is a data modeling application for logical and physical database design and construction. It enables the understand of the current state of data throughout the enterprise and helps organisations to make informed decisions about how to resolve data bottlenecks, eliminate redundancy and achieve higher quality applications that deliver data more efficiently and accurately to the enterprise
  • Multi-level Design Capabilities: create a logical design that can be transformed into physical designs supporting the same or different DBMS system catalogue. Maintain a normalised logical design while denormalising physical designs for performance optimisation. ER/Studio maintains links between all the levels of a design enabling changes to be merged in any direction
  • Automated Transformation: streamlines the derivation of a physical design from a logical one. In the process, ER/Studio checks for normalisation and compliance with the syntax for the target database platform
  • High Performance Graphics: draw crisp, clear ER diagrams with fast graphics performance. Change line style, colours, fonts, zoom levels and display modes
  • Cross-Project Domain and Model Re-use: enforce validated, user-defined domains and reference models across any project. Drag-and-drop technology facilitates access to and re-use of these objects and can be imported to a project at any time
  • IDEF1X, IE and Filtered IE Notation: supported with Filtered IE that hides all foreign keys. Set the default for all diagrams or change them on the fly
  • Explorer Navigation: work with even the largest ER diagrams. Use the Explorer browser to find and select entities. A single click brings the selected entity into focus in the diagram window. A double-click opens the object editor
  • Simple and Fast Submodels: manage the scope of design as data models grow. Create sub model views to isolate and manage important areas or large and complex data models. ER/Studio maintains all dependencies between submodel and the overall diagram automatically
  • Pure 32-bit Architecture: for superior performance.
  • Round Trip Design Capabilities: support for the iterative design process inherent in the application lifecycle. Control, document and deploy design changes in response to changing business demands
  • Reverse-Engineering: work from an existing database by reverse-engineering the complete schema for many database platforms. The reverse-engineering operation extracts object definitions efficiently and constructs a graphical data model
  • Forward-Engineering: build or generate source code for all or part of database designs and sequence the creation of different object types to ensure efficient, error-free database builds
  • Updating a Database from a Diagram: apply design changes made to the data model directly to a database. It formulates an intelligent alteration strategy that implements the design modifications when comparing differences between the two while preserving existing table data, object privileges and dependencies in the database
  • Updating a Diagram from a Database:merge changes in the database to an existing physical diagram or append a new physical diagram to the data model providing complete flexibility in analysing and merging database changes to a design
  • Repository-based Collaborative Modeling: ER/Studio Repository provides a scalable, server-side, model management system. It enables real-time concurrent access to data models between team members, implementation of security to protect models and components from unwanted access and change, facilitates component sharing and re-use across projects and offers extensive model version management. It integrates seamlessly with the current workflow of ER/Studio. ER/Studio Repositorys advanced capabilities establish:
    • Team-oriented collaborative modeling
    • Model and object version management
    • Model security management
    • Open architecture through industry-leading DBMS installation.
  • Integrated UML Application and Business Modeling with Describe: modeling-based solutions unite and simplify the enterprise application-to-database development challenges. The kit consists of ER/Studio and Describe tightly integrated with a bi-directional bridge
  • Comprehensive Reporting Capabilities: functionality for organising and publishing metadata in data models. Generate HTML reports for Web publishing and/or RTF reports for hard copy
  • Automated Web Publishing: document an entire diagram, generating an integrated set of sophisticated HTML reports that multiple users can share over an Intranet
  • Presentation-Quality Reports: completely customisable RTF reports (Microsoft Word 97) that are immediately suitable for professional presentations or publication
  • OLE Embedding: embed ER/Studio in OLE or Active X-enabled applications such as Microsoft Word or Internet Explorer and run ER/Studio inside OLE-enabled applications by opening or copying and pasting a data model into the applications
  • Open Meta Data: methods for accessing and distributing data in usable formats include:
    • Save as ASCII: DM1 files can be opened in comma separated ASCII text format
    • Build a Meta Data Repository: generate a complete meta data repository of any supported DBMS for custom reporting and querying
    • Save as XML: export data models defined in XML
    • ER/Studio Viewer: provides anyone outside of the data modeling team with an interactive environment for viewing ER/Studio data models.
  • Flexible and Open Architecture: expand ER/Studio's functionality through a new automation interface. Create Sax Basic commands (a VBA-like language) in ER/Studio's new macro scripting UI to tap directly into ER/Studios own object model to expand existing functionality or create entirely new functionality
  • Automate Routine Tasks: use the automation interface to automate tedious, routine modeling tasks or customise ER/Studio to enforce modeling practices
  • Collaborate with Other Applications: the metadata in ER/Studio models can be accessed from Microsoft Excel, Access, Outlook etc. Use the new automation interface to collaborate with any external application that has an exposed API or its own automation interface
  • Automatic Migration of Foreign Keys: maintains foreign keys to ensure referential integrity in designs and unify duplicate foreign keys to remove redundant references
  • Validation Wizards: a set of wizards validate logical and physical designs. The Logical Validation Wizard promotes normalisation of logical diagrams. The Physical Validation Wizard ensures that physical diagrams comply with the syntax and naming rules of the target database platform
  • Auto-Documentation: document data models, add definitions and notes efficiently from the visual editors and construct verb phrase sentences to clarify the purpose of relationships
  • Domain Integrity: define re-usable domains, custom datatypes, defaults and rules that can be shared between data models in order to enforce enterprise standards. Streamline the process of defining and enforcing consistent domain properties throughout data models. These re-usable objects also support global updates. Changing one automatically propagates updates to all referenced attributes
  • Leverage ER/Studio Data Models in other Embarcadero Solutions: document database designs across other Embarcadero solutions. DT/Studio and Data Voyager can use ER/Studio models directly in to consolidate and re-use as much information and documentation about databases as possible. DT/Studio can leverage ER/Studio physical designs while determining source-versus-target database structures to perform enterprise-calibre data ETL (Extraction, Transformation and Loading) operations. Data Voyager imports ERStudio data models to validate database designs and build robust data editing tools by generating and distributing Java and web-based applications in four steps
  • Support for Numerous Databases: many popular SQL and desktop databases including:
    • Oracle 7.3 , 8.x & 9i
    • Sybase System 11.9.2 & 12.x
    • Microsoft SQL Server 6.5, 7 & 2000
    • IBM DB/2 Universal Database 4.x, 5.x, 6.x & 7.x for Open Systems, OS/390 & AS/400 4.5
    • Informix OnLine and SE
    • SQL Anywhere and Watcom SQL
    • InterBase 4
    • Microsoft Access 2.0, 95, 97 & 2000
    • Microsoft Visual FoxPro.

ER/Studio - System Requirements

  • Microsoft Windows 98, NT 4, 2000 or XP
  • 100 MB of hard disk storage
  • 256 MB of RAM recommended
  • Client connectivity utilities required for native connectivity to Oracle, DB2 (including AS/400), Sybase and SQL Server
  • A supported ODBC driver is required for ODBC connectivity.

Write a review

Tags: er/studio , code , tools
We use cookies and other similar technologies to improve your browsing experience and the functionality of our site. Privacy Policy.