Skip links

OntoStudio X

The Spreadsheet-Native IDE for Explainable Knowledge Systems

Meet OntoStudio

OntoStudio X is a lightweight, Excel-based IDE that brings OntoBroker’s full Java API and ObjectLogic capabilities directly into spreadsheets. No VBA macros are needed—queries and rules return results as cell values or dynamic arrays, and intermediate objects can be named and reused across formulas. It lets engineers and domain experts model, run, and audit active ontologies entirely within Excel.

Turn Spreadsheets Into…

Knowledge Capture

Knowledge capture and rule authoring by subject-matter experts

Ontology Debugging

Interactive querying, validation, and debugging of enterprise ontologies

Explainable Apps

Building explainable, spreadsheet-driven apps that leverage OntoBroker reasoning

Core Capabilities

Run ObjectLogic queries (e.g., =OB.QueryO(...)) and spill the results into dynamic arrays—perfect for large answer sets from OntoBroker.

Seamlessly connect structured and unstructured data across silos. Leverage standards-based connectors to unify data from databases, APIs, and enterprise knowledge graphs.

 

Connect to several OntoBroker servers at once and reference multiple ontologies in the same file—practically as many as your workbook (and Excel) can hold.

Integrate with OntoBroker through the bundled Java and Python bridges; spreadsheets remain macro-free .xlsx files.

Author higher-order rules and run them on OntoBroker 6.x from inside Excel; benefit from ObjectLogic’s expressive frames, parametrized relations, and built-ins.

✦ Process

How it works

Connect

Create a Manager to one or more OntoBroker servers and bind named ontology objects in the workbook.

Model

Declare axioms/rules using ObjectLogic via worksheet functions (with syntax-colored editing on F2).

Query

Execute queries that spill to dynamic arrays for large, automatically sized result tables.

Automate

Call Java/Python helpers where needed; intermediate objects appear as named references in cells.

Feature Updates

What´s new

Additions
In-Cell VS Code Editing

Press F2 to open the active cell content in VS Code; save and exit to sync changes back into the sheet.

Google Analytics

The F2 editor highlights ObjectLogic constructs for faster reading and fewer mistakes.

Still have a question? Browse documentation.

Let’s build together

Ready to unlock transparent AI for your enterprise?
Take the first steps in your transformation

Explore
Drag