Integration
Durable delivery, in-flight transformation, and content-based routing across feeds, databases, and legacy platforms, without bespoke integration code.
Move data with confidence
From feed to fabric, guaranteed
Financial workflows depend on the continuous, reliable movement of data between systems, from market feeds, trading systems, and risk engines, through transformation and routing logic, to downstream applications and audit trails. 3forge consolidates this movement into a single fabric: a unified access layer for connectivity, durable journaled messaging, content-based routing, and in-flight transformation, all without bespoke code for each protocol or counterparty.
Consuming data and virtualizing access
With over 35 database adapters and 15 feed adapters, 3forge can consume real-time and resting data from virtually any source, and present it as a unique access point to data consumers. By insulating downstream apps from idiosyncratic data formats, 3forge accelerates project deployments, implements explicit access control, and performance management. Once in 3forge, the data can be queried via the REST API, JDBC, ODBC, MCP, as well as through bidirectional libraries in .Net, Python, Java, and RPC between the 3forge Relays and external systems.
Whether the data is consumed by users on UI screens, PDF and email reports, AI language models, or third-party applications, 3forge can mesh different datasets, augment them with derived analytics updated as data changes, and protect them with granular entitlement.
Supported Database Adapters
- AMI DB
- Flat File
- AMI Shell
- Excel
- Fred
- Quandl
- Oracle
- Msft SQL
- MySQL
- Apache Spark
- SAP Sybase
- SybaseIQ
- KX
- Hadoop
- Mongo DB
- R
- Impala
- PostgreSQL
- Phoenix
- Chronicle Queue
- Netezza
- MemSQL
- Couchbase
- SQLite
- REST API
- Snowflake
- Hazelcast
- IBM DB2
- Greenplum
- Symphony
- HP Vertica
- Hive
- Deephaven
- Bloomberg
- Apache Ignite
- Redis
Supported Feed Handlers
- SingleStore
- Solace
- Tibco
- RabbitMQ
- KX Stream
- Chronicle Queue
- IBM MQ
- OneTick
- FIX
- Amazon SQS
- Aeron
- Kafka
- ActiveMQ
- 60 East-Amps
- BPIPE
- QuantHouse
- Google RPC
Programmatic Access
- REST API
- JDBC
- .NET
- Python
- Java
- ODBC
- Google RPC
- C++
- MCP
Dynamic message routing & map reduce
3forge enables dynamic routing rules that intelligently dispatch messages to specialized processing centers based on content, load, or custom logic, all configurable in real time. Each center can independently process its portion of the workload before the results are seamlessly merged through a map-reduce operation. This architecture ensures optimal resource utilization, parallel processing, and high-performance aggregation across distributed systems.
Guaranteed messaging
Guaranteed messaging ensures that every critical update is durably persisted and delivered reliably, regardless of system load or transient network conditions. Messages are journaled to a write-ahead log (WAL), allowing downstream centers, including those temporarily offline, to recover and replay missed data upon reconnection. While guaranteed messaging does not perform duplicate suppression, it provides the durability and continuity required for real-time trading, risk, and compliance systems.
Message transformation and routing
3forge includes powerful message transformation capabilities, allowing firms to inspect, modify, enrich, or filter messages in-flight, all without writing custom code. This is especially valuable for FIX and other financial protocols, where dynamic adjustments may be required to support different counterparties, normalize formats, redact sensitive fields, or route based on content. With support for declarative rules and scripting, 3forge enables rapid, flexible logic tailored to evolving trading and compliance needs.
Python
With its Python libraries built in C++, 3forge makes its data accessible to Python applications including notebooks.
Deep Python integration
A bespoke API with Pandas integration lets query results be efficiently modeled as DataFrames, and DataFrames be published back to 3forge.
DBAPI & SQLAlchemy
The library includes DBAPI support and a SQLAlchemy dialect. The real-time client supports full-duplex streaming and lets users subscribe to real-time tables.
Virtualized access to data
3forge eliminates the need to replicate large datasets, so analysts can query across Snowflake, Databricks, APIs, or internal warehouses instantly.
Smart dataset meshing
3forge handles key alignment and correlation across formats and sources, unlocking richer insights.
Direct path to production
Signals, alerts, and dashboards built in 3forge can move from research to live with no re-platforming.
Third-party feeds
In-house
Data warehouse
Interactive research & exploration
- Jupyter Notebook / JupyterLab
- VS Code Python notebooks
- Python REPL / IPython
Use for
- Quant research and signal development
- Ad-hoc analysis on live or historical data
- Model validation and backtesting
- Risk investigations
Production & automation
- Airflow or scheduler orchestration
- Batch Python jobs
- Cron-triggered scripts
- CI/CD or automation pipelines
Use for
- Scheduled reporting
- Overnight risk runs
- Data reconciliation jobs
- Automated regulatory exports
Quant & data science frameworks
- pandas / NumPy
- scikit-learn
- TensorFlow or PyTorch
- Optimization libraries
Use for
- Factor modeling
- Portfolio optimization
- Scenario simulations
- ML-based risk or execution models
Services & APIs
- FastAPI / Flask apps
- Python microservices
- Containerized services
- Internal REST endpoints
Use for
- Internal tooling
- Data APIs
- Risk services
- Workflow automation
ODBC
The 3forge ODBC Adapter connects the 3forge database to the desktop tools analysts already use every day. It allows spreadsheets, BI platforms, and reporting tools to query governed, real-time, finance-native data directly from 3forge, without rebuilding complex logic in disconnected files. Teams can keep their familiar front-end tools while centralizing heavy data processing, enrichment, and control within the Application Engine for Finance.
Direct connectivity to 3forge data
Use the 3forge database as a live data source from Excel and other ODBC-compatible tools.
Centralized heavy lifting
Perform joins, enrichments, filters, and real-time aggregations inside 3forge rather than recreating complex logic in spreadsheets.
Governed and version-controlled logic
Data models and calculations are managed centrally, with full visibility into the implemented logic.
Enterprise-grade security
Fine-grained entitlements, auditability, and optional encryption at rest and in transit.
Seamless spreadsheet integration
Preserve existing spreadsheet models while shifting data engineering and transformation into a controlled, scalable runtime.
Broad ecosystem support
Compatible with business intelligence and reporting platforms that support ODBC, extending governed 3forge data into dashboards, analytics, and automated reports.
The result is a transition from fragmented, file-based workflows to a structured, auditable, and performance-optimized data backbone, without disrupting how users prefer to analyze information.
Next steps
Move your most critical data with confidence.
Book a 30-minute demo with a 3forge solutions engineer.