Piotr Tokarski
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.