| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| |
| maker
| |
| Title
| |
| isDescribedUsing
| |
| has creator
| |
| attachment
| |
| content
| - %META:TOPICPARENT{name="VirtRdb2RDFViewsGeneration"}%
---+ Virtuoso Linked Data Views for the Microsoft SQL Server Northwind Database
This document details the steps required for building RDF-based Linked Data views of schema objects in Microsoft SQL Server data sources, using the sample Northwind database.
1 Go to the Virtuoso Conductor (<code>http://<cname>:port/conductor</code>). Note, the appropriate cname (hostname) and port number for dereferencing URIs must be set for the <code>[[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#ini_URIQA][URIQA:DefaultHost]]</code> Virtuoso configuration parameter before creating the Linked Data Views.
1 Log in as user <b><code>dba</code></b> (or another user with DBA privileges).
1 If not already done [[VirtMSSQLLinkingObjects][Link the Microsoft SQL Server tables into OpenLink Virtuoso]].
1 Select the <b>Database</b> -> <b>Linked Data Views</b> tab of the Conductor.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_01.png" style="wikiautogen"/>%BR%%BR%
1 Select the <b>Database Name Qualifier</b> (e.g., "<code>NWND</code>") that exposes the Tables / Views for this exercise.
1 Enter the <b>Base URL</b> to which your URL rewrite rules will be bound (e.g., <code>http://<cname>:8890/P2</code>).
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_02.png" style="wikiautogen"/>%BR%%BR%
1 Select the specific Tables containing the data to be published.
1 Choose <b>Generate via Wizard</b> to perform a custom generation and continue with Step 9 or choose <b>Generate & Publish</b> to perform a one click generation of the RDF Linked Data Views, in which case skip to Step 17.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_03.png" style="wikiautogen"/>%BR%%BR%
1 At this point, you are presented with the option to edit your column selection. Select the "Edit" link, for example, for table <code>NWND..Customers</code>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_04.png" style="wikiautogen"/>%BR%%BR%
1 For images or other binary data in MIME formats to be revealed as anything other than generic "binary objects", you must map large <code>varbinary</code> types.
to the appropriate MIME types like <code>image/gif</code>. To do so, select the <b>Edit</b> link for <b>Binding/MIME Type</b> of the relevant table columns. You can:
* Leave the <b>Binding/MIME Type</b> literal; or
* Set to skip, such that the column will not be used in RDF generation; or
* Select the <b>binary object</b> value in order for the column to be referenced as binary.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_05.png" style="wikiautogen"/>%BR%%BR%
1 After finishing with your changes click the <b>Save</b> button, or cancel the changes and go back by clicking the <b>Cancel</b> button.
1 Make sure you click the "Next" button.
1 At this point, the <b>Linked Data View Definition</b> form will let you <b>Select Generation Targets</b> options:
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_06.png" style="wikiautogen"/>%BR%%BR%
* Data Source Ontology Mappings
* Instance Data View Mappings
* [[http://www.w3.org/TR/void/][VoID]] statistic
1 Make sure you click the "Next" button.
1 Based on your selections in the prior form, the <b>Linked Data View Definition</b> <b>Deployment Options</b> form will be offered:
* Data Source Ontology Rules
* Instance Data Rules
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_07.png" style="wikiautogen"/>%BR%%BR%
1 Select the desired option(s) and click the "Prepare to Execute" button which unveils a generated Instance Data and/or Ontology form.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_08.png" style="wikiautogen"/>%BR%%BR%
1 Click the <b>Execute</b> button and Virtuoso will:
1 Apply the generated declarations (instance data and ontology) to your Virtuoso instance.
1 Publish / Deploy declarations that expose the Wizard-generated Rewrite Rules and associated endpoints.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_09.png" style="wikiautogen"/>%BR%%BR%
1 Click on one of the <b>Instance Data</b> Sample links to view some of the deployed Linked Data views.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_10.png" style="wikiautogen"/>%BR%%BR%
1 Click on the <b>Statistics Data (<nop>VoID Graph)</b> link to view the <nop>VoID Statistics.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_11.png" style="wikiautogen"/>%BR%%BR%
1 Click on the <b>Ontology</b> link to view the ontology information.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtRDFViewUI_12.png" style="wikiautogen"/>%BR%%BR%
---++ Related
* [[VirtRDFViewNorthwind][RDF-based Linked Data View atop Microsoft SQL Server using the Northwind Demo Database]]
* [[VirtRDFViewNorthwindDemo][Live Demo]]
|
| id
| - 590340e8d103984b37a7e7dedf77ed67
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| |
| links to
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)