No code model driven data integration and historization.
In Datavault Builder you can design and maintain your conceptual and logical data model. The difference to other approaches is that we do translate the data model in real time into working code.
Persist your Raw and Business Vault data in the same overall data mode.
Will modeling you can preview and load the data giving you to ability to become the first time really agile in your DWH development.
Do you want to persist your data before starting modeling? No problem. Just load the data into our PSA module.
Based on your data model, we generate all physical tables, tracking objects, SCD type 2 historizations, SCD type 1 as-of-now views, tracking/effectivity satellites. We do track implicit deletes. We calculate differences. We allow bi-temporal and tri-temporal data loading. Take care of PIT and bridge tables and many more.
And at the same time we derive your masterjobs, document your data model, create data lineage and make your model ready for versioning and deployment.
Module | Feature Group | Feature | Supported |
|---|---|---|---|
Data Vault | Modeling | Visual model Core Business Concepts (turn into Hubs), Relations (turn into Links) and Attributes (turn into Satellites) | Yes |
Data Vault | Modeling | Define Subject Ares / Data Domains | Yes |
Data Vault | Modeling | Free arrangement of objects | Yes |
Data Vault | Modeling | Boomark specific views | Yes |
Data Vault | Modeling | Business Key checker / validator built in | Yes |
Data Vault | Modeling | Display elements by source system | Yes |
Data Vault | Modeling | Display elements by Subject Area / Data Domain | Yes |
Data Vault | Modeling | Search for Element by Name, Source System or Subject Area | Yes |
Data Vault | Modeling | Caputre Metadata at Element and Column level | Yes |
Data Vault | Modeling | Import models from other applications trough the API, Command Line (CLI) or Deployment Module | Yes |
Data Vault | Modeling | Access the model and metadata trough data views and Rest APIs - bring your metadata in your reports | Yes |
Data Vault | Modeling | Preview Data from Modeled elements | Yes |
Data Vault | Modeling | Data is validated in real-time while modeling | Yes |
Data Vault | Modeling | Database code is generate and installed in real-time | Yes |
Data Vault | Raw Vault | Create Hubs, Links and Satellites | Yes |
Data Vault | Raw Vault | Load Hubs, Links and Satellites | Yes |
Data Vault | Raw Vault | Split Data in different Satellites | Yes |
Data Vault | Raw Vault | Convert data types while loading Satellites | Yes |
Data Vault | Raw Vault | Create insert only history while loading Satellites (SCD type 2) | Yes |
Data Vault | Raw Vault | Load only changed data (CDC) | Yes |
Data Vault | Raw Vault | Keep track of delivered data to be able to reconstruct source deliveries | Yes |
Data Vault | Raw Vault | Keep track of implicit deletes in the source system in Tracking Satellites | Yes |
Data Vault | Raw Vault | Capture Metadata Data on Hubs, Links and Satellites | Yes |
Data Vault | Raw Vault | Automatically keep track of link validity in Link Satellites | Yes |
Data Vault | Raw Vault | Combine more than one source into the same hub or link | Yes |
Data Vault | Raw Vault | Create binary Links between two hubs | Yes |
Data Vault | Raw Vault | Create Transaction Links to connect three and more hubs to represent transactions | Yes |
Data Vault | Raw Vault | Create Bridge Tables to include link and attribute data | Yes |
Data Vault | Raw Vault | Create as of now indexes | Yes |
Data Vault | Raw Vault | Create Change Data Capture based on business key | Yes |
Data Vault | Raw Vault | Model multi-active satellites using subpartition hub | Yes |
Data Vault | Raw Vault | Reference tables including reference value history | Yes |
Data Vault | Raw Vault | Create PIT Tables (Point in Time Tables) | Yes |
Data Vault | Business Vault | Create Business Vault Hubs, Link and Satellites | Yes |
Data Vault | Business Vault | Load Business Vault Hubs, Link and Satellites | Yes |
Data Vault | Business Vault | Only load changed rows into the Business Vault | Yes |
Data Vault | Business Vault | Only load derived values into the Business Vault | Yes |
Data Vault | Business Vault | Combine Raw Vault and Business Vault data in the output | Yes |
Data Vault | Business Vault | Manage your Business Vault logic in the business rules section | Yes |
Data Vault | Data Lake (PSA) | Allow to load elements based on technical key (primary key) | Yes |
Data Vault | Data Lake (PSA) | Create CDC based on technical key | Yes |
Data Vault | Data Lake (PSA) | Load the Raw Vault from the Data Lake | Yes |
Data Vault | Data Lake (PSA) | Use the same technology for Data Lake and Raw Vault | Yes |
Data Vault | Bi-Temporal | Automatically store external time lines as Bi-Temporal satellites | Yes |
Data Vault | Bi-Temporal | Compress data (CDC) on business time line | Yes |
Data Vault | Bi-Temporal | Create indexes for latest information on business time line | Yes |
Data Vault | Bi-Temporal | Create indexes for as of now queries | Yes |