Documentation

Table of Contents:


    Why upgrade to Dataedo 7

    Piotr Kononow - Dataedo Team Piotr Kononow 2018-06-11 2018-10-12
    Applies to: 7.1 (current), Article available also for: 6.3

    This article compiles improvements in Dataedo 7 from Dataedo 6.

    New sources and databases

    In Dataedo 7 we added a number of new supported databases. Those are: PostgreSQL, IBM Db2, Snowflake, Amazon Redshift and Percona Server for MySQL.

    Manual Data Dictionary

    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.

    Manual documentations

    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.

    Manual tables in existing documentations

    Search in HTML export

    Now, it is able to search tables and other objects by their names, aliases and column names (and aliases) in static HTML exports.

    Search in HTML

    Improvements in data dictionary

    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.

    User defined columns in existing tables

    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.

    Reordering columns in existing tables

    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.

    Cross documentation module

    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:

    Filter

    And an addition to our previous search feature - search within current tab:

    Quick search

    This applies to almost all of our grid style tabs.

    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:

    Add related tables

    Suggested entities

    We redesigned and improved suggested entities list. It is now context aware and includes all available entities from repository and suggests entities assigned to module and related to selected entity/entities on the diagram.

    Add related tables

    Oracle improvements

    Importing Packages

    Dataedo 7.1 now imports Oracle packages:

    Oracle packages

    Importing Materialized Views

    Dataedo 7 now imports materialized views from Oracle:

    Materialized view

    Direct connection

    Until now, importing from Oracle required Oracle Client installation.

    In Dataedo 7.1 you don't need to install Oracle Client to connect, you can now use direct connection option:

    Oracle direct connection

    Repository on Azure

    Until now, Dataedo supported file and SQL Server based repository. In version 7 we added ability to set up Dataedo repository in Azure SQL Database.

    As of release 7.0.3 beta Azure repository is still under development. It is stable, but requires manual setup.

    Click here to find out more.

    Azure repository

    Much more to come...

    Found issue with this article? Comment below
    Comments (0)