Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Ontop

ontop-vkg.org

  • Free plan
  • Windows
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted
7.8 Club score Visit ontop-vkg.org

What Ontop is

Ontop is an open-source Virtual Knowledge Graph system that lets users query relational database content as knowledge graphs without moving the data from its source databases. It translates SPARQL queries into SQL for execution by connected data sources. Ontop uses RDF 1.1, supports RDFS and OWL 2 QL ontologies, and works with R2RML and Ontop mappings. Its SPARQL support covers most of version 1.1, including aggregation and GeoSPARQL functions. Documented database integrations range from PostgreSQL, MySQL, and Oracle to Snowflake, BigQuery, Redshift, and DuckDB; it also supports federators such as Trino, Denodo, and Apache Spark. Users can run a SPARQL endpoint through the CLI or Docker, create virtual views called lenses, or materialize graphs as RDF files. The CLI also handles metadata extraction, querying, validation, and mapping tasks. Ontop is free under Apache 2.0 and offers a Protégé plugin for editing and testing mappings, though that plugin does not support lenses. Database users must supply the appropriate JDBC driver.

Who it suits

Ontop suits teams that want to expose relational data through knowledge graphs and query it with SPARQL while keeping data in place. It fits users working with its documented databases, federators, and RDF or mapping formats.

Good to know, and what to watch

  • Keeps graph data in its source databases
  • Supports most SPARQL 1.1 features
  • Connects to numerous databases and federators
  • Offers CLI, Docker, and RDF materialization
  • Free and licensed under Apache 2.0
  • Requires users to obtain and place JDBC drivers
  • Protégé plugin does not support lenses
  • Generic JDBC may not handle every setup or query

The verdict

Ontop provides a broad route from relational databases to virtual knowledge graphs, with SPARQL querying and multiple deployment options. Check database-specific connector guidance and the Protégé plugin’s lens limitation before choosing it.

What the maker publishes

CLI capabilities
The CLI includes commands for bootstrapping, starting an endpoint, extracting database metadata, materializing RDF, querying, validating and manipulating mappings. source
Database driver requirement
Users must manually download the JDBC driver for their database system and place it in Ontop's jdbc directory. source
Database integrations
Documented database systems include PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, DB2, Snowflake, Databricks, Google BigQuery, AWS Redshift, DuckDB, AWS DynamoDB, and TDengine. source
Data handling
The graphs are virtual, so data remains in its source databases rather than being moved to another database. source
Deployment
Ontop can be deployed as a SPARQL endpoint using its command-line interface or Docker image. source
Downloads
The project says its distributions are available through GitHub, Docker Hub, SourceForge, and the Protégé plugin repository. source
Federation integrations
Ontop supports database federators including Denodo, Dremio, Teiid, Apache Spark, Trino, PrestoDB, and AWS Athena. source
Generic JDBC caveat
Ontop warns that generic JDBC support is not sufficient for any data source and is not guaranteed to handle every database setup and SPARQL query correctly. source
Generic JDBC limitation
The generic JDBC implementation is not recommended because it may not handle every database setup and SPARQL query correctly; dialect-specific connectors are available for listed systems. source
Headquarters
Bolzano, Italy source
JDBC setup
Users need to download the JDBC driver for their database system and place it in Ontop’s jdbc directory. source
License
Ontop is available under the Apache 2.0 license. source
Mapping editor
A plugin for the Protégé ontology editor lets users edit and test mappings, but it does not support lenses. source
Materialization
Ontop can materialize virtual graphs into RDF files. source
Organizations
The project says it is backed by the Free University of Bozen-Bolzano and Ontopic s.r.l., with regular contributions from Birkbeck, University of London, and Southeast University. source
Other capabilities
Ontop supports lenses as virtual views, can materialize virtual graphs into RDF files, and provides a Protégé plugin for editing and testing mappings. source
Plugin limitation
The Protégé plugin does not support lenses; the documentation recommends text editors or commercial offerings for advanced use. source
Product
Ontop is a Virtual Knowledge Graph system that exposes relational database content as knowledge graphs while leaving data in its source databases. source
Project and license
Ontop was initiated in 2009 by researchers at the Free University of Bozen-Bolzano and is available under the Apache 2.0 license. source
Purpose
Ontop exposes relational database contents as virtual knowledge graphs and translates SPARQL queries into SQL queries executed by the source databases. source
Querying
Ontop translates SPARQL queries over knowledge graphs into SQL queries executed by relational data sources. source
SPARQL support
It supports the majority of SPARQL 1.1 features, including main aggregation functions and GeoSPARQL functions. source
Standards
It uses RDF 1.1, supports RDFS and OWL 2 QL ontologies, and supports R2RML and Ontop mappings. source
Support and commercial offerings
The documentation says Ontopic provides a suite of solutions for leveraging Ontop and Virtual Knowledge Graphs; it does not state a support price or service level on that page. source

Checked against the maker's pages on 8 Oct 2026.