Native Interfaces

Governed Enterprise Data in Excel and BI

Real-time and historical data into the tools teams already use, through one governed fabric rather than separate source integrations.

Function inside the fabric

The tools teams already use, on governed data

3forge Enterprise brings real-time and historical data into the tools teams already use. Excel workbooks, Tableau, Power BI and other compatible systems access the existing data estate through one governed fabric rather than through separate source integrations.

Excel, Tableau, Power BI, Python, notebooks and internal apps reaching the Application Fabric through the 3forge ODBC driver and the 3forge RTD Server
Two interfaces onto one governed access point for real-time and resting data.

Capabilities

Query access and live values

ODBC: governed query access for existing business tools

  • The 3forge ODBC driver gives Excel, Tableau, Power BI and other compatible applications governed access to data in the Application Fabric
  • Users can browse tables, run queries and refresh datasets through one managed connection, with configurable row limits, timeouts, encryption and failover

Excel RTD: live values without polling

  • The RTD interface pushes live data directly into individual Excel cells, allowing existing formulas, models and controls to update without polling or full-table refreshes
  • Use RTD for live prices, positions, limits, alerts and operational status

Example usage

One formula, updating in place

An RTD formula in a cell resolves to a live value from the fabric, so existing formulas, models and controls keep working as the data moves.

An Excel workbook with an RTD formula in the formula bar and live values updating across two Centers
Live values from two Centers, in an ordinary workbook.

Choose the native interface that fits the workflow

  • Python supports programmatic analysis, automation, model development and production services
  • ODBC provides governed query access for Excel, Tableau, Power BI and other business applications
  • Excel RTD delivers live updates to individual cells

Use each interface independently or combine them within the same workflow.

From research to production

Excel and BI reach the fabric through a driver. Python reaches it through code.

The same governed data, as a programmatic interface for notebooks, models and production services.

Explore Python Explore the Application Fabric