Datavault Builder User Manual

General Overview

• Layer Concept
  • Staging
  • Persistent Staging Area
  • Raw Vault
  • Business Object / Business Rules
  • Business Vault
  • Accesslayer
  • Access Errormart
• Navigation
• Modules
• Dialogues
• Data Preview

Modules

• Staging
  • Connecting a new source
  • Adding a staging table
  • Source Specific Configuration
  • Staging Limitations
• Data Viewer
  • General Usage
  • Finding the business key
  • Using the log
• Data Vault
  • Using the working canvas
  • Extending the model
  • Metadata slider
  • Style Settings
  • Working with bookmarks
  • Unlinked mapping table
• Dimensional Model
  • Creating a Business Object
  • Working with the Business Object Generator
  • Deleting a Business Object
  • Using Point In Time Tables (PIT)
• Business Rules
  • Adding Business Rules
  • Business Ruleset Properties
  • Deleting a Business Ruleset
  • Materializing a Business Ruleset
  • Business Rules Limitations
• Accesslayer
• Data Lineage
• Operations
  • Status
  • Jobs
  • Load States
• Deployment
  • Overview
  • Export An Environment
  • Connect Remote Environment
  • Initiate Comparison
  • Using The Comparison View
  • Deploying objects

Initial Setup

• Requirements
  • Client
  • Host
  • Target database
• Preparing Host
  • Docker
  • Kubernetes
• Preparing target database
  • Exasol, MS SQL, Oracle, Postgres
  • Google Big Query
  • MS Fabric SQL DB
  • MS Synapse (Dedicated SQL Pool)
  • Snowflake
  • Database Specific Limitations
• Starting Up The Application

Configuration

• Configuring services
  • Main
  • Containerized Database
  • Additional
• Application Configuration
  • Available Parameters
  • Parameter Configuration
  • Advanced Parameters
• Third Party Integration - API
  • Using a standard user
  • Using a technical user
• Role Concept
  • Application-Level User Groups
  • User Management
  • Authentication
  • Role Concept Limitations

Maintenance & Updates

• Setting up Backups
  • Database
• Health Check
• Update/Upgrade Installation
  • License Replacement
  • Version Change
  • Major Upgrade

Troubleshooting

• Installing DVB
• API Interaction
• Loading
• Data Access

Appendix A.

• Metadata Views
  • dvb_core.access_errormart
  • dvb_core.accesslayers
  • dvb_core.business_rules
  • dvb_core.businessobjects
  • dvb_core.columns
  • dvb_core.hub_loads
  • dvb_core.hubs
  • dvb_core.jobs
  • dvb_core.latest_datavault_load_info
  • dvb_core.latest_job_load_info
  • dvb_core.latest_staging_load_info
  • dvb_core.link_loads
  • dvb_core.links
  • dvb_core.linksatellites
  • dvb_core.load_log_datavault
  • dvb_core.load_log_staging
  • dvb_core.satellites
  • dvb_core.staging_tables
  • dvb_core.subject_area_name
  • dvb_core.system_connections
  • dvb_core.systems
  • dvb_core.tables
  • dvb_core.tables_simple
  • dvb_core.tracking_satellites
  • dvb_core.transaction_link_relations
  • dvb_core.transaction_links
  • dvb_core.view_relations
  • dvb_core.views
  • dvb_core.x_business_rules_distinct
  • dvb_core.x_business_rules_system
  • dvb_core.x_businessobjects_distinct
  • dvb_core.x_businessobjects_system
  • dvb_core.x_hubs_distinct
  • dvb_core.x_hubs_system
  • dvb_core.x_jobs_system
  • dvb_core.x_latest_load_info
  • dvb_core.x_links_distinct
  • dvb_core.x_links_system
  • dvb_core.x_satellites_system
  • dvb_core.y_blocking_procs
• Log Tables
  • dvb_log.datavault_load_log
  • dvb_log.ddl_log
  • dvb_log.dvbuilder_creation_log
  • dvb_log.dvbuilder_log
  • dvb_log.job_load_log
  • dvb_log.login_log
  • dvb_log.staging_load_log
  • dvb_log.deployment_log
  • dvb_log.deployment_step_log
  • dvb_config._dvb_runtime_deployment_package
• Naming Conventions
  • Datavault - Main Objects
  • Datavault - Object Subtypes
  • Columns IDs

Licences

• Licences

Release Notes

• Version 8
  • 8.2.0.1
  • 8.2.0.0
  • 8.1.0.0
  • 8.0.1.0
  • 8.0.0.1
  • 8.0.0.0 Beta
• Version 7
  • 7.5.4.0
  • 7.5.3.0
  • 7.5.2.1
  • 7.5.2.0
  • 7.5.1.0
  • 7.5.0.1
  • 7.5.0.0
  • 7.4.4.0
  • 7.4.3.0
  • 7.4.2.0
  • 7.4.1.0
  • 7.4.0.0
  • 7.3.0.1
  • 7.3.0.0
  • 7.2.1.0
  • 7.2.0.0
  • 7.1.2.0
  • 7.1.1.1
  • 7.1.1.0
  • 7.1.0.0
  • 7.0.1.1
  • 7.0.1.0
  • 7.0.0.6
  • 7.0.0.5
  • 7.0.0.4
  • 7.0.0.3
  • 7.0.0.2
  • 7.0.0.1
  • 7.0.0.0
• Version 6
  • 6.11.6.1
  • 6.11.6.0
  • 6.11.5.0
  • 6.11.4.2
  • 6.11.4.1
  • 6.11.4.0
  • 6.11.3.0
  • 6.11.2.0
  • 6.11.1.0
  • 6.11.0.1
  • 6.11.0.0
  • 6.10.1.1
  • 6.10.1.0
  • 6.10.0.1
  • 6.10.0.0
  • 6.9.1.0
  • 6.9.0.0
  • 6.8.1.0
  • 6.8.0.0
  • 6.7.0.0
  • 6.6.0.1
  • 6.6.0.0
  • 6.5.1.0
  • 6.5.0.0
  • 6.4.1.0
  • 6.4.0.0
  • 6.3.2.0
  • 6.3.1.0
  • 6.3.0.1
  • 6.2.0.0
  • 6.1.5.0
  • 6.1.4.0
  • 6.1.3.0
  • 6.1.2.0
  • 6.1.1.0
  • 6.1.0.0
  • 6.0.15.0
  • 6.0.14.0
  • 6.0.13.0
  • 6.0.12.0
  • 6.0.11.0
  • 6.0.10.0
  • 6.0.9.0
  • 6.0.8.0
  • 6.0.7.0
  • 6.0.6.0
  • 6.0.5.0
  • 6.0.3.0 - 6.0.4.0
  • 6.0.2.0
  • 6.0.1.0
  • 6.0.0.3
  • 6.0.0.2
  • 6.0.0.0 - 6.0.0.1