Release Notes

From TeamServer ER/Studio
Jump to: navigation, search

Go Up to Getting Started with Team Server


Thank you for using Team Server, the award-winning web-based tool to access, search, edit and manage enterprise metadata. Team Server is a model and metadata collaboration platform that provides greater meaning, understanding and, context to enterprise data. Data professionals, developers, and business analysts gain better comprehension and compliance using integrated model, metadata and collaboration tools.

These Release Notes contain important information that might not appear in the Team Server documentation. We recommend that you read this page in its entirety. If you are seeing this information offline, you may find more updated information of the current version of these notes on the online documentation.

Enhancements/Bug Fixes and Known Issues

Bugs Fixed in ER/Studio 19.3.4

ERS-30103 Add JSON modeling properties to COM API.
ERS-30065 PostgreSQL Table-level constraints generated incorrectly.
ERS-30042 JSON number field constraints must allow decimal values.
ERS-30040 JSON Strings with a format should not include width.
ERS-30039 Cannot set string without width in JSON.
ERS-30038 JSON format"date=time" incorrect syntax.
ERS-30037 Ability to select number of items in an array in JSON - minItems & maxItems.
ERS-30027 Attachment binding disappears from foreign Key when deleting other attributes.
ERS-29882 Reverse engineer schema selection button is disabled when trying to select an owner in Compare and Merge Utility wizard.
ERS-29861 CREATE OR REPLACE VIEW statement is generated insrtead of CREATE OR ALTER VIEW in the Alter Script after Compare and Merge against the SQL Server database.
ERS-29417 Timestamp(0) showing up as Timestamp without precision when generating database.
ERS-29414 Numeric(0,0) columns are being reversed as NUMERIC(10,0).

Bugs Fixed in ER/Studio 19.3.3

ERS-29962 Cannot see datasets while reverse engineering Google BigQuery.
ERS-29426 Role names are not propagated for Containment lines.
RWP-9966 Batch publishing diagram fails.
RWP-9919 Team Server displays <!%_EMBT_REPO_OVERFLOW_%!> for attachments where the text is too long.
RWP-9757 Hide the Foreign Key property for Containment Relationships.
RWP-9631 Provide OKTA SSO support for Team Server log in.
RWP-9521 Security improvements.
RWP-9218 Parent and Child Entities to be listed for Relationship lines.
RWP-8992 REST API performance improvements.
RWP-7996 Incorrect user email address for LDAP Single Sign-On users.
RWP-7973 Provide Azure AD SSO support for Team Server log in.


Bugs Fixed in ER/Studio 19.3.2

ERS-30322 Datatype lengths not generated from Domains for JSON models.
ERS-29864 Naming standards template not applied properly during Generate Physical Model for JSON.
ERS-29796 JSON string becomes NVARCHAR despite datatypes mappings.
ERS-29795 Fields do not inherit correct width from Domain for JSON.
ERS-29568 Bad characters in Descriptions making JSON Schema invalid.
RWP-9897 Collibra sync fails for large number of Asset Properties on Collibra side.
RWP-9826 Cannot create logical-to-physical relationships in Collibra.
RWP-9606 Security improvements.

Bugs Fixed in ER/Studio 19.3.1

ERS-30606 ENH: Use drop-down list for logical or physical names when setting up a transformation in a data lineage.
ERS-29609 Reverse engineer SQL Server views: Definitions are truncated to 8000 characters.
ERS-29597 Single-platform license for JSON does not show JSON Instance platform.
ERS-29567 Bound reference values not appearing in enum in JSON schema.
ERS-29274 Unique constraint name missing when generating the DDL.
ERS-29247 Views appear as invalid after upgrading to 19.1.
ERS-29238 SQL Import datatypes not parsed when brackets are in DDL.
ERS-29237 Entity Name box issues.
ERS-29231 Creating a database does not generate NOT NULL for IDENTITY.
ERS-29219 ERDA crashes when reverse engineering scalar-valued function in SQL Server 2016 SP2.
ERS-29146 Import from SQL file causes timestamp columns to appear as CHAR(10).
ERS-28941 Compare and Merge, and Temporal Tables issues.
ERS-28036 Need ability to model a JSON structure containing embedded objects.
RWP-9804 Cannot move from General Settings page in Collibra Integration.
RWP-9681 WhereScape 3D exports bad XML.

Bugs Fixed in ER/Studio 19.3

ERS-29609 In the Reverse-Engineer SQL Server Views, definitions are truncated to 8000 characters.
ERS-29597 Single-platform license for JSON does not show JSON Instance platform.
ERS-29567 Bound reference values not appearing in Enum in JSON Schema.
ERS-29274 Unique constraint name missing when generating the DDL.
ERS-29247 After upgrading to version 19.1, views are showing invalid.
ERS-29238 SQL Import datatypes not parsed when brackets are in DDL.
ERS-29237 Entity Editor Entity Name field does not allow scrolling to the right.
ERS-29231 Creating a database does not generate NOT NULL for IDENTITY.
ERS-29146 Import from SQL file causes timestamp columns to show up as CHAR(10).
ERS-28941 Compare and Merge does not return Temporal Tables data correctly.

Bugs Fixed in ER/Studio 19.2.2

RWP-8110 Resolves an issue causing HTML code to appear in the Definition field when exporting reports to .pdf or .xlsx.
RWP-8914 Resolved an issue preventing non-admin users from saving reports.
RWP-9472 Improved the error message displayed when an unauthorized user attempts to harvest Business Terms.
RWP-9573 Resolved an issue causing Pentaho reports to return no results for Glossary Objects.
RWP-9606 Resolved existing Cross-site Scripting (XSS) vulnerabilities.
RWP-9607 Added code to ensure authentication in requests for state-changing operations.
RWP-9650 Removes the user prompt and automatically uses the existing backup when upgrading from ER/Studio 19.1 to 19.2.
RWP-9707 Resolves an issue preventing users from publishing to Collibra due to a unified attribute.

Bugs Fixed in ER/Studio 19.2

ERS-23340 Supports importing JSON Objects from JSON documents.
ERS-28657 Adds support for MongoDB 4.x.
ERS-28658 Improves Logical to Physical conversion to MongoDB.
ERS-28738 Adds a relationship validity check and display.
ERS-28741 Supports repeated Elements in hierarchical Models.
ERS-28743 Improves compare/merge options to MongoDB Physical Models.
ERS-28744 Allows users to set data types during In Place Editing.
ERS-28745 Updates the MongoDB Advanced Login Options dialog so that SCRAM is the default Authentication Type.
ERS-28746 Adds Denormalization tools for hierarchical Objects.
ERS-28747 Adds source code to the Object Editor DDL tab.
ERS-28748 Supports switching a MongoDB object's class between Collection and Nested Object.
ERS-28751 Supports JSON Instance files.
ERS-28772 Provides a roll-up view for hierarchical Models.
ERS-28794 Provides parent/child Entity switch icon in Table Editor.
ERS-28811 Allows users to switch between MongoDB and JSON Instance hierarchical platforms.
ERS-28812 Provides a roll-up Contained Objects view for hierarchical Models.
ERS-28813 Provides Expand/Contract icons for roll-up views.
ERS-28814 Provides keyboard entry tools for roll-up views.
ERS-28816 Supports Move function for roll-up views.
ERS-28895 Provides Repeated Object icons for nested Objects.
RWP-8872 Corrects the format when displaying bold/italic content in Glossary definitions.
RWP-9057 Improves Oracle performance by automatically clearing data from the SYNC_OBJECT_POOL table before running certain procedures.
RWP-9111 Introduces the Business Glossary Report.

This report provides a list of Glossaries with descriptions and Business Terms related by the "is part of" and "is related to" relationships to one or more Parent Glossaries.

RWP-9217 Resolves an issue causing some migrations to ERTS 18.5 to fail due to a large amount of CLOB to CHAR or BLOB to RAW data.
RWP-9292 Resolves an issue preventing Attributes linked to Business Terms via a Domain from appearing in the Related ER Objects view.
RWP-9300 Adds TLS encryption to the JDBC connection from Team Server to an Oracle database.
RWP-9307 Resolves an issue causing some diagrams to lose relationship lines in the Team Server Interactive Viewer.
RWP-9309 Resolves an issue preventing all data products supported by ERDA from appearing in the Connection Properties section of Data Source Objects.
RWP-9351 Resolves an issue causing GET calls on SQL Server repositories to fail in diagrams with many universal mappings.
RWP-9366 Adds Delete Custom Property functionality to the Available Custom Properties section of the Managed Attributes page.
RWP-9379 Renames the Data Sources tab to Data Catalog and provides a default hierarchical tree view of deployed data assets.
RWP-9398 Removes the Found In tab and filter option from the Related ER Objects section of the Business Term page and the Related Terms section of the ER Object page.

Includes an Only show recommended objects checkbox in the Relate tab to allow users to filter the available objects to those that would normally appear in the Found In tab.

RWP-9399 Corrects the format when displaying Business Term definitions in the ERDA Glossary and Business Term Selector dialogs.
RWP-9404 Adds the ability to map attachment properties to properties in Collibra.
RWP-9406 Removes Test Connection button from Data Sources tab (now Data Catalog tab).

Adds the Hide Login Credentials checkbox to My Settings > Admin to prevent the Login Credentials section from appearing in the main view.

RWP-9421 Removes Oracle 11g as a supported backend database for Team Server/Repository.
RWP-9424 Adds a new Data Asset Object Type.
RWP-9438 Improves Oracle performance by updating Team Server application code and SQL.
RWP-9439 Resolves an issue causing carriage return characters to appear in rectangular shapes in Team Server.
RWP-9450 Adds the ability to publish Entity-to-Table relationships in Collibra.
RWP-9458 Introduces new Settings General and Property Mappings pages to manage the export of models to WhereScape.

Includes a new Permissions group for WhereScape Administration.

RWP-9459 Adds a new export utility for WhereScape.
RWP-9476 Improves Collibra error handling by adding more collibra.log file entries when a failure occurs and providing better error messaging.
RWP-9499 Adds more built-in properties for Columns and Attributes to support Collibra integration.
RWP-9580 Improves Foreign Key Column support for ERDA data models stored in the Repository.

Bugs Fixed in ER/Studio 19.1.1

ERS-27243 Resolves the View Validation Results window scroll issue.
ERS-28314 PostgreSQL CHAR/VARCHAR is no longer off by four bytes when reverse-engineering.
ERS-28515 Import from SQL Script for Snowflake now handles UNBOUNDED, CLUSTER BY.
ERS-28809 Resolves an issue with the Macro functions on Model object lists.
ERS-28889 Long object names now are supported for PostgreSQL reverse-engineer.
ERS-28921 PK constraints now are properly imported from SQL on SQL Server.
ERS-28923 DDL now is generated for sequences without schema names.
ERS-28942 Reverse-engineering columnstore indexes with more than 32 columns completes appropriately.
ERS-28951 Import from SQL Script for Snowflake handles NOT NULL DEFAULT.
ERS-28952 Import from SQL Script for Snowflake handles DESC keyword.
ERS-28957 Improved Procedures/Triggers syntax handling for SQL Server.
RWP-9458 Created UI for WhereScape 3D integration parameters.
RWP-9459 Created export facility for WhereScape 3D integration.
RWP-9499 Added more built-in properties for Collibra integration for columns and attributes.

Bugs Fixed in ER/Studio 19.1

ERS-10996 Includes support for external tables in Oracle 12c and later.
ERS-13564 Includes support for interval partitioning in Oracle 11g and later.
ERS-18310 Includes support for saving varchar size units as BYTE or CHAR for physical models in Oracle 12c and later.
ERS-22355 Includes support for reference partition in Oracle 11g and later.
ERS-25176 Includes support for partitioning by RANGE in Oracle 12c and later.
ERS-25281 Resolved an issue causing an invalid token error for an embedded pound (£) symbol.
ERS-25362 Updates the compare/merge script generation to create the FK after the parent table.
ERS-25414 Updates the Oracle parser to handle function calls without parameters and parentheses.
ERS-25797 Updates the INTERVAL DAY(0) datatype in the live database to no longer be reversed as INTERVAL DAY(11).
ERS-26416 Resolves an issue with Alter SQL generated during extended alter for constraints.
ERS-26739 Includes support for identity columns in Oracle 12c and later.
ERS-27129 Resolves the Oracle create user DDL syntax.
ERS-27180 Updates compare/merge to now generate the correct extended alter SQL in specific case.
ERS-28173 Resolves an issue with parsing LISTAGG in the Materialized view.
ERS-28235 Populate the file name for GetFilePath() in macros.
ERS-28444 App crashes when a user performs a compare and merge against live DB.
ERS-28625 Retains the Quick Access toolbar and styles persistent when a style is chosen.
ERS-28780 Correctly reverse engineers certain views from Redshift.
ERS-28792 Resolves an issue so the user is no longer prompted to override the Business Terms Value when Team Server is not configured.
ERS-28867 Resolves an issue causing some users to experience a crash when upgrading a diagram during a CTE update.
ERS-28916 Creates Primary Keys for PostgreSQL when generating a Physical Model.
RWP-9114 Allows the Team Server admin to synchronize Collibra integration Terms.
RWP-9071 Allows the Team Server admin to hide menu items based on user group.
RWP-9083 Includes the ability to specify a backup folder location upon uninstall.
RWP-9093 Includes support for a hyperlinked URL on a Term Custom Attribute.
RWP-9115 Allows the Team Server admin to publish Logical and Physical models from Team Server to Collibra with mappings of related Terms.
RWP-9207 Updates the user interface colors of tabs to be in line with other similar items.
RWP-9230 Allows the Team Server admin to add custom properties to selected objects without using Enterprise Data Dictionary attachments or the Repository.
RWP-9249 Replaces current Java version with AdoptOpenJDK 11.
RWP-9264 Allows the Team Server admin to manage Collibra integration settings and configuration.
RWP-9329 Allows viewing of attributes in ER Objects.

Enhancements/Bug Fixes in ER/Studio 19.0.1

ERS-25202 Supports additional features for SQL Server Temporal Tables.
ERS-27441 Adds quotation marks to the Field Names when generating the database JSON.
ERS-28256 Adds the Universal Mappings button to the Repository ribbon.
ERS-28313 Adds the Diagram Properties button to the Model ribbon.
ERS-28386 Allows user to switch between open files.
RWP-8839 Adds a graphical relationship component.
RWP-8926 Support Azure SQL DB as backend Repository/Team Server database.
RWP-8941 Modifies the Business Term object page to view ER Objects graphically.
RWP-9067 Allows bulk harvesting of Business Terms and Relationships from Logical Models.
RWP-9077 Resolved an issue causing reports to fail for some users after upgrading from ERTS 18.1 to ERTS 18.3.
RWP-9096 Allows simple relationships ("is attribute of," "is type of," "is synonymous with") between Terms.
RWP-9097 Allows complex relationships ("relates to" and additional properties) between Terms.
RWP-9101 Adds Parent Glossary advanced search option in the Business Terms list.
RWP-9102, RWP-9103, RWP-9104, RWP-9105 Modifies the Business Term object page to:
  • include a subpage for Attribute relationship
  • include a subpage for Synonym relationship
  • include a subpage for Relates To relationship
RWP-9108 Improves Glossary deletion by allowing users to select whether they want to delete child Business Terms or leave the parent Glossary blank.
RWP-9109 Modifies the CSV import/export to support relationships.
RWP-9110 Updates the API to support Business Glossary with new relationships.
RWP-9112 Allows user to turn off Linked Terms using the Business Term Settings available from the Admin menu.
RWP-9140 Supports new ERDA features for additional platforms (Microsoft Azure Synapse Analytics, Microsoft SQL Server 2019, MySQL 8.x).
RWP-9148 Adds the modifiedAt property for all ER Objects including sub-objects returned in queries for parent objects.
RWP-9166 Modifies the Business Term object page to view related ER Objects graphically.
RWP-9167 Resolves an issue affecting the Where Used tab on the Object Detail page.
RWP-9169 Allows users to turn off standard properties of a Business Term.
RWP-9210 Modifies the New Term dialog to include a Parent Glossary field.

Enhancements/Bugs Fixes in ER/Studio 19.0.0

ERS-10973 Supports Inheritance Relationships for PostgreSQL.
ERS-14719 Supports SQL Server CTE Views.
ERS-16141 Supports the 'where' clause for SQL Server and Azure SQL DB filtered index.
ERS-11888 Supports extended properties for SQL Server Tables and Columns.
ERS-18591 Allows users to define table compression for SQL Server and Azure DB.
ERS-19263 Supports Spatial Indexes for SQL Server and Azure SQL DB.
ERS-20179 Allows users to define index compression for SQL Server and Azure DB.
ERS-23385 Supports the 'Columnstore' index for SQL Server.
ERS-25202 Allows users to model temporal tables in SQL Server.
ERS-25783 Added an option to select Azure Active Directory Password authentication support.
ERS-27836 Allows TLS between Data Architect and Repository.
ERS-27986 Supports the 'relates to' relationship between Business Terms and Objects.
ERS-27991 Supports Azure Synapse Analytics.
ERS-28017 Supports SQL Server 2019.
ERS-28136 Supports MySQL 8.0.
ERS-28160 Allows users to generate MongoDB model output as plain JSON.
ERS-28211 Combined Repository and Team Server login features into a single dialog box.
RWP-9095 Allows namespacing of Terms to parent Glossary ("is part of").
RWP-9099 Updates the Glossary page to show Terms that are namespaced to that Glossary and updates Relate options.
RWP-9100 Modifies the Terms List page to include the parent Glossary name in parentheses after each Business Term name.
RWP-9106 Modifies the Business Term Object page to show the parent Glossary relationship.
RWP-9107 Modifies the ER Objects pages to show the parent Glossary relationship.
RWP-9170 Resolves an issue preventing a user from saving edits to a Business Term when two or more terms have the same name but different Entity Types.

Known Issues

ERS-29737 Max length of strings and other datatypes not handled in Google BigQuery.
ERS-29748 The Description column text from Google BigQuery isn't displayed in the Definition tab after reverse engineering for RECORD fields.
ERS-29793 Function with description fails when reverse engineering in Google BigQuery.
ERS-29805 Blank Alter script is generated when you attempt to compare or merge a table without a clustering key against a live database where a table with a clustering key exists.
ERS-29877 JSON Instance file generation produces invalid JSON.
ERS-29881 An Inheritance relationship is created instead of an Identifying relationship in the Logical model after adding the relationship from the Data Model tree.
ERS-29882 The Compare and Merge Utility wizard reverse-engineer schema selection button is disabled when trying to select an owner.
ERS-29906 JSON Schema file generation produces invalid JSON Schema for ExclusiveMinimum field.
ERS-29913 Data from a previous Check Out dialog appears when attempting to check in a diagram.
ERS-29914 Text fields that should be hidden appear when navigating from Native/Direct Connection to ODBC in the Reverse-Engineering wizard.
RWP-9862 Rolled-up view for JSON model does not display properly in Submodel image.
RWP-9874 Term definition with different font styles is displayed in HTML format in the Business Term Selector wizard.
RWP-9878 Diagrams listed alphabetically but it is case sensitive on the Model Selection page when publishing diagrams for WhereScape.
RWP-9884 Incorrect friendly_name appears in Team Server in the DDL section after publishing a diagram.

IDERA Technical Support

If you have a valid maintenance contract with IDERA, Inc., our Support team will assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of IDERA, Inc. products to download free software upgrades during the active contract period.

Evaluators receive free technical support for the term of their evaluation. To download evaluations of IDERA, Inc. products, go to http://www.idera.com.

To contact the Support team, go to the Support page.

See Also