%META:TOPICPARENT{name="VirtR2RML"}%

---+Example importing R2RML script for Northwind database and generating RDF Linked Data Views

The following example describes how to import R2RML script for Northwind database using the Virtuoso Conductor R2RML Import Wizard and how to generate the necessary RDF Linked Data Views for Virtuoso hosting and deployment.

---++Prerequisites


Ensure the following VAD packages are installed:

   * [[https://virtuoso.openlinksw.com/download/][rdb2rdf_dav.vad]] R2RML package;
   * [[https://virtuoso.openlinksw.com/download/][conductor_dav.vad]] Conductor package.


---++Basic Steps


   1 Assume the [[VirtConductorR2RMLImportNorthwindScript][following R2RML script]] for the Northwind database.
   1 Go to http://<cname>[:<port>]/conductor:
%BR%%BR%<img src="%ATTACHURLPATH%/rc1.png" />%BR%%BR%
   1 Enter dba credentials:
%BR%%BR%<img src="%ATTACHURLPATH%/rc2.png" />%BR%%BR%
   1 Go to "Linked Data" -> "R2RML" tab:
%BR%%BR%<img src="%ATTACHURLPATH%/rc3.png" />%BR%%BR%
   1 Select the "Choose File" button and select the R2RML file from above to load: 
%BR%%BR%<img src="%ATTACHURLPATH%/rc4.png" />%BR%%BR%
   1 Specify "Target Graph IRI", for ex. <code><nowiki>"http://northwind_r2rml.com"</nowiki></code>:
%BR%%BR%<img src="%ATTACHURLPATH%/rc5.png" />%BR%%BR%
   1 Select the "Validate button" to verify the R2RML mapping script: 
%BR%%BR%<img src="%ATTACHURLPATH%/rc6.png" />%BR%%BR%
   1 Select the "Generate" button to generate the RDF Linked Data Views mappings for the Northwind R2RML mapping script: 
      * Optionally you can set "Physical Graph Name" for ex. as "urn:northwind:r2rml". If the "Generate RDB2RDF triggers" and "Enable Data Syncs with Physical Quad Store" check-boxes are selected, the Physical Graph Name (persistent) can be used to run a SPARQL query against the materialized triples in the Quad Store:
%BR%%BR%<img src="%ATTACHURLPATH%/rc6a.png" />%BR%%BR%
   1 As result the RDF Linked Data View creation should be completed and a status should be displayed:
%BR%%BR%<img src="%ATTACHURLPATH%/rc8.png" />%BR%%BR%
   1 The Default Graph Name (transient) specified from above, i.e. <code><nowiki>"http://northwind_r2rml.com#"</nowiki></code> can now be used to run a SPARQL query against the created Linked Data View:
%BR%%BR%<img src="%ATTACHURLPATH%/rc9.png" />%BR%%BR%
   1 The results set for the Linked Data View graph should be displayed: 
%BR%%BR%<img src="%ATTACHURLPATH%/rc10.png" />%BR%%BR%

---++Related

   * [[VirtR2RML][Virtuoso R2RML Support]]   
   * [[VirtGenerateR2RMLLinkedDataView][Generate Linked Data Views via R2RML from iSQL]]
   * [[VirtConductorR2RMLImport][Virtuoso Conductor R2RML Import Wizard]]
   * [[VirtTipsAndTricksGuideConductorR2RML][Generate Transient and/or Persistent Linked Data Views atop Remote Relational Data Sources]]
   * W3C page for [[http://www.w3.org/TR/r2rml/][R2RML: RDB to RDF Mapping Language]]