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
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
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.
Fixed multiple other issues and bugs.
Often, it's important to be able to see what and when changed in database schema. From now on, in Dataedo Enterprise there is an option to enable tracking of schema changes.
Until now, all custom fields were text based. Many users asked for an option to add a drop down or checkbox type custom field and we added it in this release.
From Dataedo 7.2 you can set a type for any custom field.
Available types are:
closed list with predefined values
open list with predefined values and ability to add new elements while editing
multiselect with predefined options
checkbox/binary
number (integer)
free text
Many users requested a change in progress tracking to include only tables and columns. We added this as Tables & columns progress tracking option
Additionally, we've added an option to track progress of a specific custom field.
Dataedo 7.2 now suggests texts for columns descriptions, titles or text custom fields based on texts from other columns. Those suggestions are hinted by blue marker and available in context menu.
Previously, even if multiple cells were selected in a grid, data was only copied and pasted to a single active one.
In Dataedo 7.2 all selected cells can be copied and pasted to. Non-editable fields will be skipped when pasting data.
DB2 support was added in Dataedo 7.1. In 7.2 we fixed some issues with import from DB2 Cloud.
Additionally, we have added support Db2 connection from command line.
Solved multiple crashes and other issues,
Custom HTML Export now contains editable user.js file, which can be used e.g. to add Google Analytics
User defined objects changes made through new windows no longer require additional save operation
Relations and unique keys are now imported from Snowflake
Added ability to change SQL Server port
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.
Small UI improvements.
Solved multiple reported issues and bugs.
In 7.1 we have added support for IBM Db2 database.
Find out more in documentation.
When your table contains hundreds of columns, finding the one you want to edit can be cumbersome.
In Dataedo 7.1 we've added an option to filter objects:
And an addition to our previous search feature - search within current tab:
This applies to almost all of our grid style tabs.
Until now, importing from Oracle required Oracle Client installation.
In Dataedo 7.1 you can choose direct connection:
In case of any issues, Oracle client connection is still available.
A much requested feature on our forums was the ability to document packages.
Using Dataedo 7.1, you can now import package scripts - they're visible in the Procedures folder:
When connecting to your server repository, Dataedo 7.1 always tries to use encrypted connection.
To better protect your data, you can now also block unencrypted connection, or when encrypted server certificate is not trusted by your machine:
Clicking an object on ERD now displays objects related to it in the Suggested entities tab.
When no objects are selected, Suggested entities contain all objects related to objects already on ERD.
Other entities displays objects not already on ERD from the same documentation by default, or all other documentation if you check the All docs box.
Sometimes you know that there must be a relation between tables, but you're not sure which columns are used for joins.
You can now add a relation without specifying columns which it references.
New user defined relations now get their default name based on joined tables.
Performance:
We made modifications to the import process which should greatly boost time of importing new documentations.
We have also enhanced repository indexing which should make navigation of the repository smoother.
Manual tables:
Import:
Changing letter case of an object name in database will also be updated in Dataedo.
DBMS icons are now shown when choosing source during import.
Altered messages shown when connecting to unsupported databases.
Solved encoding issue when importing from Postgres.
Other:
Solved multiple errors that could lead to application crashing.
Shortened repository upgrade time.
Altered relations now properly display their current columns.
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.
Recent connections are now imported on version upgrade. Previously, a new major version started with a fresh recent file.
Added option to change favicon in customized HTML 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.