Datamart

A treasury data model, predefined and yours to adapt.

OmniFi Datamart is a purpose-built treasury data engineering platform with a best-practice, four-layer reference architecture. It extracts data from across the treasury landscape, models it for analytics, and handles time series, slowly-changing reference data, and back-dated corrections out of the box.

The problem

Building a treasury data warehouse from scratch is a project that never quite ends.

Treasury data lives across TMS, ERP, market data, and banking systems in different shapes and time grains. Teams that want analytics or BI usually face a build-it-yourself data-warehouse project: modelling treasury instruments, handling time series and slowly-changing reference data, and coping with back-dated corrections that force full reprocessing. It is expensive, slow, and needs data-engineering skills treasury teams don't always have.

"Back-dated transactions created significant delays, sometimes running into weeks." Robert Freund, Business Intelligence Analyst, De Nederlandsche Bank. OmniFi Datamart gives you a treasury data model that is predefined yet adaptable.

Key capabilties
01
Best-practice treasury data model
A reference architecture covering market valuation, transactions, cashflows, performance, risk, allocation, and settlement. Deploy as-is, or adapt to your own model.
02
Native extraction across the treasury landscape
Extracts directly from treasury, ERP, and market data systems through OmniFi's connector framework with no separate integration project.
03
Built for time-series treasury data
Three model principles cover the range: time series for point-in-time snapshots, slowly-changing for versioned reference data, and incremental for append-only event streams.
04
Back-dating handled
Intelligent change detection reprocesses only the affected records when corrections arrive, not the full history.
05
No-code data modelling
Build and adapt the model in OmniFi Web. Treasury specialists shape the model themselves with no SQL or data engineering required.
06
Use it directly, or feed it onward
Consume through OmniFi Reporting and dashboards, expose as APIs for Power BI or Tableau, or feed Snowflake or your enterprise data warehouse.
07
Full audit trail
Every transformation, load, and back-dated correction is logged and versioned for compliance and traceability.
08
Flexible deployment
Runs on your own MSSQL Server, whether a separate instance, a SQL Server farm, the cloud, or alongside existing infrastructure.

Use cases

Treasury analytics and consolidated position reporting

A single source of truth across treasury, ERP, and bank data, ready for BI tools without per-report data wrangling.

Cross-system trend analysis and historical reporting

Time-series storage with full version handling enables longitudinal analysis without spreadsheet gymnastics.

Liquidity, risk, and exposure dashboards

Combine balances, transactions, valuations, and market data in modern BI dashboards.

Foundation for AI-powered treasury analysis

Expose structured, audit-ready treasury data to LLMs and AI agents through OmniFi's built-in MCP server.

Curated feed for an enterprise data warehouse

Deliver clean, modelled treasury data into Snowflake, Databricks, or your data lake as the treasury domain layer.

De Nederlandsche Bank
Data warehouse and reporting at scale

De Nederlandsche Bank needed to consolidate large volumes of time-series data from multiple operational systems quickly enough to support daily reporting cycles. Back-dated transactions were creating delays of weeks. SkySparc deployed OmniFi Datamart with parallelised extraction and intelligent back-dating logic. Result: processing time cut from over 100 hours to overnight, with next-day data availability.

Datamart
works well with
OmniFi Reporting

The natural consumption layer for Datamart: build dashboards, schedule report packs, and distribute outputs with no separate BI server.

OmniFi Reconciliation Hub

Feed reconciled, validated data into the data warehouse so analytics run on numbers already matched and signed off.

OmniFi Platform MCP

Expose Datamart data to AI agents and LLMs through the platform's built-in MCP capability, securely and with role-based access.

Your TMS Platform
OmniFi Datamart models data from across the treasury landscape through OmniFi's connector framework.

Running a different platform? Get in touch

Wallstreet Suite
Native Integration
FIS Quantam
Native integration
FIS Integrity
Native integration
Kyriba
Native integration
Calypso
Native integration

Put your treasury data to work

Book a demo and we'll show you how Datamart gives you an analytics-ready treasury data model without the build-it-yourself project.