About: VirtOJDBCLinkingObjects

Not logged in : Login

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: VirtOJDBCLinkingObjects Goto Sponge NotDistinct Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

Attributes	Values
type	Comment atom:Entry
Date Created	2017-06-13 06:02:25.208844(xsd:dateTime)
Date Modified	2017-06-13 06:02:25.208844(xsd:dateTime)
label	VirtOJDBCLinkingObjects
maker	WebDAV System Administrator owiki
Title	VirtOJDBCLinkingObjects
isDescribedUsing	http://vos.openlinksw.com/dataspace/owiki/wiki/ODS/VirtOJDBCLinkingObjects/sioc.rdf
has creator	http://vos.openlinksw.com/dataspace/dav#this http://vos.openlinksw.com/dataspace/owiki#this
attachment
content	%VOSWARNING% %META:TOPICPARENT{name="VirtLinkRemoteTables"}% ---+ Linking JDBC-accessible Database Objects (Tables, Views, and Stored Procedures) into Virtuoso ---++ Steps 1 Start the Virtuoso Web User Interface. %BR%%BR%<img src="%ATTACHURLPATH%/VirtWebHome.png" style="wikiautogen"/>%BR%%BR% 1 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% 1 Select the Databases -> External Data Source -> Data Sources tab menu items. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC1.png" style="wikiautogen"/>%BR%%BR% 1 Select the Connect button for the jdbcma ODBC to JDBC DSN. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC2.png" style="wikiautogen"/>%BR%%BR% 1 On succesful connection, select the Link Objects button to obtain a list of available tables. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC3.png" style="wikiautogen"/>%BR%%BR% 1 Select all the tables that are part of the Demo catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC4.png" style="wikiautogen"/>%BR%%BR% 1 Select all the Demo catalog tables to be linked into the database and click the Link button. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC5.png" style="wikiautogen"/>%BR%%BR% 1 Change the catalog for each table to JDBC using the Set All button. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC6.png" style="wikiautogen"/>%BR%%BR% 1 Click the Link button to link the selected tables into Virtuoso. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC7.png" style="wikiautogen"/>%BR%%BR% 1 On completion of the link process, the tables will be displayed in the External Linked Objects tab. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC8.png" style="wikiautogen"/>%BR%%BR% 1 The linked tables can be queried by clicking on the hyperlink in the Local Name column of the External Linked Objects tab above. This loads the Virtuoso Interactive SQL interface with the required SQL Select for retrieving the remote table data . We shall use the JDBC.jdbcma.Artist table to demonstrate this. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC10.png" style="wikiautogen"/>%BR%%BR% 1 Click the Execute button to run the query and retrieve results from the remote table. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC11.png" style="wikiautogen"/>%BR%%BR% 1 The tables can also be viewed as part of the Virtuoso SQL Schema Objects under the JDBC catalog name. %BR%%BR%<img src="%ATTACHURLPATH%/VirtLinkOJDBC9.png" style="wikiautogen"/>%BR%%BR% The link process is now complete enabling the tables to be queried as if part of the Virtuoso Schema. ---++ Related * [[VOSSQL2RDF][Mapping SQL Data to Linked Data Views]] * [[VirtOJDBCEntityFrameworkUsage][ Using Microsoft Entity Frameworks to Access Remote JDBC-accessible Schema Objects (Tables, Views, and Stored Procedures) with Virtuoso, via an ODBC-to-JDBC Bridge]] CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite
id	e276c82dde01b27e76567a6dddd9bbee
link	VirtOJDBCLinkingObjects
has container	owiki's Wiki
http://rdfs.org/si...ices#has_services	ODS Wiki item services
atom:title	VirtOJDBCLinkingObjects
links to	http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/CategoryVirtuoso http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/CategoryWebSite http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/CategoryDocumentation http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/VOSSQL2RDF http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/CategoryDotNET http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/CategoryEntityFrameworks http://vos.openlinksw.com/dataspace/%28NULL%29/wiki/ODS/VirtOJDBCEntityFrameworkUsage
atom:source	owiki's Wiki
atom:author	WebDAV System Administrator
atom:published	2017-06-13T06:02:25Z
atom:updated	2017-06-13T06:02:25Z
topic	owiki's Wiki
is made of	WebDAV System Administrator
is container of of	owiki's Wiki
is link of	VirtOJDBCLinkingObjects
is http://rdfs.org/si...vices#services_of of	ODS Wiki item services
is links to of	VirtLinkRemoteTables
is creator of of	http://vos.openlinksw.com/dataspace/dav#this http://vos.openlinksw.com/dataspace/owiki#this
is atom:entry of	owiki's Wiki
is atom:contains of	owiki's Wiki

Faceted Search & Find service v1.17_git132 as of May 12 2023

Alternative Linked Data Documents: iSPARQL | ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 07.20.3238 as of May 23 2023, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 3 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software