The start of a new year welcomes a new release. VaultSpeed kicked of 2020 with some brand new features in version 4.1.11. We added support for bridge tables in a new graphical editor and added the possibility to import and export business names in the business vault. By adding bridge tables, VaultSpeed now supports the 5 main objects in data vault 2.0: Hubs, Links and Satellites in the Raw Data Vault. But also PITs and Bridges in the Business Data Vault. The graphical bridge editor enables users to generate bridge tables based upon raw data vault objects. All available Hubs can be dragged and dropped to the editor.

Once a certain hub is selected on the canvas, the adjacent hub tab becomes active. It contains all adjacent hubs for the selected hub. Each adjacent hub can be dragged into the editor. Hubs can have multiple links to the same adjacent hub. It is not possible to add more than one link connection for a starting / ending hub.

The Bridges tab contains all available bridges. It is possible to remove, edit or create a bridge. To edit a bridge, first load it by dragging it into the editor, then you can start modifying it. To save the changes, click the edit button which is above bridge list in order to complete the edit. To create a new bridge, build it in the editor and click the create new bridge button. Creating a new bridge and editing a bridge is only possible when the bridge combination is valid, otherwise a warning message will be displayed.

It is possible to let the app generate possible paths between two hubs. To do this, Right click and select draw shortest path relation, then drag a line between the 2 hubs you want to connect. Then you can change the number of possible paths it will generate by setting “max generation options”, as well as excluding hubs from the paths. If there is only one viable option, then it will be directly applied to the editor. However, if there is more than one option, then an extra tab becomes active and it is possible to preview, regenerate or apply options to the paths. To preview or regenerate a path, you need to selected a bridge and click one of the buttons above the shortest path options list. During preview editor becomes read-only. To apply the selected shortest path option while in preview mode, click the apply button, otherwise you can drag and drop the desired path option into the editor.

The Editor has a context menu, available when right clicking in the editor, it contains the following functionality:

• Clear everything function which resets the editor.

• Option to change the view: there are two available options, an icons view and an Objects / Attributes view.

• Draw shortest path relation, which enables drawing a relation between two hubs that initiates the shortest path generation.

• Remove selected function which appears under link or hub. If the hub is removed then links connected to it are also removed.

• Set starting / ending hub. Each bridge must contain these. Setting hubs to starting / ending hub will automatically clear all other starting / ending hubs before that.

• Include business keys function which will insert the business keys of the selected HUB into the bridge table.

• Include business keys for all hubs which will do same as include business keys function but it will be performed for all hubs under the editor.

Other features and important changes included in the release:

• Features:

  • Added support for Bridge tables

  • Added the ability to import and export Business names. Objects and attributes not included in the csv will get their generate flag disabled.

  • Added a parameter DATA_TYPE_CASTING which enables casting of source data with out using data quality bad logic. This is useful when data arrives in text format from a staging area but was extracted from a database with proper formatting.

• Important changes:

  • Improved performance of the web application by adding lazy loading. Web pages which can show a lot of data such as source objects and attributes, will now only render the items that are visible thus improving browser performance.

  • Changed name of “Direct Link” to “Many to Many Link”. Direct link was an internally used name and it was not always clear what it meant.

  • Added the ability to define an attribute as primary key in the source graphical editor.

  • Improved the performance of the generate ETL metadata task, it should about 5 times faster.

  • Attributes can now be placed in more than one SAT split.

  • The source graphical and object editors are now available through a sub-menu “editor” in the top bar of the sources page.
    Also, made the mass update, download names and upload names button available from both editors and made them more compact.

More releases coming up soon!