Released: Oct 12, 2022

Actualizaciones en 19.3

Características

• Added support for Google BigQuery data warehouse - This functionality allows you to reverse engineer a live database, import BigQuery SQL files, and generate both SQL DDL code for new databases and also ALTER scripts through the Compare/Merge tool. This new functionality leverages existing MongoDB and JSON file support, where ER/Studio transforms between relational Logical models to hierarchical Physical models, repeatably handling nested objects to take advantage of BigQuery...

Released: Jun 1, 2022

Actualizaciones en 19.2

Características

• Added support for MongoDB 4.x - This release includes tolerance support for MongoDB 4.0-4.4.
• Added SCRAM authentication option as default for MongoDB.
• Added support for importing JSON Objects from JSON documents - ER/Studio Data Architect now lets you create a data model by importing JSON files using a JSON document, in .json or .txt format. Importing these files allows you to create a MongoDB physical model or JSON Instance physical model.
• Added support for switching a MongoDB...

Released: Nov 16, 2021

Actualizaciones en 19.1.1

Correcciones

• Resolved the View Validation Results window scroll issue.
• PostgreSQL CHAR/VARCHAR is no longer off by four bytes when reverse-engineering.
• Import from SQL Script for Snowflake now handles UNBOUNDED, CLUSTER BY.
• Resolved an issue with the Macro functions on Model object lists.
• Long object names now are supported for PostgreSQL reverse-engineer.
• PK constraints now are properly imported from SQL on SQL Server.
• DDL now is generated for sequences without schema names.
• Reverse-engineering...

Released: Aug 1, 2021

Actualizaciones en 19.1

Características

• Added support for the following Oracle 12c and later features:
  • External tables - External tables allow Oracle to query data stored outside of the database in flat files. Use the Table Editor option to designate an external table and gain access to the External Table Properties dialog for further definition of the table.
  • Added support for saving varchar size units as BYTE or CHAR for physical models.
  • Subpartitioning by RANGE - Range partitioning distributes data based on a given...

Released: Jun 4, 2021

Actualizaciones en 19.0.0

Características

• Added support for Microsoft Azure Active Directory Password authentication method.
• Allows users to log in to Team Server when logging into Repository.
• Allows users to relate Business Terms with ER Objects.
• Added support for the 'where' clause for Microsoft SQL Server and Microsoft Azure SQL DB filtered index.
• Added support for the ‘Columnstore’ indexes for SQL Server 2012.
• Added support for Spatial Indexes for SQL Server and Azure SQL DB.
• Allows users to define table and index...

Released: Nov 6, 2020

Actualizaciones en 18.5

Características

• Added a new ribbon-based user interface for ease of use. Available actions are now located on ribbon bars for:
  • Diagram - Includes the functions related to creating and maintaining a data model diagram, such as editing, formatting, and viewing.
  • Insert - Includes the functions related to placing graphical objects onto a diagram, divided into Logical, Physical, and Data flow types.
  • Model - Includes the functions related to managing the model as a whole, including generating a...

Released: Sep 19, 2020

Actualizaciones en 18.4

Características

• Added new Datatype Mappings File Merge tool - This utility allows you to merge into the latest ER/Studio version all user-defined logical and physical datatypes and their mappings from previous versions and resolve any duplication.
• Added support for Snowflake - ER/Studio Data Architect and Team Server/Repository now support Snowflake database platform.
  • ER/Studio supports:
    • Creating and Editing:
      • Procedures
      • Functions
      • Database Users
      • Database Roles
      • Database Schemas
      • Sequences...

Released: May 22, 2020

Actualizaciones en 18.3

Características

• Core product support for the latest versions of PostgreSQL.
• Added the ability to send email notifications when an object that a user is following has changed.

Released: Dec 6, 2019

Actualizaciones en 18.2

Características

Extensive support for Amazon Redshift cloud data warehouse:

• Access Redshift via platform-specific ODBC interface.
• Includes all core features, such as forward and reverse engineering, DDL and ALTER script generation, and compare and merge.

Addition of several MetaWizard model import bridges:

• OMG UML 1.x XMI 1.x
• OMG UML 2.x XMI 2.x
• Borland Together (via UML 2.x XMI)
• CA Component Modeler 4.x (via UML 1.x XMI)
• Microsoft Office Visio UML Class Diagram (via UML 1.x XMI)
• NoMagic...

Released: Aug 22, 2019

Actualizaciones en 18.1

Características

• Improves conflict resolution when checking models into the repository.
• Several usability improvements when working with Business Data Objects (BDO).
• Usability improvements in object editors.
• Compare and merge improvements.
• 5 new MetaWizard bridges.
• Installation improvements.
• Upgrades codebase to Microsoft Visual Studio 2017 to enable future enhancements.