Generate Transient and/or Persistent Linked Data Views atop Remote Relational Data Sources

This simple scenario demonstrates how you can generate R2RML Scripts from Linked Data Views, using the Virtuoso Conductor ODBC or JDBC accessible.

Prerequisites

• Your Virtuoso Conductor VAD package must be version 1.32.38 or higher.

Steps

1. Go to http://<cname>[:<port>]/conductor.
2. Enter dba credentials.
3. Go to Linked Data -> Views:
   
   
   
   
4. Select Qualifier Demo:
   
   
   
   
5. Select table(s) by hatching the check-box to the left of the table name; for example, select the following tables from the Northwind DB: Categories, Customers, Employees, Order_Details, Orders, Products .
   
   
   
   
6. Click Generate via Wizard:
   
   
   
   
7. Click Prepare to Execute.
8. The R2RML script for the selected table(s) will be generated and displayed in the R2RML Graph text-area:
   
   
   
   
   
   
9. You can also view the R2RML script generated while writing this example.

Related

• Virtuoso R2RML Support
• Generate Linked Data Views via R2RML from iSQL
• Virtuoso Conductor R2RML Import Wizard
• W3C page for R2RML: RDB to RDF Mapping Language