Optimal Data Engine
Optimal Data Engine is an Ackama product that lets organisations build a modern data warehouse with minimal cost.
Optimal Data Engine is an Ackama product that lets organisations build a modern data warehouse with minimal cost.
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.
→ 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.
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.
→ 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.
And it’s open source!
Squareweave is now Ackama.
We've merged with New Zealand company Ackama!
We're excited to be working with our Kiwi colleagues to deliver ambitious, purposeful digital products on both sides of the Tasman.
Common Code is now part of Ackama.
We’re now part of Ackama, delivering purposeful technology across the Asia-Pacific.
Together, we’re creating impact across energy, government, international development, and beyond. Delivering pragmatic, innovative solutions where they matter most.