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

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

PrefixNamespace IRI
n18http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng03.
n21http://ods.openlinksw.com/dataspace/owiki/wiki/ODS/VirtIngresLinkingObjects/sioc.
n6http://ods.openlinksw.com/dataspace/person/dav#
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
n2http://ods.openlinksw.com/dataspace/owiki/wiki/
n13http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng02.
foafhttp://xmlns.com/foaf/0.1/
oplhttp://www.openlinksw.com/schema/attribution#
n12http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng01.
n15http://ods.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/
n26http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng07a.
n11http://ods.openlinksw.com/dataspace/owiki#
dchttp://purl.org/dc/elements/1.1/
n24http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng09.
rdfshttp://www.w3.org/2000/01/rdf-schema#
n33http://rdfs.org/sioc/services#
n4http://ods.openlinksw.com/dataspace/owiki/wiki/ODS/
siocthttp://rdfs.org/sioc/types#
n32http://ods.openlinksw.com/dataspace/person/owiki#
n22http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng08.
n28http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng13.
n25http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng07.
n27http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng12.
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n17http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng06.
n34http://ods.openlinksw.com/dataspace/services/wiki/
n31http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtWebHome.
n30http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng11.
n16http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng05.
n29http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng10.
xsdhhttp://www.w3.org/2001/XMLSchema#
n19http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtLinkIng04.
n14http://ods.openlinksw.com/wiki/main/ODS/VirtIngresLinkingObjects/VirtConductor.
n5http://ods.openlinksw.com/dataspace/dav#
siochttp://rdfs.org/sioc/ns#
Subject Item
n6:this
foaf:made
n4:VirtIngresLinkingObjects
Subject Item
n34:item
n33:services_of
n4:VirtIngresLinkingObjects
Subject Item
n11:this
sioc:creator_of
n4:VirtIngresLinkingObjects
Subject Item
n2:ODS
sioc:container_of
n4:VirtIngresLinkingObjects
atom:entry
n4:VirtIngresLinkingObjects
atom:contains
n4:VirtIngresLinkingObjects
Subject Item
n4:VirtIngresLinkingObjects
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T06:06:29.445305
dcterms:modified
2017-06-29T07:33:53.262504
rdfs:label
VirtIngresLinkingObjects
foaf:maker
n6:this n32:this
dc:title
VirtIngresLinkingObjects
opl:isDescribedUsing
n21:rdf
sioc:has_creator
n5:this n11:this
sioc:attachment
n12:png n13:png n14:png n16:png n17:png n18:png n19:png n22:png n24:png n25:png n26:png n27:png n28:png n29:png n30:png n31:png
sioc:content
%VOSWARNING% %META:TOPICPARENT{name="VirtLinkRemoteTables"}% ---+ Linking Ingres Database Objects (Tables, Views, and Stored Procedures) into Virtuoso ---++ Prerequisites * <b>Virtuoso Universal Server, Commercial Edition</b>%BR% Virtuoso Universal Server Release 6.x or later is recommended, optimally the latest version available.%BR%%BR% * <b>ODBC Driver for Ingres</b>%BR% The Virtuoso Server uses an ODBC Driver for Ingres to link in the Ingres Schema Objects (Tables, Views, and Stored Procedures). The <b><nop>OpenLink Multi-Tier ODBC Driver for Ingres</b> will be used in this document, and a functional ODBC Data Source Name (DSN) of <b><code><nowiki>ingiima-tut</nowiki></code></b> will be assumed to exist on the machine hosting the Virtuoso Server. Any ODBC compliant driver for Ingres should work.%BR%%BR% * <b>Ingres DBMS</b>%BR% A Ingres DBMS hosting the required Schema Objects (Tables, Views, and Stored Procedures) needs to be available. This may be on any host which is TCP/IP accessible from the Virtuoso Server host. In this document, the Ingres <b>tutorial</b> sample database will be used to demonstrate the process.%BR%%BR% ---++ Steps 1 Load the HTTP-based Virtuoso User Interface in your browser. %BR%%BR%<a href="%ATTACHURLPATH%/VirtWebHome.png"><img src="%ATTACHURLPATH%/VirtWebHome.png" style="wikiautogen" width="600px" alt="" /></a>%BR%%BR% 1 Click the <b>Conductor</b> link in the left-side navbar, and log in as a user with DBA privileges, such as the default <b><code>dba</code></b> user. %BR%%BR%<a href="%ATTACHURLPATH%/VirtConductor.png"><img src="%ATTACHURLPATH%/VirtConductor.png" style="wikiautogen" width="600px" alt="VirtConductor.png" /></a>%BR%%BR% 1 Drill down to the <b>Databases</b> -> <b>External Data Source</b> -> <b>Data Sources</b> tab. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng01.png"><img src="%ATTACHURLPATH%/VirtLinkIng01.png" style="wikiautogen" width="600px" alt="VirtLinkIng01.png" /></a>%BR%%BR% 1 Locate the DSN for the desired remote data source (we're using <b><code><nowiki>ingiima-tut</nowiki></code></b> for this example). If not yet connected to the DSN, click <b>Connect</b>, and input your user credentials for the remote data source. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng02.png"><img src="%ATTACHURLPATH%/VirtLinkIng02.png" style="wikiautogen" width="600px" alt="VirtLinkIng02.png" /></a>%BR%%BR% 1 Once connected to the DSN, click the associated <b>Link objects</b> to get a list of available objects (tables, views, stored procedures). %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng03.png"><img src="%ATTACHURLPATH%/VirtLinkIng03.png" style="wikiautogen" width="600px" alt="VirtLinkIng03.png" /></a>%BR%%BR% 1 Locate and select the desired objects. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng04.png"><img src="%ATTACHURLPATH%/VirtLinkIng04.png" style="wikiautogen" width="600px" alt="VirtLinkIng04.png" /></a>%BR%%BR% * You can use the Catalog and Schema drop-down selectors and the table name test-entry box to construct a filter to shorten the visible list. * For this example, we'll choose the key tables from the Ingres sample <b>pubs2.dbo</b> schema -- <b><code><nowiki>billing</nowiki></code>, <code><nowiki>book_list</nowiki></code>, <code><nowiki>book_orders</nowiki></code>, <code><nowiki>class</nowiki></code>, <code><nowiki>course</nowiki></code>, <code><nowiki>cust_info</nowiki></code>, <code><nowiki>cust_orders</nowiki></code>, <code><nowiki>dept</nowiki></code>, <code><nowiki>emp</nowiki></code>, <code><nowiki>enrolls</nowiki></code>, <code><nowiki>faculty</nowiki></code>, <code><nowiki>student</nowiki></code>, <code><nowiki>tuition</nowiki></code></b>. * When all desired objects are selected, click the <b>Link...</b> button. 1 Virtuoso will interrogate the remote data source to learn about primary keys, and present you with a default linkage setup. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng05.png"><img src="%ATTACHURLPATH%/VirtLinkIng05.png" style="wikiautogen" width="600px" alt="VirtLinkIng05.png" /></a>%BR%%BR% 1 You can adjust the Virtuoso catalog, schema/owner, and object identifiers to suit your goals. The <b>Set To All</b> button can be used to speed the process. In this example, we'll put all linked objects into the <b><code>ingres</code></b> catalog, and the <b><code>tutorial</code></b> schema. We'll leave the object identifiers unchanged. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng06.png"><img src="%ATTACHURLPATH%/VirtLinkIng06.png" style="wikiautogen" width="600px" alt="VirtLinkIng06.png" /></a>%BR%%BR% * Sometimes a primary key is not reported properly, or you want to use a different key, either simple or compound. Click <b>Edit</b> next to the primary key you want to change, and select the columns that Virtuoso should use for the purpose -- %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng07.png"><img src="%ATTACHURLPATH%/VirtLinkIng07.png" style="wikiautogen" width="600px" alt="VirtLinkIng07.png" /></a>%BR%%BR% 1 When all are set as desired, click the <b>Link</b> button to link the objects into Virtuoso. <i>Virtuoso may take some time to complete this step,</i> depending on network infrastructure, DBMS load, etc. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng07a.png"><img src="%ATTACHURLPATH%/VirtLinkIng07a.png" style="wikiautogen" width="600px" alt="VirtLinkIng07a.png" /></a>%BR%%BR% 1 The Link process will complete by listing the linked objects in the <b>Databases</b> -> <b>External Data Source</b> -> <b>External Linked Objects</b> tab. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng08.png"><img src="%ATTACHURLPATH%/VirtLinkIng08.png" style="wikiautogen" width="600px" alt="VirtLinkIng08.png" /></a>%BR%%BR% ---++ Confirmation and Testing ---+++ Working with External Linked Objects (Tables, Views, and Stored Procedures) 1 Linked object are shown in the <b>Databases</b> -> <b>External Data Source</b> -> <b>External Linked Objects</b> tab. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng08.png"><img src="%ATTACHURLPATH%/VirtLinkIng08.png" style="wikiautogen" width="600px" alt="VirtLinkIng08.png" /></a>%BR%%BR% 1 Clicking the hyperlinked <b>Local Name</b> of the <b>External Linked Objects</b> will load the Virtuoso <b>Interactive SQL</b> (iSQL) HTTP interface (in a new browser tab or window) with a default <b><code>SELECT *</code><b> SQL query. For instance, clicking on <b><code>ingres.tutorial.cust_info</code></b> brings -- %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng09.png"><img src="%ATTACHURLPATH%/VirtLinkIng09.png" style="wikiautogen" width="600px" alt="VirtLinkIng09.png" /></a>%BR%%BR% 1 Click the <b>Execute</b> button to run the query. Virtuoso will retrieve the results from the remote table. <i><b>Note:</b> By default, iSQL will "<b>Show no more than 100 rows </b>." You can change this value as desired.</i> %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng10.png"><img src="%ATTACHURLPATH%/VirtLinkIng10.png" style="wikiautogen" width="600px" alt="VirtLinkIng10.png" /></a>%BR%%BR% ---+++ Working with SQL Database Objects (Tables, Views, and Stored Procedures) 1 Linked objects are also visible through the <b>Database</b> -> <b>SQL Database Object</b> tab, just as if they were local Virtuoso data. %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng11.png"><img src="%ATTACHURLPATH%/VirtLinkIng11.png" style="wikiautogen" width="600px" alt="VirtLinkIng11.png" /></a>%BR%%BR% 1 Simply drill down to the Catalog you set while linking -- %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng12.png"><img src="%ATTACHURLPATH%/VirtLinkIng12.png" style="wikiautogen" width="600px" alt="VirtLinkIng12.png" /></a>%BR%%BR% 1 As you might expect, clicking on any of the <b>Action</b> links will reveal the table definition, indexes, triggers, constraints, or privileges. For example, clicking <b>Definition</b> for <b><code>ingres.tutorial.cust_orders</code></b> -- %BR%%BR%<a href="%ATTACHURLPATH%/VirtLinkIng13.png"><img src="%ATTACHURLPATH%/VirtLinkIng13.png" style="wikiautogen" width="600px" alt="VirtLinkIng13.png" /></a>%BR%%BR% ---++ Related * [[VOSSQL2RDF][Mapping SQL Data to Linked Data Views]] * [[VirtIngresEntityFrameworkUsage][Using Microsoft Entity Frameworks to Access Ingres Schema Objects (Tables, Views, and Stored Procedures) with Virtuoso]] CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite
sioc:id
e71720b08c801ed5de5be1aa35aafb49
sioc:link
n4:VirtIngresLinkingObjects
sioc:has_container
n2:ODS
n33:has_services
n34:item
atom:title
VirtIngresLinkingObjects
sioc:links_to
n15:CategoryEntityFrameworks n15:CategoryDotNET n4:CategoryWebSite n4:CategoryDocumentation n4:CategoryVirtuoso n15:VOSSQL2RDF n15:VirtIngresEntityFrameworkUsage
atom:source
n2:ODS
atom:author
n6:this
atom:published
2017-06-13T06:06:29Z
atom:updated
2017-06-29T07:33:53Z
sioc:topic
n2:ODS
Subject Item
n5:this
sioc:creator_of
n4:VirtIngresLinkingObjects