Datavault Builder User Manual

General Overview

• Layer Concept
  • 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
• 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
  • Limitations
• Accesslayer
• Data Lineage
• Operations
  • Status
  • Jobs
  • Load States
• Deployment
  • Getting started
  • Export an environment
  • Connect environment
  • Comparing environment
  • Deploying objects

Installing Datavault Builder

• Requirements
  • Download of Container Images on Another Computer
  • Test your Docker Installation
• Initial Install
  • Database Requirements
  • Install DVB Structures on Database
• Docker-Compose Configuration
  • Files and Structure
  • Core
  • Connection Pool
  • Webgui
  • Metrics dashboard
  • Scheduler
  • API
  • CICD
  • Client-Database: Postgres
  • Client-Database: MS SQL
  • Client-Database: Oracle
  • Client-Database: Exasol
• Generate System Encryption Keys
  • On Linux
• Application Configuration
• Limitations
• Setting up Backups
  • Database
• Role Concept
  • Limitations
• Update/Upgrade Installation
  • License Replacement
  • Version Change
  • Major Upgrade
• Check Health State of Datavault Builder

Testing

• Connecting to a Source

Datavault Builder Integration

• REST API

Troubleshooting

• Installation
• Deployment
• Loading
• Useful Command line actions

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
• Naming Conventions
  • Datavault - Main Objects
  • Datavault - Object Subtypes
  • Columns

Licences

• Licences

Release Notes

• 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
  • Workaround
• 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
• Release Notes - Version 5
  • 5.5.4.2
  • 5.5.4.1
  • 5.5.4.0
  • 5.5.3.2
  • 5.5.3.1
  • 5.5.3.0
  • 5.5.2.0
  • 5.5.1.0
  • 5.5.0.0
  • 5.4.8.0
  • 5.4.7.0
  • 5.4.6.0
  • 5.4.5.0
  • 5.4.4.0
  • 5.4.3.1
  • 5.4.3.0
  • 5.4.2.0
  • 5.4.1.0
  • 5.4.0.0
  • 5.3.3.1
  • 5.3.3.0
  • 5.3.2.3
  • 5.3.2.2
  • 5.3.2.1
  • 5.3.2.0
  • 5.0.0.0_b2.8
  • 5.0.0.0_b2.7
  • 5.0.0.0_b2.6
  • 5.0.0.0_b2.5
  • 5.0.0.0_b2.4
  • 5.0.0.0_b2.3
  • 5.0.0.0_b2.2
  • 5.0.0.0_b2.1
  • 5.0.0.0_b2.0
  • 5.0.0.0_b1.27
  • 5.0.0.0_b1.26
  • 5.0.0.0_b1.25
  • 5.0.0.0_b1.24
  • 5.0.0.0_b1.23
  • 5.0.0.0_b1.22
  • 5.0.0.0_b1.21
  • 5.0.0.0_b1.2 - 5.0.0.0_b1.20
  • 5.0.0.0_b1.1

Frequently Asked Questions

• Staging
• Datavault
• Business Rules
• Accesslayer
• Installing DVB