You are completely free to include what ever business rules your business requires. Virtual or materialized. You choose.
You can add any business rule you want as SQL code.
If required for performance or auditability reasons, you can materialize any calculation into the business vault.
If your business logic is too complex for SQL, don’t worry, you can still run stored procedures and external rule engines triggered by the Datavault Builder.
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.
Module | Feature Group | Feature | Supported |
|---|---|---|---|
Business Vault | Modeling | Visual model Core Business Concepts (turn into Hubs), Relations (turn into Links) and Attributes (turn into Satellites) | Yes |
Business Vault | Modeling | Define Subject Ares / Data Domains | Yes |
Business Vault | Modeling | Free arrangement of objects | Yes |
Business Vault | Modeling | Boomark specific views | Yes |
Business Vault | Modeling | Business Key checker / validator built in | Yes |
Business Vault | Modeling | Display elements by source system | Yes |
Business Vault | Modeling | Display elements by Subject Area / Data Domain | Yes |
Business Vault | Modeling | Search for Element by Name, Source System or Subject Area | Yes |
Business Vault | Modeling | Caputre Metadata at Element and Column level | Yes |
Business Vault | Modeling | Import models from other applications trough the API, Command Line (CLI) or Deployment Module | Yes |
Business Vault | Modeling | Access the model and metadata trough data views and Rest APIs - bring your metadata in your reports | Yes |
Business Vault | Modeling | Preview Data from Modeled elements | Yes |
Business Vault | Modeling | Data is validated in real-time while modeling | Yes |
Business Vault | Modeling | Database code is generate and installed in real-time | Yes |
Business Vault | Business Vault | Create Hubs, Links and Satellites | Yes |
Business Vault | Business Vault | Load Hubs, Links and Satellites | Yes |
Business Vault | Business Vault | Split Data in different Satellites | Yes |
Business Vault | Business Vault | Convert data types while loading Satellites | Yes |
Business Vault | Business Vault | Create insert only history while loading Satellites (SCD type 2) | Yes |
Business Vault | Business Vault | Load only changed data (CDC) | Yes |
Business Vault | Business Vault | Keep track of delivered data to be able to reconstruct source deliveries | Yes |
Business Vault | Business Vault | Keep track of implicit deletes in Raw Vault calculations in Tracking Satellites | Yes |
Business Vault | Business Vault | Capture Metadata Data on Hubs, Links and Satellites | Yes |
Business Vault | Business Vault | Automatically keep track of link validity in Link Satellites | Yes |
Business Vault | Business Vault | Combine more than one source into the same hub or link | Yes |
Business Vault | Business Vault | Create binary Links between two hubs | Yes |
Business Vault | Business Vault | Create Transaction Links to connect three and more hubs to represent transactions | Yes |
Business Vault | Business Vault | Create Bridge Tables to include link and attribute data | Yes |
Business Vault | Business Vault | Create as of now indexes | Yes |
Business Vault | Business Vault | Create Change Data Capture based on business key | Yes |
Business Vault | Business Vault | Model multi-active satellites using subpartition hub | Yes |
Business Vault | Business Vault | Reference tables including reference value history | Yes |
Business Vault | Business Vault | Create PIT Tables (Point in Time Tables) | Yes |
Business Vault | Business Vault | Create Business Vault Hubs, Link and Satellites | Yes |
Business Vault | Business Vault | Load Business Vault Hubs, Link and Satellites | Yes |
Business Vault | Business Vault | Only load changed rows into the Business Vault | Yes |
Business Vault | Business Vault | Only load derived values into the Business Vault | Yes |
Business Vault | Business Vault | Combine Raw Vault and Business Vault data in the output | Yes |
Business Vault | Business Vault | Manage your Business Vault logic in the business rules section | Yes |
Business Vault | Bi-Temporal | Automatically store external time lines as Bi-Temporal satellites | Yes |
Business Vault | Bi-Temporal | Compress data (CDC) on business time line | Yes |
Business Vault | Bi-Temporal | Create indexes for latest information on business time line | Yes |
Business Vault | Bi-Temporal | Create indexes for as of now queries | Yes |