Azure repository support​

Until now, Dataedo supported file and SQL Server based repository.

In 7.0.3 beta, we're adding support for storing repository in Azure SQL Database.

Note that Azure repository support is a work in progress. It is stable, but requires more preparation than usually.

Click here to find out more.

Improvements and bug fixes​

Import improvements​

• DBMS list during import is now sorted alphabetically

• Fixed an issue in Oracle procedure script import using Select any dictionary privilege

ERD improvements​

• Fixed an issue with editing relation on an ERD

• Removed Add relation button on ERD - to add a relation use the right click context menu

HTML export improvements​

• Added relation title and relation name caption in HTML export on vertical screens

• You can now alter HTML favicon in custom templates

Other improvements​

• Paste in bulk add columns of manual table design option now ignores empty lines

• Connection to SQL Server 2005 now displays a proper warning

• Search now also checks object's scripts

• Fixed an issue with Upgrade message wrongly appearing in Lite edition when clicking on navigation tree

• Reworked right click menu in navigation tree

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 and use separate configuration files.

Snowflake support​

In 7.0.2 beta we have added support for Snowflake database.

Find out more in documentation.

Under development:​

• Unique constraints names and tables

• Relations names and tables

• Splitting function arguments into separate lines

Known limitations​

• Snowflake’s INFORMATION_SCHEMA currently doesn’t contain data on unique constraints and foreign keys columns and Dataedo doesn't import it. We will add this to import once Snowflake adds it to the metadata.

• There’s a similar limitation with object dependencies.

Requirements​

To connect you need to install Snowflake ODBC connector:

https://docs.snowflake.net/manuals/user-guide/odbc-windows.html

Amazon Redshift support​

In 7.0.2 beta we have added support for Amazon Redshift.

Find out more in documentation.

To connect you need to install Amazon Redshift ODBC connector:

https://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html

Percona Server for MySQL support​

Until now in schema import now we used the same option for MySQL and Percona Server for MySQL. In 7.0.2 you can choose the exact DBMS you're actually using.

Learn more in the documentation.

Manual documentations​

While we are constantly working on including more data sources in Dataedo, we understand that at any given time some will be unsupported.

To fix this, from Dataedo 7.0.2 you can add create your documentation and tables from within the app.

Later on, when we add support for your data source, you will be able to just click connect and import the actual structure from your database without losing your descriptions.

Manual tables in existing documentations​

Additionally, you can now add tables not existing in your database to the documentation.

Just click the Add table button in the ribbon, or right click the documentation you want to create the table in and you can define your new table.

User defined columns in existing tables​

You can also add user defined columns to an existing table. Just select your table and click the Design table button in the ribbon, or right click the table you want to edit and choose Design table.

Reordering columns in existing tables​

In many DBMSes altering the order of columns in a table is not trivial. However logical column ordering can greatly improve understanding of their purpose.

From Dataedo 7.0.2 you can alter the order with which columns are displayed in your documentation.

Improvements and bug fixes​

• Improved ERD loading speed

• Fixed an issue with deselecting objects while renaming

• Fixed an issue with navigation tree context menu

• Beta 7.0.2 includes all of Dataedo 6.2 features and fixes

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 and use separate configuration files.

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