This HTML5 document contains 29 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n10:this

foaf:made

n2:VirtSQLLinkingObjects

Subject Item

n8:this

sioc:creator_of

n2:VirtSQLLinkingObjects

Subject Item

n17:item

n16:services_of

n2:VirtSQLLinkingObjects

Subject Item

n12:this

sioc:creator_of

n2:VirtSQLLinkingObjects

Subject Item

n5:VOS

sioc:container_of

n2:VirtSQLLinkingObjects

atom:entry

n2:VirtSQLLinkingObjects

atom:contains

n2:VirtSQLLinkingObjects

Subject Item

n2:VirtSQLLinkingObjects

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:49:38.935969

dcterms:modified

2017-06-13T05:49:38.935969

rdfs:label

VirtSQLLinkingObjects

foaf:maker

n7:this n10:this

dc:title

VirtSQLLinkingObjects

opl:isDescribedUsing

n15:rdf

sioc:has_creator

n12:this n8:this

sioc:content

%META:TOPICPARENT{name="VirtMSSQLServerEntityFrameworkUsage"}% ---+++Linking Tables from Microsoft SQL Server into Virtuoso 1. Start the Virtuoso Web User Interface. %BR%%BR%<img src="%ATTACHURLPATH%/VirtWebHome.png" style="wikiautogen"/>%BR%%BR% 2. Select the "Conductor" link in the Left Frame and Login as the "dba" user. %BR%%BR%<img src="%ATTACHURLPATH%/VirtConductor.png" style="wikiautogen"/>%BR%%BR% 3. Select the "Databases" -> "External Data Source" -> "Data Sources" tab menu items. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL0.png" style="wikiautogen"/>%BR%%BR% 4. Select the "Connect" button for the "sql25kma" Microsoft SQL Server DSN. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL1.png" style="wikiautogen"/>%BR%%BR% 5. On succesful connection Select the "Link Objects" button to obtain a list of available tables. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL2.png" style="wikiautogen"/>%BR%%BR% 6. Select all the tables that are part of the "Northwind" catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL3.png" style="wikiautogen"/>%BR%%BR% 7. Change the Catalog for each table to be "NWIND" using the "Set All" button. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL4.png" style="wikiautogen"/>%BR%%BR% 8. All the catalog names are changed to be "NWIND". %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL5.png" style="wikiautogen"/>%BR%%BR% 9. Select the "Link" button to link the selected tables into Virtuoso. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL6.png" style="wikiautogen"/>%BR%%BR% 10. On completion of the Link process the tables will be displayed in the "External Linked Objects" tab. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL9.png" style="wikiautogen"/>%BR%%BR% 11. At this point, you can test the remotely linked tables by clicking on the link that accompanies each table, e.g. NWIND.NWIND.Customer. This will display the Interactive ISQL interface which will have been already populated with a suitable SQL statement. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL10.png" style="wikiautogen"/>%BR%%BR% 12. Select Execute to see data from the remotely linked table. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL11.png" style="wikiautogen"/>%BR%%BR% 13. The tables can also be viewed as part of the Virtuoso SQL Schema Objects under the NWIND catalog name. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkSQL7.png" style="wikiautogen"/>%BR%%BR% The Link process is now complete enabling the tables to be queried as if part of the Virtuoso Schema.

sioc:id

4efd57e07c32d3bee493c0c1706789f1

sioc:link

n2:VirtSQLLinkingObjects

sioc:has_container

n5:VOS

n16:has_services

n17:item

atom:title

VirtSQLLinkingObjects

atom:source

n5:VOS

atom:author

n10:this

atom:published

2017-06-13T05:49:38Z

atom:updated

2017-06-13T05:49:38Z

sioc:topic

n5:VOS