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)
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
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
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
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.
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.
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.
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
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).
We've made some changes to our license agreement regarding trial use, and added information about viewer license for users of Business Glossary export.
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.
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
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.
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.
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.
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
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
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.
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.
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.
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.
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.
SQL Server
PostgreSQL
Added foreign tables
Added stored procedures
Amazon Redshift
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.
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.
We're releasing an open beta of Dataedo MacOS port.
We'd be happy to hear about your experience and any encountered issues at [email protected]
There are still some issues we're working on:
Adding a license key hangs the application. Restart it and the key will be correctly loaded.
Keyboard shortcuts are based around CTRL instead of CMD. In some cases CMD+C or CMD+V may work, but differently.
File and folder paths use \ instead of /. Mac filesystem is available under Y:\ in path prompts.
Commandline operations with .dataedocmd files are not supported yet.
Administration console is not supported yet.
In some cases, crash reports cannot be sent from application. Please email them to [email protected] instead.
Connection requiring an additional ODBC driver (Db2, Snowflake, Redshift) is not supported yet.
Fixed a bug with server repository, where new users were not granted required permissions
Fixed a bug where timeout setting was sometimes hidden on import schema window