Product Information

Features Vaultspeed

  • DWH automation from Analysis to Version Management
  • According to Data Vault 2.0 Standards
  • Fully Configurable according to Customer Standards & Guidelines
  • Versioned sources, Data Vaults and Business Vaults
  • Generates Integrated Raw Data Vault DDL & ELT
  • Cloud Architecture
  • Generate Business Vault Abstraction layer
  • Incorporate 9 years of Enterprise Data Warehouse Implementations using Data Vault as a foundation Layer
  • 10 existing clients from Version 1.0 to 3.0
  • All Objects:
    • Hubs,
    • Satellites
    • Links
    • Many to Many Links, Hierarchical Link, Same as Link, Non-historized Link
    • Reference tables
    • PITs
    • Bridges
    • Exploration links (links across sources)
  • Extended Features:
    • Satellite splitting
    • Multi-Master Hubs – Links – Many to Many Links
    • Multi-Active Satellite Row Support
      • Subsequence
    • Non Primary Key, Business Keys
    • Satellite objects
    • Graphical source editor
    • Apache Airflow support for scheduling and executing loads
    • ADF support for scheduling and executing loads
    • Metadata exports and imports
    • Query generation
    • Vaultspeed studio: write templates to create custom BV objects.
  • Multi-Source:
    • basic agent: Oracle, PostgreSQL (+ derivatives like Greenplum), SQL Server(+Azure Synapse), Apache Hive, Databricks(Delta Lake), Informix, Snowflake
    • Flat files through the cloud app (File source formats)
    • extended agent: Confluent Kafka
    • extended agent: All JDBC sources (Any JDBC Driver can be added) which provide metadata such as salesforce, IBM db2, MongoDB, Amazon Athena, Google BigQuery, Apache Spark, JSON, REST, Google Spreadsheets, FTP servers...
  • Multi-Target:
    • Oracle SQL
    • Oracle ODI (Groovy)
    • PostgreSQL, Pivotal Greenplum & AWS Redshift
    • Talend ELT (Oracle, Postgres and derivatives, SQL Server(beta), Snowflake) 
    • Microsoft T-SQL for SQL server and Azure Synapse
    • Snowflake SQL
    • Google Bigquery (beta)
    • Exasol (Work in progress)
    • Spark SQL batch (beta)
    • Matillion ETL (Work in progress)
    • Spark streaming (Work in progress)
    • Kafka streaming (Work in progress, available through our partner Reeeliance)