Bug fixes​

• 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​

• 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.

Schema Change Tracking (Enterprise feature)​

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.

Learn more.

New custom field types (drop-downs and more)​

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

Improved progress tracking​

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.

Description suggestions​

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.

Paste to multiple cells​

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 Cloud support​

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.

Other improvements​

1. Solved multiple crashes and other issues,

2. Custom HTML Export now contains editable user.js file, which can be used e.g. to add Google Analytics

3. User defined objects changes made through new windows no longer require additional save operation

4. Relations and unique keys are now imported from Snowflake

5. Added ability to change SQL Server port

Improvements​

1. Fixed an issue with updating documentation on upgraded repositories.

2. Fixed an issue with connecting to postgres 10.4 on Amazon AWS.

3. Fixed an issue with importing from Db2 Cloud.

4. Fixed issues with HTML export in multiple files template.

5. Small UI improvements.

Improvements​

Solved multiple reported issues and bugs.

IBM Db2 support​

In 7.1 we have added support for IBM Db2 database.

Find out more in documentation.

Filtering and quick search​

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.

Oracle - direct connection​

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.

Oracle - packages​

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:

Repository connection encryption​

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:

Suggested entities in ERDs​

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.

Easier and quicker manual relations​

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.

Improvements​

Performance:

1. We made modifications to the import process which should greatly boost time of importing new documentations.

2. We have also enhanced repository indexing which should make navigation of the repository smoother.

Manual tables:

1. Manual tables now display their type in the details tab, along with an icon.

Import:

1. Changing letter case of an object name in database will also be updated in Dataedo.

2. DBMS icons are now shown when choosing source during import.

3. Altered messages shown when connecting to unsupported databases.

4. Solved encoding issue when importing from Postgres.

Other:

1. Solved multiple reported issues and bugs.

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.

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.

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

Import​

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

Export​

• 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.

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.