Search in HTML export​

One of the most requested features for exported documentation was search in HTML export.

We've now added a search bar checking object's schema, names and columns.

Cross documentation modules​

Previously, objects could only be added to modules within their documentation.

To better support cross database environments, you can now add object to modules from any documentation in your repository.

You can add objects from different documentations as usual, by dragging them from the navigation tree, from object lists one by one or in groups or by choosing modules on the object's description page.

Materialized view support​

In Dataedo 7, we're working on adding new object types which were not previously imported.

For Dataedo 7.0.4 beta we've added support for importing materialized views from Oracle and PostgreSQL. They will be visible in the Views folder with a new icon.

New table subtypes for user-defined tables​

When creating a user-defined table you can now specify it's subtype. It will have a new icon and will be marked as that type during export.

Manual table designer reworked​

We've made improvements to how Add table and Design table windows work. They should now be more responsive and easier to use.

Bulk add columns now better deals with copied empty lines and we've added a short note explaining how to use it.

ERD improvements​

We've made multiple improvements to our ERDs.

Add related tables​

You can now add all objects related to a node on an ERD by right clicking it and choosing Add related tables:

Hint related tables​

Objects related to selected tables on an ERD are now displayed in bold in Available entities list.

Adding new table​

Adding a new manual table on ERD screen now also adds it to the module.

Support for Amazon Aurora PostgreSQL​

Until now in schema import now we used the same option for PostgreSQL and Amazon Aurora PostgreSQL.

In 7.0.4 you can choose the exact DBMS you're actually using.

Learn more in the documentation.

Improvements and bug fixes​

General​

• Solved multiple errors that could lead to application crashing.

• Shortened repository upgrade time.

• Altered relations now properly display their current columns.

• Object names can now be copied by using ctrl+c.

• Previously, descriptions equal to object name did not count for the progress bar. Now they count the same as any described objects.

• DBMSes specialized in data warehousing (Redshift, Snowflake, Azure Data Warehouse) are no longer available in Lite (free) edition.

Connection​

• Previously, users with correct database privileges had to have license assigned through Administration Console to connect to a repository. Now they log in with an automatic Lite license.

• You can now log to a repository from any number of machines. Until now you were limited to two machines per user daily.

• Recent connections are now imported on version upgrade. Previously, a new major version started with a fresh recent file.

Import​

• PostgreSQL import now correctly reads column lengths and descriptions.

• Fixed an issue with Snowflake import with ignored objects specified.

• Functions' returned value is now now correctly imported from PostgreSQL.

• Dataedo command files can now store custom field to extended property mapping.

Export​

• Greatly improved export time when exporting parts of the documentation.

• Greatly improved the initial loading time of HTML documentation in Single file template.

• Fixed a crash caused when skipping an object type while having dependencies to that object type during export.

• Fixed an issue with exporting unicode characters to SQL Server extended properties.

• Fixed an issue with opening the exported file with no default application registered for file extension.

Support​

• Added an option to quickly request a new data source during import.

• Support menu in the ribbon has been reworked. It now links to our forums and support systems straight away.

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