Improvements and bug fixes​

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

Improvements and bug fixes​

• Fixed an issue with Oracle import checking access to DBA tables

• Fixed an issue with adding business glossary links on screens with display scaling

• Fixed an issue with connecting to SQL Server without encryption support (e.g. localDB)

Improvements and bug fixes​

• Added support for Oracle 18 and 19

• Fixed an issue with HTML export from file or Azure repository

• Fixed an issue with Redshift import

• Fixed an issue with unique key column ordering

• Fixed an issue with copying data to clipboard in parallel with other applications accessing it

Improvements and bug fixes​

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

• Fixed a graphics issue when switching between objects from the search tab

• Fixed an issue with marking relations as deleted on SQL Server

• Fixed an issue with saving the SID/Service name connection setting in Oracle

• Fixed an issue with excluding objects from import on MySQL

• Fixed an issue with hiding a newly created relation on an ERD

• Multiple other fixes and UI improvements

Data Classification (Enterprise)​

Manually classifying data based on their sensitivity is an arduous task. To make it easier for our Enterprise users, we've added the Data Classification feature to Dataedo 7.5. When run, it suggests column classification based on their name, title, linked business glossary terms, and classification of other columns with the same name.

Docs: Automated Data Discovery and Classification

Up to 100 custom fields (Enterprise)​

Some of our Enterprise users signaled that 40 custom fields limit may actually be to low for them. We're increasing it in Dataedo 7.5 - now Enterprise users can add up to 100 custom fields.

UI column locking​

With so many custom fields, keeping track of which row you're looking at may be complicated. To solve this, we're adding an option to lock UI columns to most of our grid views. Just right-click a column's header, choose the Lock column to the left option, and it will be always visible when scrolling. To unlock the column, choose Unlock column from the same menu.

Comment DDL script generation​

Sometimes you may want to export comments or extended properties to your database in different hours or from a different account than you use in Dataedo. To solve this, we've added an option in the Export comments/extended properties form to only generate the DDL script instead of directly exporting the comments. The script can then be copied (just click the Copy all link) and run outside of Dataedo.

Other improvements​

• Creating a new term based on a column now seeds the term with column's description

• Improved Business Glossary responsiveness

• Fixed some graphical issues when switching from Business Glossary to other documentations

• Added an option to connect to Oracle with SID rather than Service Name

• You can now search for objects using schema.name notation

• You can now select your repository from a database list rather than manually type its name

• Multiple other fixes and UI improvements

Business Glossary Export (Enterprise)​

Enterprise users can now export Business Glossaries to HTML. Note that each person accessing the export should have either an Enterprise or Enterprise Viewer license (calculate).

Dataedo License changes​

We've made some changes to our license agreement regarding trial use, and added information about viewer license for users of Business Glossary export.

Dataedo 7.4.2 License

Connection with no password​

Till now, Dataedo blocked connections when no password was specified - a reminder to type the password in was displayed instead. However, since some DBMS allow creating users with no password requirement, from Dataedo 7.4.2 it is possible to connect to databases with blank password.

Other improvements​

• Fixed an issue with documentation name display in HTML export

• Fixed an issue where HTML export from commandline failed when run from a service account

• Fixed documentation order in navigation tree

• Fixed an issue with repository version comparison when running documentation copy between repositories

• Fixed an error caused by removing a parent term from a business glossary, and then trying to edit it

Bug fix​

• Fixed a bug where a Pro Trial user couldn't open a repository after its creation

Business Glossary (Enterprise)​

Many organizations use inconsistent language between departments, which can make communication a lot harder. To solve this issue, we're introducing Dataedo Business Glossary for our Enterprise users.

With it, no one will mistake customer for a client or consumer, and everyone in your organization can be on the same page.

Term types and hierarchy lets you quickly find the terms you're looking for:

You can define links from terms to data assets (tables and columns) related to a particular term:

Or find terms related to a particular table or column:

You can also create term relationships, which show how other terms are related to the one you're looking at:

Find out more in our documentation.

Redesigned HTML export​

We've completely reworked how HTML export works in Dataedo:

• You no longer have to choose between local and hosted templates

• Export time has been greatly improved, especially for bigger documentations

• Initial loading of the file is shorter

• The pages are more responsive

• Multiple bugs have been removed

The HTML Export is now a single page application rather than a set of static HTML files as previously.

Note that these changes make old custom templates incompatible - they need to be recreated from the current template.

CLR Function and procedure import from SQL Server​

Some of our users contacted us saying that they're using CLR (assembly) functions and procedures in SQL Server, which were not previously imported by Dataedo.

In Dataedo 7.4 we've added support for CLR functions and procedures, and they should now correctly import.

Other improvements​

• The password to the repository can now be saved

• Improved SQL Server import times

• Solved issues related to updating MySQL documentations with a renamed schema

• Pages opened from Search tab are now more responsive

• Custom fields with number type are now sorted as numbers rather than text

• Solved multiple other reported issues and bugs

Bug fixes​

• Fixed a bug with filters during Redshift import

• Fixed an issue with sorting closed dropdown list custom fields

• Fixed an issue with removing documentations containing personal connection settings

• Fixed a few issues with adding and removing objects from the navigation tree

• Fixed an issue with adding custom fields from the column view

ODBC data source (beta feature)​

Dataedo 7.3 allows you to use any ODBC driver to connect to data sources that were previously unsupported. You can now connect to almost any data source that supports ODBC, including Excel, Access, SAP ASE, Vertica, SQLite and many other.

This connection uses standard ODBC interfaces, so it depends on metadata provided by a specific driver. Different versions of a driver may display more or less data.

This is a beta feature. It may be less stable, but there's no risk in using it - your other documentations and the imported database will not be affected.

Copy descriptions (beta feature)​

Sometimes you have multiple databases with very similar structure and want to avoid documenting them multiple times.

On the other hand, allowing your documentation included columns that don't exist for a specific instance can lead to issues.

To solve this, Dataedo 7.3 includes a beta version of Copy descriptions feature. You can use it to copy descriptions and custom field values from one documentation to another. Descriptions from objects in source documentation will be copied if a matching object is found in the destination documentation.

This is a beta feature. We strongly recommend backing up your repository before using this feature, as changes made through it are irreversible.

Column view​

Sometimes a column is used in a standard way in the entire database, and a specific description fits it multiple times.

Now, by right clicking a column you can find all columns with the same name in documentation or repository and edit multiple descriptions at the same time.

Personal connection​

Previously, a repository could only store a single connection to a database, which was available for every Dataedo user in a repository.

From now on, in addition to the public setting behaving as before, you can also store personal settings for each user. These settings will be available only to the Dataedo user that created them.

MySQL 8 support​

Dataedo 7.3 adds MySQL 8 support. Connections to MySQL 8 use SSL by default (you can also specify key and certificate files as needed). If SSL connection fails, Dataedo retries connection without SSL.

New table and procedure types​

1. SQL Server

   1. Added distinction to file, graph, temporal, history, system versioned and external tables

2. PostgreSQL

   1. Added foreign tables

   2. Added stored procedures

3. Amazon Redshift

   1. Added external tables

Mac beta package improvements​

• License key input no longer hangs the application.

• CMD+c, CMD+v and CMD+s now work correctly.

• Issues with too small starting window size are now fixed.

Other improvements​

• Add key window reworked for easier use.

• Save the password to repository option added.

• Multiple objects can be simultaneously assigned to a module from an object list.

• Timeout to repository can now be changed by running Dataedo with /t [time] parameter.

• Empty fields included in progress percentage are now highlighted when progress is active.

• Import with filters optimized.

• SQL Server and Azure import improved.

• Dates are now displayed using system regional settings.

• Silent uninstall now skips uninstallation survey.

• HTML exports now display export date.

• Fixed multiple reported issues.