2017.7 (November 6, 2017)
Welcome to the 2017.7 release of iDev Studio. There are a number of updates in this version that we hope you will like, some of the key highlights include:
- Data profiling has got a major update. New add profile object dialog that will guide you through the steps to create a data profile. Metadata index and metadata statistic are available to assess whether known metadata accurately describes the actual values of the data profiling object.
- Schema definition or data profile can now be created with 1-click in the Metadata Explorer.
For the latest news, updates, and content, follow iDev Studio on Twitter @iDev_Studio!
Data Profiling
There is a new button Add Object in Data Profiling menu.
Add Profile Object dialog guide you through the steps to create a data profile.
With step 1 you can select Data Object.
With step 2 you can select the columns you want to include in the data profile. You can also add the profile object and run the data profile.
Moreover, in the General properties is now the timestamp of last data profiling run shown.
Metadata Indexes can be created now. A metadata index helps to assess whether known metadata accurately describes the actual values of the data profiling object and to understand data challenges early. There are two types of metadata indexes:
- Single-dimension index provides frequency distribution of different values.
- Multi-dimension index exposes embedded value dependencies in a cross-columns analysis.
There are three buttons available in Data Profiling menu to manage metadata indexes: Create Index, Rebuild Index, Remove Index.
Add Metadata Index dialog help you creating a metadata index.
Metadata index properties are displaying General, Index Definition and Index Statistic properties.
Metadata Explorer
Create schema defintion from data object with 1-click.
Create data profile from data object with 1-click.
Notable Fixes
- fix data type issue for MySQL in schema editor
- fix missing data object description in data profile
- fix negative size value to precision value for special data types (binary, xml, etc.)