Adding objects to ERD from navigation tree​

Previously, to add an object to ERD you've had to use the object list on the right side of the screen. This could be cumbersome, especially when you've wanted to add objects from different documentations.

Now you can just drag any object you want to add from the navigation tree on the left side of the screen.

You can also drag entire branches to an ERD, eg. drag an entire module to the ERD to add all the tables and views included in it.

Adding objects from a different documentation to ERD​

In Dataedo 6 it was possible to add objects from different documentations to an ERD only if they had relations to existing objects.

Now you can add any object from any documentation to an ERD using the drag & drop feature described above.

Improvements

Import​

• Import from Oracle now uses DBA_ views instead of ALL_ views when user has SELECT ANY DICTIONARY privilege

Repository connection​

• Repository connection errors now have better descriptions

Performance​

• Improved loading speed for ERD object list

• Improved loading speed for object lists in the documentation tree

HTML export​

• Changed list presentation in rich text fields to make it more in line with Editor

Bug fixes

Import​

• Fixed multiple issues with import from SQL Server instances with case sensitive collations

Editor​

• Right clicking empty space in documentation tree no longer unselects current objects, which solves multiple issues

• Triggers deleted from source database are now properly greyed out

• Edit relation button is now only displayed when there is a relation to edit

Custom fields​

• Fixed an issue caused by editing multiple custom fields from documentation tree object list

HTML export​

• Fixed an issue with exporting HTML when having a single database imported multiple times in the same repository

Separate configuration file from Dataedo 6.0​

Dataedo 7.0.1 beta uses a separate configuration file from Dataedo 6, so you won't connect to your production repository by mistake, and both your current Dataedo 6 license and Dataedo 7 trial license can coexist.

PostgreSQL support preview​

In Dataedo 7 we're working on support from new data sources.

In 7.0 beta we have added initial support for long awaited PostgreSQL.

You can connect and import metadata of:

• tables

  • table columns

  • primary keys

  • relations

  • triggers

• views

  • view columns

  • view script

  • view dependencies

• materialized views (shown in the same branch as standard views)

  • materialized view script

• functions

  • function parameters

We will support PostgreSQL from version 9.3 onwards.

If you run into any issues with connecting or importing from Postgres using the beta version, please do contact us.

Known issues we are still working on:​

• length of data type is not imported

• materialized views use the same icon as standard views

• materialized view columns are not imported

• rules are not imported

• trigger functions are grouped with standard functions

• dependencies are imported only from views

Repository changes​

Dataedo 7.0 beta requires a repository upgrade.

Note that upgrading a repository to version 7.0 will make it incompatible with version 6.

Testing beta​

Please create a separate repository for testing Dataedo 7.0 beta.

You can install Dataedo 7.0 programs in parallel with existing Dataedo 6. Both will be in separate folders.

Dataedo 7.5.4 (September 26th, 2019)​

• Fixed an issue with importing SQL Server relations and dependencies of objects with the same name but different schema

Find out more

Dataedo 7.5.3 (August 29th, 2019)​

• Bug fixes and UI improvements

Find out more

Dataedo 7.5.2 (August 13th, 2019)​

• Added support for Oracle 18 and 19

• Bug fixes and UI improvements

Find out more

Dataedo 7.5.1 (July 4th, 2019)​

• Fixed an issue where db_owner role was checked incorrectly during server repository upgrade

• Fixed issues in Oracle, SQL Server and MySQL import

• Bug fixes and UI improvements

Find out more

Dataedo 7.5 (June 13th, 2019)​

• Data Classification (Enterprise)

• Up to 100 custom fields (Enterprise)

• UI column locking

• Comment DDL script generation

• Bug fixes and UI improvements

Find out more

Dataedo 7.4.2 (May 16th, 2019)​

• Business Glossary Export (Enterprise)

• Connection with no password

• Bug fixes and UI improvements

Find out more

Dataedo 7.4.1 (April 17th, 2019)​

• Bug fix

Find out more

Dataedo 7.4 (April 16th, 2019)​

• Business Glossary (Enterprise)

• Redesigned HTML export

• Bug fixes and UI improvements

Find out more

Dataedo 7.3.1 (March 25th, 2019)​

• Bug fixes and UI improvements

Find out more

Dataedo 7.3 (March 14th, 2019)​

• ODBC data source (beta feature)

• Copy descriptions (beta feature)

• Column view

• Personal connection

• MySQL 8 support

• New table and procedure types

• Mac beta package improvements

• Bug fixes and UI improvements

Find out more

Dataedo 7.2.2 (February 13th, 2019)​

• MacOS support beta

• Bug fixes and UI improvements

Find out more

Dataedo 7.2.1 (January 15th, 2019)​

• Fixed a bug in HTML export where object title scrolled incorrectly

• Fixed a bug where Dataedo required .Net 4.5 instead of .Net 4.0

• Bug fixes and UI improvements

Find out more

Dataedo 7.2 (December 6th, 2018)​

• Schema change tracking

• New custom field types

• Description suggestions

• Paste to multiple cells

• DB2 Cloud support

• Bug fixes and UI improvements

Find out more

Dataedo 7.1.1 (October 1st, 2018)​

• Fixed an issue with updating documentation on upgraded repositories

• Fixed an issue with connecting to postgres 10.4 on Amazon AWS

• Fixed an issue with importing from Db2 Cloud

• Fixed issues with HTML export in multiple files template

• Bug fixes and UI improvements

Find out more

Dataedo 7.1 (September 13th, 2018)​

• IBM Db2 support

• Filtering and quicksearch

• Oracle - direct connection

• Oracle - packages

• Repository connection encryption

• Suggested entities in ERDs

• Easier and quicker manual relations

• Import and read speed improvements

• Bug fixes and UI improvements

Find out more

Dataedo 7.0.4 beta (July 31st, 2018)​

• Azure repository support

• Bug fixes and UI improvements

• Search in HTML export

• Cross documentation modules

• Materialized view support

• New table subtypes for user-defined tables

• Manual table designer reworked

• Support for Amazon Aurora PostgreSQL

• Multiple ERD improvements

• Bug fixes and UI improvements

Find out more

Dataedo 7.0.3 beta (June 8th, 2018)​

• Azure repository support

• Bug fixes and UI improvements

Find out more

Dataedo 7.0.2 beta (May 29th, 2018)​

• Support for Snowflake

• Support for Amazon Redshift

• Support for Percona Server for MySQL

• Manual documentations

• Manual tables in existing documentations

• User defined columns in existing tables

• Reordering columns in existing tables

• Bug fixes and UI improvements

Find out more

Dataedo 7.0.1 beta (April 20th, 2018)​

• Fixed key management

Find out more

Dataedo 7.0 beta (April 19th, 2018)​

• Support for PostgreSQL

Find out more

User defined dependencies​

You can now add a dependency to any object's dependencies tab.

Just drag the objects you want to add the dependency on to either side of the dependencies tab.

Custom field search​

You can now search a specific custom field for a value, or use it as a filter when searching other fields.

In a repository containing custom fields, go to Search tab, click Add field, select the field you want to search and enter in any value.

This will find all fields with the entered value.

If you also put in a value in the basic search field, you will find only objects containing both that value and the value you've entered for the custom field.

One to one relations​

You can now specify relation cardinality both for imported and user defined relations. Just double click any existing relation (or use right click > Edit relation), then change the cardinality on FK side.

You can change cardinality in the same way for new relations.

Improvements

Import​

• Fixed an issue with PK being imported on wrong column in some rare cases in SQL Server

Server repository​

• Lite users can now create and access server repositories with names other than Dataedo

Editor​

• Fixed an issue with documentations from Azure databases not displaying schema

• Changed the message displayed when logging to a repository or file crated by a different version

• When creating a new relations, columns with with primary key on them are now suggested on PK side

• Closing the window when creating or editing user defined objects now asks whether the changes should be saved or discarded

• Pressing CTRL+S now saves changes made in most places

Dependencies​

• Fixed an issue with dependencies not linking to objects in multi schema Oracle documentations

Custom fields​

• Fixed an issue with Custom field names not refreshing on switching repository

• Fixed an issue with custom fields being uneditable on newly created, but not yet saved objects, like user defined relations or unique keys

• Fixed a crash caused by switching two custom fields names

• Fixed an issue where keyboard cursors behave differently in description field and custom fields

ERD​

• When making an area selection, ERD nodes that are going to be selected are now properly highlighted

Search​

• Search now also checks database name

HTML export​

• Opening an HTML export containing a single documentation causes it to automatically unroll it's details

• Added table title next to its name in places where it was missing

• Removed 'Dataedo' from exported documentation title

• Fixed an issue with unneeded line break in longer custom field names

• Changed list presentation in rich text fields to make it more in line with Editor

PDF Export​

• Fixed an issue with line breaks not exporting to PDF description or custom fields properly

Fixed an issue with ERDs losing link settings on documentation removal​

Previously, removing a documentation also restored ERD link settings to default for all other documentations, removing Show title, Show join condition, Hide relation and Link style setting. This issue is fixed in 6.0.4.

Azure SQL Data Warehouse support​

Dataedo 6.0.3 adds support for importing Azure SQL Data Warehouse schema. We've run tests in our environment, but we do know that it may not reflect real life production environments, so if you notice any issues with this feature please do contact us.

Split of DBMS list in schema import​

Until now in schema import now we used the same option for MySQL, MariaDB and Aurora, and another for both SQL Server and Azure. In 6.0.3 you can choose the exact DBMS you're actually using.

Improved relation reading speed from repository​

We've made some changes in the way relations are read in Editor. Dataedo is now better optimized to deal with tables containing 50+ relations, even on repositories hosted in Cloud.

Choosing columns displayed on an ERD​

Until now to change columns displayed on ERD you needed to edit nodes one by one. In 6.0.3 we've added an option to set displayed columns for the entire ERD with 3 choices - Show all columns (not recommended, as it causes too much clutter), Show key columns only and Hide all columns. After choosing the setting for the ERD, you can still edit columns shown from each table individually.

File Repository improvements​

• Fixed issue with opening file repository with ' in name or path

Editor improvements​

• Added Remove key button on the ribbon when relevant

• Fixed an issue with dependencies on the Uses side not being linked properly in a documentation with multiple schemas from Oracle

• Fixed an issue with dependencies when the same database was imported to multiple documentations

• Fixed an issue with editing an already removed object through search tab

Import improvements​

• Fixed dependencies import from Oracle when having a view and table with the same name in different case

• MariaDB import now properly displays values for computed columns from version 10.2.4

Export improvements​

• Fixed issue with PDF export where an empty page would be generated at the start of each module

• Fixed issue with exporting comments to Oracle when column name of a view included spaces

• Changed line spacing in HTML export to make it more in line with the editor

• Other slight changes to HTML export style

ERD improvements​

• Added an option to change columns displayed on ERD for all tables

• Selected nodes now have a thicker outline compared than previously

Dataedo 6.5 (December 18th, 2018)​

• Fixed an issue with MySQL import when using include filters

• Fixed an issue with extended property export when using illegal property name

• Fixed an issue with context menu not displaying correct options

• Bug fixes and UI improvements

Find out more

Dataedo 6.4 (September 20th, 2018)​

• Bug fixes and UI Improvements

Dataedo 6.3 (August 7th, 2018)​

• Bug fixes and UI improvements

Find out more

Dataedo 6.2 (May 17th, 2018)​

• Adding objects to ERD from navigation tree

• Adding objects from a different documentation to ERD

• Bug fixes and UI improvements

Find out more

Dataedo 6.1 (April 5th, 2018)​

• Ability to add user-defined dependencies

• Added custom fields in search

• One to one relations

• Fixes and improvements

Find out more

Dataedo 6.0.4 (February 26th, 2018)​

• Fixed bug with ERDs losing link setting on deleting documentation

Find out more

Dataedo 6.0.3 (February 22nd, 2018)​

• Added Azure SQL Data Warehouse support

• Split MariaDB, Aurora and Azure in DBMS list during import

• Improved performance of editor and export of relations tab

• Added global option to show/hide columns on ERD

• Bug fixes and UI improvements

Find out more

Dataedo 6.0.2 (January 22nd, 2018)​

• Custom field export to extended properties

• Improved update availability notification

• Bug fixes

• UI Improvements

Dataedo 6.0.1 (December 6th, 2017)​

• Dependency import fixes (may require forced reimport)

• PDF Export optimization

• Bug fixes

• UI Improvements

• Fixes of bugs and issues from betas

Dataedo 6 beta 2 (November 17th, 2017)​

• Dependency import fixes (may require forced reimport)

• PDF Export optimization

• Bug fixes

• UI Improvements

• Includes all fixes from current Dataedo 5 version

Dataedo 6 beta (September 28th, 2017)​

• Cross-database relations

• Custom fields

• Writing descriptions back to the database

• Exporting view and procedures scripts

• Exporting multiple documentations in one HTML

• Including multiple schemas in Oracle connection

• Improved FK view

• Improved publishing on Confluence

• Beta is based on version 5.2.4 and might include bugs already resolved in version 5