Gnowsis 0.9.2 released
D2RQ Adapter for gnowsis
Document Actions
The D2RQ adapter exposes the contents of relational databases to gnowsis. This page describes the setup of the adapter.
The D2RQ adapter exposes the contents of relational databases to gnowsis. The adapter uses D2RQ and is a contribution by Richard Cyganiak (student at Freie Universität Berlin and intern at HP Labs) to gnowsis.
Installing the adapter takes these steps:
- Download gnowsis_d2rq.war into the /services/ directory under your gnowsis installation.
- Create a D2RQ mapping file for your database. The mapping file tells the adapter how to convert the tables and columns into RDF statements. Check the D2RQ documentation for details.
- Add this line to your ~/.gnowsis/config/workspace.xml, in the <Service> section:
/Users/richard/eclipse/d2rq4gno - Set up a new datasource in gnowsis: Extras > Options, Data Sources, add. There should be an option "Database Adapter".
- Configure the adapter. Give it a name and provide the URL (probably something like file:/C:/myproject/mapping.n3) of the D2RQ mapping file from step 2.
Then, the contents of your database should be available in gnowsis.
For example, to use data from a wordpress weblog, use this D2RQ mapping file: wordpress.n3
Questions and comments are welcome: richard@cyganiak.de
The adapter is GPL licensed. Source code is available.
