Ontorion™ SPARQL Tools for Excel

Thank you for choosing Ontorion™ SPARQL Tools for Excel. Below you will find basic information about this software.

  1. Introduction
  2. Importing from a SPARQL Endpoint
  3. Importing from an Ontorion Server


The Ontorion™ SPARQL Tools for Excel has been developed by Cognitum and is part of Ontorion Semantic Platform. This addin can be used to download knowledge from a SPARQL endpoint or from an Ontorion endpoint. This addin works with MS Excel 2010 and MS Excel 2013.

Importing from a SPARQL Endpoint

To import from a SPARQL endpoint, go to the Ontorion tab and click import from SPARQL and a form will show

In which we can specify the address of the SPARQL Endpoint and the query we want to execute. By default we are loading a simple exploratory to the Bathing Water Quality endpoint of the UK government. Under the query text box there is a Load Query that will show you the last queries executed in your computer. Furthermore in the SPARQL endpoint dropdown list you will find the recently used SPARQL endpoints.

Then after clicking Execute, the query is sent to the SPARQL endpoint

and the result is downloaded in Excel where each variable retrieved in the SPARQL query will be shown in a column of your Excel worksheet.

Here you can see the result of the default query.

And here the result of a more complex query (taken from the Bathing Water Quality endpoint)

After the query has been executed, the Change Query and Refresh buttons will be enabled. By clicking Change Query it will be possible to change the current query or endpoint while by clicking Refresh the data will be downloaded again from the SPARQL endpoint.

Importing from an Ontorion Server

Here it is possible to give the address of the Ontorion Server Endpoint. After filling this field the addin will automatically download the Database list from Ontorion and enable the query button. It is then possible to write a Ontorion CNL query in the text field and the application will suggest possible sentences. Finally by clicking Execute the data will be retrieved from Ontorion and loaded in Excel.

To import from an Ontorion endpoint, go to the Ontorion tab and click import from Ontorion and a form will show

After inserting the Ontorion Endpoint address and clicking Tab, we will automatically try to connect to Ontorion to show the current databases in it

Then you can select from the list of databases currently present in Ontorion. In order to show you the behaviour we have loaded into Ontorion the IT infrastructure example. In order to see how the knowledge is organized in this Example , you can download Fluent Editor and load the IT Example.

When a database is selected, it is possible to write a CNL query in the CNL query field. As you can see, an autocomplete functionality will hint you which concepts/roles/attributes/instances present in the Database you can ask for.

If for example we ask for the instances that are in the class "a server"

We will ask Ontorion

And get back the instances that are stored in Ontorion with its attributes or roles

In this case we retrieve two instances (Server-1 and Server-2) that both have one attribute "host" with value Application-1 (-2). This was written in the knowledge in Ontorion CNL as:

Server-1 is a server.
Server-1 hosts Application-1.
Server-2 is a server.
Server-2 hosts Application-2.

or (as the Ontorion-CNL is equivalent to OWL/RDF) we can write the sentences in its OWL equivalent (for Server-1):

  <Class IRI="Server" />
  <NamedIndividual IRI="Server1" />

  <ObjectProperty IRI="hosts" />
  <NamedIndividual IRI="Server1" />
  <NamedIndividual IRI="Application1" />