atomgraph/ontop repository overview

Ontop is a platform to query relational databases as Virtual RDF Graphs using SPARQL. It's fast and is packed with features.

⁠ENV parameters

• ONTOP_JDBC_NAME - name of the DB connection
• ONTOP_JDBC_URL - JDBC URL for the data source
• ONTOP_JDBC_USER - JDBC username
• ONTOP_JDBC_PASSWORD - JDBC password
• ONTOP_JDBC_DRIVER - JDBC driver classname
• ONTOP_JDBC_PROPERTIES - JDBC property file name
• ONTOP_MAPPING - ontop mapping file name
• ONTOP_ONTOLOGY - ontop ontology file name
• ONTOP_BASE_IRI - ontop mapping base URI
• ONTOP_REPOSITORY_ID - RDF4J Workbench repository ID
• ONTOP_REPOSITORY_TITLE - RDF4J Workbench repository title

⁠JDBC connectors

Check vendor-specific JDBC details here: https://github.com/ontop/ontop/wiki/ObdalibPluginJDBC⁠

The following JDBC connectors are built-in:

• H2 1.4.190⁠
• MySQL 8.0.12⁠
• PostgreSQL 42.2.4⁠
• MS SQL Server 7.0⁠

⁠Build

Run the ./build-image.sh⁠.

⁠Deployment

Example with MySQL DB:

docker run -d --name mysql -e MYSQL_ROOT_PASSWORD=obda -e MYSQL_USER=ontop_user -e MYSQL_PASSWORD=ontop_pwd -e MYSQL_DATABASE=ontop_db -p 3306:3306 mysql:5.7.23

docker run --name=ontop -e ONTOP_JDBC_NAME=test -e ONTOP_JDBC_URL=jdbc:mysql://172.17.0.2:3306/ontop_db -e ONTOP_JDBC_DRIVER=com.mysql.cj.jdbc.Driver -e ONTOP_JDBC_USER=ontop_user -e ONTOP_JDBC_PASSWORD=ontop_pwd -e ONTOP_BASE_IRI=http://test/ -e ONTOP_REPOSITORY_ID=mysql -e ONTOP_REPOSITORY_TITLE=MySQL -p 8080:8080 atomgraph/ontop

Note that 172.17.0.2 is an address of mysql container in the internal Docker network. It can be obtained by performing docker inspect mysql and copying the value under NetworkSettings > IPAddress.

SPARQL endpoint over ontop_db will be accessible under http://localhost:8080/rdf4j-workbench/repositories/${ONTOP_REPOSITORY_ID}, so in this case http://localhost:8080/rdf4j-workbench/repositories/mysql.