Native Interfaces
Python
Governed access to real-time and resting data from the Application Fabric to DataFrames.
Function inside the fabric
From research to production
3forge Enterprise brings real-time and historical data into the tools teams already use. Python applications access the existing data estate through one governed fabric rather than through separate source integrations.
- Programmatic interface to the Fabric
- Query current and historical data, subscribe to live updates
- Publish results back into 3forge, where authorized
- SQL query straight into a pandas DataFrame
- Asynchronous queries, live subscriptions, failover and sharding as requirements grow
Capabilities
The pyami-3forge package
The package supports several development models:
- A compiled real-time client for queries, publishing and live subscriptions
- DB-API 2.0 for standard Python database workflows
- A SQLAlchemy dialect for Core, ORM, schema inspection and pandas
- A lightweight pure-Python JDBC client for straightforward query-to-DataFrame access
Interactive research
- Quant research and signal development
- Ad-hoc analysis on live or historical data
- Model validation and backtesting
- Risk investigations
Quantitative and data science
- Factor modeling
- Portfolio optimization
- Scenario simulations
- ML-based risk or execution models
Production automation
- Scheduled reporting
- Overnight risk runs
- Data reconciliation jobs
- Automated regulatory exports
Applications and services
- Internal tooling
- Data APIs
- Risk services
- Workflow automation
Example usage
Snapshot a live 3forge table into a DataFrame
A snap gives you a pandas DataFrame holding the live board. Everything after this is ordinary Python.
Programming with the Application Fabric
Discover the Workbench
The browser-based IDE to explore, develop, and fine-tune the Application Fabric.