Skip to main content

Main

Documentation

Reference Guide

beVault User Reference Guide

beVault Homepage

beVault Modules

Build

Graph Editor

Entities

Hub's dynamic tab
Link's dynamic tab
Satellite's dynamic tab
Refence table's dynamic tab

Source

Source Systems

Data Packages

Staging Tables

Mapping

Verify

Data Quality

Distribute

Information Mart

Admin

Projects Management
Users management
Groups management
License Management

Global sub-modules

Versions
Snapshots

Configure

Environments
Import/Export

States User Reference Guide

Introduction to dFakto States
States Home Page
State Machines
Activities

Webhooks - States

How-to generate a Webhook URL

Settings

Secret Management
RSS Feeds

Workers Reference Guide

Stores

Directory File Store
MySql Db Store
ODBC Db Store
Oracle Store
Excel Db Store
Ftp File Store
PostgreSql Db Store
Gitlab Store
Sftp File Store
S3 File Store
SqlServer Db Store
Snowflake Db Store
IBM db2 Db Store

Workers

Compress / Decompress with GZip
HTTP Request
List Files in FileStore
Delete Files in FileStores
Load data into a Database Table
Load data into a Database Table from Json
Execute an SqlQuery into a dbstore
Get the next execution dates of a CRON expression
Export Sql query result to csv
Export Sql query result to json
Execute State Machine
Map Execution
Move files from one filestore to another
Enrich postal Addresses with Geoapify web service
Refresh Business Object Report
Refresh Tableau Data Source
Get Authentication token for Ungerboeck
Upload a file to ToucanToco
Refresh ToucanToco

Import / Export from Builtin Worker

Architecture & Installation

Requirements

Identity provider configuration

Keycloak configuration
Microsoft Entra (ex Azure Active Directory) configuration

Supported target database configuration

PostgreSQL configuration

Deployment

Local deployment

Production deployment

NGINX Proxy & HTTPS

Advanced configuration

Metavault Configuration
States Configuration
Workers Config
beVault UI configuration
States UI configuration

Explanations

Data Workflows
Data Type correspondence
How to build a Bridge Table
Generated Tables
beVault naming convention

Tutorials

beVault Tutorial - Step-by-step guide

1. Installation
2. Create a Project
3. Create Environment
4. Build your data model

5. Manage sources and data packages

5.1. Create Source Systems
5.2. Create data packages
5.3 Create staging tables

6. Create a Mapping
7. Verify your data
8. Create and deploy a Version
9. Automate your dataFactory
10. Create Information Marts

Tutorial Scenario - WonderCar

Tutorial - 🏭 beVault

Tutorial - 💧 Source systems

Tutorial - 💧 DriveNexus (CRM)

Tutorial - CRM - Employees
Tutorial - CRM - Cars
Tutorial - CRM - Customers
Tutorial - CRM - Contracts

Tutorial - 💧StaffForce (HR system)

Tutorial - HR system - Employees
Tutorial - HR system - Shops

Tutorial - 💧CarRepair (Maintenance)

Tutorial - Maintenance - Tasks

Tutorial - 🗃️ dataModel

Tutorial - 🗃️ dFakto cars

Tutorial - 🗄️ Information Marts

Tutorial - 🗄️ IM contract

Tutorial - C_Dimensions

Tutorial - Dimension Employee
Tutorial - Dimension Car
Tutorial - Dimension Customer
Tutorial - Dimension Contract
Tutorial - Dimension Shop

Tutorial - C_Facts

Tutorial - Fact contract details

Releases Notes

Release note - beVault 3.8
Release note - beVault 3.7
Release note - beVault 3.6

Release note - beVault 3.5

beVault 3.5 - Impact and migration

Release note - beVault 3.4
Release note - beVault 3.3
Release note - beVault 3.2
Release note - beVault 3.1

Release note - beVault 3.0

beVault 3.0 - Impact and migration

Release Note - beVault 2.1
Release note - beVault 2.0

How tos

How to extract data from a database?
How to extract data from an API?
How to configure a Store for States' Workers?

Main

Reference Guide

beVault User Reference Guide

beVault Homepage

beVault Modules

Build

Graph Editor

Entities

Hub's dynamic tab
Link's dynamic tab
Satellite's dynamic tab
Refence table's dynamic tab

Source

Source Systems

Data Packages

Staging Tables

Mapping

Verify

Data Quality

Distribute

Information Mart

Admin

Projects Management
Users management
Groups management
License Management

Global sub-modules

Versions
Snapshots

Configure

Environments
Import/Export

States User Reference Guide

Introduction to dFakto States
States Home Page
State Machines
Activities

Webhooks - States

How-to generate a Webhook URL

Settings

Secret Management
RSS Feeds

Workers Reference Guide

Stores

Directory File Store
MySql Db Store
ODBC Db Store
Oracle Store
Excel Db Store
Ftp File Store
PostgreSql Db Store
Gitlab Store
Sftp File Store
S3 File Store
SqlServer Db Store
Snowflake Db Store
IBM db2 Db Store

Workers

Compress / Decompress with GZip
HTTP Request
List Files in FileStore
Delete Files in FileStores
Load data into a Database Table
Load data into a Database Table from Json
Execute an SqlQuery into a dbstore
Get the next execution dates of a CRON expression
Export Sql query result to csv
Export Sql query result to json
Execute State Machine
Map Execution
Move files from one filestore to another
Enrich postal Addresses with Geoapify web service
Refresh Business Object Report
Refresh Tableau Data Source
Get Authentication token for Ungerboeck
Upload a file to ToucanToco
Refresh ToucanToco

Import / Export from Builtin Worker

Architecture & Installation

Requirements

Identity provider configuration

Keycloak configuration
Microsoft Entra (ex Azure Active Directory) configuration

Supported target database configuration

PostgreSQL configuration

Deployment

Local deployment

Production deployment

NGINX Proxy & HTTPS

Advanced configuration

Metavault Configuration
States Configuration
Workers Config
beVault UI configuration
States UI configuration

Explanations

Data Workflows
Data Type correspondence
How to build a Bridge Table
Generated Tables
beVault naming convention

Tutorials

beVault Tutorial - Step-by-step guide

1. Installation
2. Create a Project
3. Create Environment
4. Build your data model

5. Manage sources and data packages

5.1. Create Source Systems
5.2. Create data packages
5.3 Create staging tables

6. Create a Mapping
7. Verify your data
8. Create and deploy a Version
9. Automate your dataFactory
10. Create Information Marts

Tutorial Scenario - WonderCar

Tutorial - 🏭 beVault

Tutorial - 💧 Source systems

Tutorial - 💧 DriveNexus (CRM)

Tutorial - CRM - Employees
Tutorial - CRM - Cars
Tutorial - CRM - Customers
Tutorial - CRM - Contracts

Tutorial - 💧StaffForce (HR system)

Tutorial - HR system - Employees
Tutorial - HR system - Shops

Tutorial - 💧CarRepair (Maintenance)

Tutorial - Maintenance - Tasks

Tutorial - 🗃️ dataModel

Tutorial - 🗃️ dFakto cars

Tutorial - 🗄️ Information Marts

Tutorial - 🗄️ IM contract

Tutorial - C_Dimensions

Tutorial - Dimension Employee
Tutorial - Dimension Car
Tutorial - Dimension Customer
Tutorial - Dimension Contract
Tutorial - Dimension Shop

Tutorial - C_Facts

Tutorial - Fact contract details

Releases Notes

Release note - beVault 3.8
Release note - beVault 3.7
Release note - beVault 3.6

Release note - beVault 3.5

beVault 3.5 - Impact and migration

Release note - beVault 3.4
Release note - beVault 3.3
Release note - beVault 3.2
Release note - beVault 3.1

Release note - beVault 3.0

beVault 3.0 - Impact and migration

Release Note - beVault 2.1
Release note - beVault 2.0

How tos

How to extract data from a database?
How to extract data from an API?
How to configure a Store for States' Workers?

Breadcrumbs

Documentation
Tutorials
Tutorial Scenario - WonderCar
Tutorial - 🏭 beVault
Tutorial - 🗄️ Information Marts

On this Page

Tutorial - 🗄️ IM contract

dFakto cars_tuto_IM.png

Original file (for update purpose on https://www.draw.io/) :

dFakto cars_tuto_IM.draw…

Tutorial - C_Dimensions

Tutorial - Dimension Employee
Tutorial - Dimension Car
Tutorial - Dimension Customer
Tutorial - Dimension Contract
Tutorial - Dimension Shop

Tutorial - C_Facts

Tutorial - Fact contract details

beVault.io

Powered by Scroll Sites & Atlassian Confluence