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

---+ 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 [[https://virtuoso.openlinksw.com/download/][Conductor VAD package]] must be version 1.32.38 or higher.   

---++ Steps

   1 Go to <code><nowiki>http://&lt;cname&gt;[:&lt;port&gt;]/conductor</nowiki></code>.
   1 Enter dba credentials.
   1 Go to <b>Linked Data</b> -> <b>Views</b>:
%BR%%BR%<img src="%ATTACHURLPATH%/r0.png" />%BR%%BR%
   1 Select Qualifier <b>Demo</b>:
%BR%%BR%<img src="%ATTACHURLPATH%/r00.png" />%BR%%BR%
   1 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: <code>Categories, Customers, Employees, Order_Details, Orders, Products </code>.
%BR%%BR%<img src="%ATTACHURLPATH%/r1.png" />%BR%%BR%
   1 Click <b>Generate via Wizard</b>:
%BR%%BR%<img src="%ATTACHURLPATH%/r2.png" />%BR%%BR%
   1 Click <b>Prepare to Execute</b>.
   1 The R2RML script for the selected table(s) will be generated and displayed in the <b>R2RML Graph</b> text-area:
%BR%%BR%<img src="%ATTACHURLPATH%/r3.png" />%BR%
<img src="%ATTACHURLPATH%/r4.png" />%BR%
<img src="%ATTACHURLPATH%/r5.png" />%BR%%BR%
   1 You can also view the R2RML script [[VirtTipsAndTricksGuideConductorR2RMLGenR2RML][generated while writing this example]].


---++Related

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