Dataedo 10.4 is coming with a few important changes.

Report Catalog and Power BI​

The report is a new type of object next to the Business Glossary and Database. Reporting is an object that contains data sets and visualizations. Check out more about existing object types in Dataedo.

In version 10.4 this feature is coming with the support of the Power BI connector so that you can automatically extract metadata of and document your reports.

Reports and visualizations details

Report preview

Automatic object-level lineage

Column-level lineage will be developed in future versions.

Read more about Power BI connector.

Reference Data Management​

We created a new type of object – Lookup. Lookups allow you to describe values stored in objects’ columns.

They are also known as reference data, lists of values, or dictionaries. You can manually create new lookups or create them automatically based on the values in your database.

Read more about that in our Reference Data Management section of the documentation.

Automated column-level lineage for views​

For views in the SQL Server and Azure SQL, you can now create an automatic lineage based on the view script.

Future versions will also support Snowflake, Oracle, PostgreSQL, Amazon Redshift, MySQL, and MariaDB.

FK Relationship tester​

When adding a new relationship you can test its correctness automatically (we run tests both on metadata and on real data in the database).

FK tester is supported for: SQL Server, Azure SQL and Snowflake.

Future versions will also support Oracle, PostgreSQL, Amazon Redshift, MySQL, and MariaDB.

Redesign of Web Catalog​

We've made effort to make Web Catalog better and easier for you to use. The most important changes are:

1. Navigation received UX improvement.

2. New rich text editor. Read more about editing in Web Catalog

3. Community is now easily accessible on a right-side panel

4. We replaced our Grid (tables) engine and added a few features to it (columns sorting was postponed to 10.4.2 in a few weeks)

5. We've added settings sections and an option to pin Custom metadata Fields

It's not a one-time thing - with the next releases we are going to continue improving Web Catalog UI and UX!

Other features​

Besides the big changes listed above, we also introduced smaller features as well as many bug fixes and improvements.

Movable tabs in the Desktop App​

You can now drag and drop tabs on the objects overview and organize them however you like. You can even move some tabs outside of the Dataedo and utilize more screens!

SQL Query object type​

We've added a new object type - SQL Query, which should help you organize your code snippets. Read more about object types in Dataedo.

Open in Web​

Open in Web feature allows you to open objects viewed in Dataedo Desktop in the Web Catalog interface without the need to navigate to them. Find out more in Open in Web - feature article

Classification in the Web Catalog​

We added options to add content to your classification, plus we made browsing classified content easier with Dataedo Web Catalog.

Linking to BG entries​

You can now link procedures and functions next to previously available tables, views, and structures to BG entries.

New connectors​

Dataedo 10.4 comes with new connectors:

• Power BI - reports

• Azure Data Factory

Web Catalog Users and Login improvements​

To make managing and auditing permissions and access in the Web Catalog easier, we implemented a few improvements.

Managing login methods in the Web Catalog​

We introduced an option to disable selected login methods in Web Catalog. You can now access settings and decide which login method should be allowed in your organization.

If you are not using Active Directory login method, you should disable it through settings to ensure security as it is common that default environment is available already, and that can lead to giving everyone who has an AD account an access to the Web Catalog. If you are using Active Directory, you may want to remove or limit permissions assigned to default groups.

Read more about accessing Web Catalog in this article.

Browsing permissions summary​

We added a view in which one can check permissions from a data source perspective. View lists of all users with some level of access to the data source.

Deleted users View​

We added a listing of deleted users with the option of restoring a deleted user. Find out more about Users management.

Other issues​

With Dataedo 10.3.2, we also addressed a few issues and improved the experience of existing features.

Fixed Issues​

Issue	Resolution Status	Fix Version	External Links
Issues with importing PostgreSQL.	Fixed.	10.3.2
Newlines were not displayed in Web Catalog grids.	Fixed.	10.3.2
Some minor gaps in actions validation.	Fixed.	10.3.2	Actions in Web Catalog
Problems with SCT in the Web Catalog.	Added SCT to Subject areas. Fixed a few minor bugs. One inaccuracy between Desktop and Web Catalog was left for the next version.	10.3.2
Issues with setting the filter on import.	Fixed.	10.3.2
General issues with MySQL connections.	Fixed by changing library.	10.3.2

Additionally, we addressed multiple minor issues.

Repository changes​

The repository upgrade is required with this version.

Release Notes 10.3.1​

With Dataedo 10.3.1, we addressed a few issues and improved the experience of features released with 10.3

Addressed issues​

Issue	Resolution Status	Fix Version	External Links
Import from PostgreSQL was failing with filters.	Fixed.	10.3.1
Import issues with MongoDB.	Fixed.	10.3.1
Administration console was crashing.	Fixed.	10.3.1	Administration console

Repository changes​

The repository upgrade is not needed with this version.

Column-level data lineage​

Dataedo from version 10.3 allows you to not only configure lineage on the object level but also to go deeper and define flows on a column level. You can set column-level flows by enabling column-level lineage and setting inflow and correspondent outflow columns.

Additionally, you can now browse diagrams from both the Web and Desktop.

Redesigned Data Classification​

We redesigned Data Classification and improved performance or algorithms. You can now classify only a portion of the Data Catalog and configure classification to match your needs.

We also added a few built-in classifications, so that the current list contains:

• CCPA - California Consumer Privacy Act

• FERPA - Family Educational Rights and Privacy Act

• GDPR - finds columns potentially holding personal data as defined by European GDPR

• HIPAA - Health Insurance Portability and Accountability Act

• PCI - Payment Card Industry

• PII - finds columns PII (Personally Identifiable Information)

Read more about Data Classification.

History of changes in documentation​

With this version, we improved the previously released history of changes. It is now supported across most of the objects in Descriptions, Titles, and Custom Fields.

Read more about History of changes.

ERD Improvements​

In version 10.3 we added numerous ERD improvements.

Post-its​

You can now add post-its (notes) to the diagram. Each post-it can have its position, and color, and can be either behind or over other nodes.

Other improvements​

• You can now display the nullability of columns on the ERD diagram.

• You can now quickly add and remove objects from Subject Area when operating on the ERD diagram.

• We improved ERD exporting design.

• We improved how ERD works in the Web Catalog.

Metadata​

Automated data lineage for views​

Dataedo, from version 10.3, will automatically create a lineage for views for you. Only requirement is to import a dependecies for a database:

New connectors​

With 10.3 we are bringing a few new native metadata scanners:

• SQL Server Integration Services (SSIS) (beta)

• dbt (beta)

• SAP HANA

• NetSuite

• Astra DB

• Amazon DynamoDB

• Azure Blob Storage

• Azure Data Lake Storage (ADLS)

Improvements in existing connectors​

PostgreSQL:

• Added new SSL modes:

  • Prefer

  • VerifyCA

  • Verify Full

• Added support for client SSL certificate authentication

Web Catalog UI/UX improvements​

With version 10.3 we are shipping a package of UI improvements in the Web Catalog.

• We implemented Schema Change tracking into Web Catalog

• We changed the grids engine for a smoother experience and better customization.

Other Desktop improvements​

• We added Spell checking option in the descriptions editor in Dataedo Desktop

• We implemented the possibility of running Data Profiling across Views

Release Notes 10.2.2​

With the Dataedo 10.2.2, we addressed a few issues and improved the experience of features released with 10.2

Improved features​

We added new objects we track with History of Changes.

Addressed issues​

Issue	Resolution status	Fix version	External links
Web Catalog checks both SQL permissions and internal permissions.	Changes, so that now Web Catalog checks only permissions built in Web Catalog and no longer checks SQL Server permissions.	10.2.2	Accessing Web Catalog
Problems with DDL Import.	Fixed errors with PK, FK, data sizes, and more.	10.2.2
Import dependencies take a long time.	Importing dependencies is now an option.	10.2.2
Problems with connecting to Salesforce.	Connection to Salesforce has been improved.	10.2.2

We addressed also multiple smaller issues.

Repository changes​

Repository upgrade is not needed with this version.

Release Notes 10.2.1​

With the Dataedo 10.2.1, we addressed a few issues and improved experience of features released with 10.2

Addressed issues​

Issue	Resolution status	Fix version	External links
Issues with commandline license.	Fixed.	10.2.1	Command line
Issues with importing Oracle packages.	Fixed.	10.2.1
Issues with Tabular connector.	Fixed.	10.2.1
Rare issues with editing and creating Business Glossary terms.	Fixed.	10.2.1

Other changes​

• Web Catalog can now run search based only on filters (without text).

Repository changes​

Repository upgrade is not needed with this version.

New metadata sources​

One of the first things that catch an eye is redesigned import windows. With more and more connectors and options added to each release, we decided it's time to add a search functionality alongside folders grouping.

New metadata connectors​

With Dataedo 10.2 we are bringing a few new native metadata scanners:

• Microsoft Dataverse

• Tableau (BI data model)

• AWS Athena

• SAP ASE

• [Hive Metastore]/docs/documenting-technology/supported-databases/apache-hive-metastore)

And also we are introducing a way, to import files like JSON, CSV, or XLS directly from:

• Amazon S3 Bucket.

You can also connect to the following sources using native connectors:

• with Amazon Athena connector:

  • Amazon DocumentDB

  • Amazon DynamoDB

  • AWS Glue Data Catalog

  • Amazon S3

• with [Apache Hive Metastore]/docs/documenting-technology/supported-databases/apache-hive-metastore) connector:

  • Apache Impala

  • Apache Spark SQL

  • Databricks

• with Microsoft Dataverse connector:

  • Microsoft Dynamics 365

Here is the list of all the connectors.

Updates to existing connectors​

1. Oracle - added parsing of packages and extracting information as functions and procedures.

Import from interface tables​

You can now import your database schema using interface tables, built-in Dataedo.

Read more about Importing from Interface Tables.

Import from DDL script (beta version)​

Starting from Dataedo 10.2 you can import your database schema using SQL dump from your database.

Read more about Importing from DDL script.

Data Profiling improvements​

This feature was slightly redesigned and improved based on your feedback. The most important change is that you can currently run it for your whole database at once, save results as you go, and come back sometime later to preview the results.

There are now three scopes you can run Data Profiling.

1. Run Data Profiling for the whole database (or any selected subset of tables)

2. Run Data Profiling only for the selected table.

3. Preview Sample Data for the selected table.

Read more about Data Profiling in Dataedo Desktop.

Sample Data​

Part of the improvements in the area of Data Profiling is the fact that we surfaced the ability to peak into Sample Data. Right now you can simply use a handy right-click option on a table to preview its values!

History of changes in documentation​

With this version, we introduced the history of changes in descriptions, titles, and Custom Fields. Dataedo will store information about who, when, and how changed the values.

Currently, Dataedo will monitor only some objects in the system. A list of monitored objects and fields is available in a detailed article.

Read more about History of changes.

Permissions in the Web Catalog​

From version 10.2, accessing any data via Dataedo Web Catalog requires correct permission. This allows detailed customization regarding who will be able to perform what action in the Dataedo Web Catalog.

In other words, admins can now customize who is allowed to see what portion of data in Dataedo Web Catalog.

Read more about Permissions in Dataedo Web Catalog.

Other improvements​

With Dataedo 10.2 we fixed some bugs, and also introduced some other changes, like:

• We unified the naming for Subject Areas across all products (previously we were naming them in some places as "Modules" or "Modules and ERD's").

• We added the ability to edit Business Glossary from the Web Catalog.

• We improved performance both in Web Catalog and Dataedo Desktop.

• We improved the way we are upgrading the repository from version to version and we introduces dbo.database_update_log for better support and troubleshooting.

Release Notes 10.1.3​

With the Dataedo 10.1.3, we addressed a few issues, which you might encounter using Dataedo.

Addressed issues​

Issue	Resolution status	Fix version	External links
Problems with connecting to SQL Server after the certificate expires	Fixed by adding "Connection mode" select to SQL Server metadata scanner.	10.1.3
Web Catalog Installer occasionally crashes at the end of a process	Fixed by resolving the main issue and adding logging	10.1.3
Crash Cannot insert duplicate key in object 'dbo.licenses' after selecting license	Fixed	10.1.3
Issues with Active Directory login to Web Catalog	Fixed	10.1.3
Manual columns are stuck in the "user-defined" type.	Fixed	10.1.3
Object counters are not always correctly refreshed.	Fixed	10.1.3
Cannot connect to Tabular with Windows Authentication in Dataedo 10.1	Fixed	10.1.3

Other changes​

• Multiple minor UI fixes in Dataedo Desktop.

• Salesforce metadata scanner improvements.

Repository changes​

Repository upgrade is not needed with this version.

Release Notes 10.1.2​

With the Dataedo 10.1.2, we fixed a few an issue, which encountered in Dataedo 10.1.x

Addressed issues​

Issue	Resolution status	Fix version	External links
When importing database changes (updating schema), tables where changes were made in the database since the last update was made, may have the table or column title removed.	Fixed. For new columns, we are importing Titles. On column update, we are not overwriting the Title.	10.1.2
Some users were unable to login into Web Catalog with Active Directory, after upgrading from Dataedo 9.x.	Fixed	10.1.2

How to check if I was affected?​

To check if you were affected, check one of the tables changed during one of the previous imports. You can use schema change tracking to find these objects.

Repository changes​

Repository upgrade is not needed with this version.

Release Notes 10.1.1​

With the Dataedo 10.1.1, we fixed a few issues, which you might encounter in Dataedo 10.1.

Addressed issues​

Issue	Resolution status	Fix version	External links
Unable to run command-line (missing license).	License file support added to command-line.	10.1.1	Command-line support
Deleting documentation was timing out.	We improved the way we are deleting documentation.	10.1.1	-
Upgrade from 9.x to 10.x was not copying the recent connections.	We fixed that, and starting from the fix version, on upgrade, recent connections are copied.	10.1.1	-
Problems with connecting to Salesforce when domain region had more than 2 letters.	Fixed.	10.1.1	-
Missing IIS modules after Web Catalog installation.	Fixed.	10.1.1	-
"The given key was not present" error when importing from SQL Server.	Fixed.	10.1.1	-

Other changes​

• Fixes to few minor crashes not mentioned above.

• Users on the server, without permissions to the repository database, can no longer create accounts in the Web Catalog.

Repository changes​

Repository upgrade is not needed with this version.