Optimal Data Engine

What is ODE?

ODE helps you build a modern, agile data warehouse with minimal cost. ODE is an orchestration engine that stores your Data Vault metadata, executes custom-written ETL stored procedures or simple generated SSIS packages and loads the data on schedule.

Functions of ODE

Available functions

  • Builds the Data vault and loads data into it based
    on the provided metadata
  • Runs loads on schedule and alerts if something
    goes wrong
  • Executes custom-written ETL stored procedures
    or generated SSIS packages to load the data
    from the remote data source.

What makes ODE special?

  • Orchestrates one or more data vaults on one server
  • Supports incremental and parallel development
  • Supports change data capture
  • Your first Data Vault in minutes for free
  • Stored metadata includes the lineage
  • It’s open source!

What is Data Vault

Data Vault is an agile data warehousing methodology to build data warehouses. It is robust, stable and also flexible, adaptable and repeatable. Data Vault can be changed as business requirements change, whilst keeping old business rules for reporting. Find out more about data vault.