Using Ontorefine to import data from a Postgresql database

136 views Asked by At

I am using GraphDD 9.5 Free and I would like to import data from a Postgresql database (version 13 installed on a Windows 64 bits machine). However, after I add the connection settings, even if it looks like I'm connected when I run a simple select query I don't get any data (it keeps sending requests). enter image description here

1

There are 1 answers

0
vassil_momtchev On

GraphDB 9.5 Free has a new data virtualization feature that allows you to directly query a PostgreSQL database using an Ontop repository (a virtual SPARQL to SQL translation layer).

From the screenshot it is not fully clear if the issue appears only if you change the parsing settings or the first time you load the data. Please note that OpenRefine loads all data in memory so its scalability is limited to the available RAM.