Not logged in : Login

About: VirtOracleLinkingObjects     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : www.openlinksw.com associated with source document(s)
QRcode icon
http://www.openlinksw.com/describe/?url=http%3A%2F%2Fwww.openlinksw.com%2Fdataspace%2Fdav%2Fwiki%2FVOS%2FVirtOracleLinkingObjects

AttributesValues
has container
Date Created
maker
topic
described by
seeAlso
Date Modified
link
id
  • c1ce92ee3098423c435f162e195c5bf3
content
  • %VOSWARNING% %META:TOPICPARENT{name="VirtLinkRemoteTables"}% ---+ Linking Oracle Database Objects into Virtuoso ---++ Prerequisites * Virtuoso Universal Server, Commercial Edition%BR% Virtuoso Universal Server Release 6.x or later is recommended, optimally the latest version available.%BR%%BR% * ODBC Driver for Oracle%BR% The Virtuoso Server uses an ODBC Driver for Oracle to link in the Oracle Schema Objects. The OpenLink Multi-Tier ODBC Driver for Oracle will be used in this document, and a functional ODBC Data Source Name (DSN) of ora10ma-hr will be assumed to exist on the machine hosting the Virtuoso Server. Any ODBC compliant driver for Oracle should work.%BR%%BR% * Oracle DBMS%BR% An Oracle DBMS hosting the required Schema Objects needs to be available. This may be on any host which is TCP/IP accessible from the Virtuoso Server host. In this document, the Oracle Human Resources database will be used to demonstrate the process.%BR%%BR% ---++ Steps 1 Load the HTTP-based Virtuoso User Interface in your browser. %BR%%BR%%BR%%BR% 1 Click the Conductor link in the left-side navbar, and log in as a user with DBA privileges, such as the default dba user. %BR%%BR%VirtConductor.png%BR%%BR% 1 Drill down to the Databases -> External Data Source -> Data Sources tab. %BR%%BR%VirtLinkOra01.png%BR%%BR% 1 Locate the DSN for the desired remote data source (we're using ora10ma-hr for this example). If not yet connected to the DSN, click Connect, and input your user credentials for the remote data source. %BR%%BR%VirtLinkOra02.png%BR%%BR% 1 Once connected to the DSN, click the associated Link objects to get a list of available objects (tables, views, stored procedures). %BR%%BR%VirtLinkOra03.png%BR%%BR% 1 Locate and select the desired objects. %BR%%BR%VirtLinkOra04.png%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 main tables from Oracle's sample HR schema -- HR.COUNTRIES, HR.DEPARTMENTS, HR.EMPLOYEES, HR.JOBS, HR.JOB_HISTORY, HR.LOCATIONS, and HR.REGIONS. * When all desired objects are selected, click the Link... button. 1 Virtuoso will interrogate the remote data source to learn about primary keys, and present you with a default linkage setup. %BR%%BR%VirtLinkOra05.png%BR%%BR% 1 You can adjust the Virtuoso catalog, schema/owner, and object identifiers to suit your goals. The Set To All button can be used to speed the process. In this example, we'll put all linked objects into the Oracle catalog, and the HR schema. We'll leave the object identifiers unchanged. %BR%%BR%VirtLinkOra06.png%BR%%BR% * Sometimes a primary key is not reported properly, or you want to use a different key, either simple or compound. Click Edit next to the primary key you want to change, and select the columns that Virtuoso should use for the purpose -- %BR%%BR%VirtLinkOra07.png%BR%%BR% 1 When all are set as desired, click the Link button to link the objects into Virtuoso. Virtuoso may take some time to complete this step, depending on network infrastructure, DBMS load, etc. 1 The Link process will complete by listing the linked objects in the Databases -> External Data Source -> External Linked Objects tab. %BR%%BR%VirtLinkOra08.png%BR%%BR% ---++ Confirmation and Testing ---+++ Working with External Linked Objects 1 Linked object are shown in the Databases -> External Data Source -> External Linked Objects tab. %BR%%BR%VirtLinkOra08.png%BR%%BR% 1 Clicking the hyperlinked Local Name of the External Linked Objects will load the Virtuoso Interactive SQL (iSQL) HTTP interface (in a new browser tab or window) with a default SELECT * SQL query. For instance, clicking on Oracle.HR.COUNTRIES brings -- %BR%%BR%VirtLinkOra09.png%BR%%BR% 1 Click the Execute button to run the query. Virtuoso will retrieve the results from the remote table. Note: By default, iSQL will "Show no more than 100 rows ." You can change this value as desired. %BR%%BR%VirtLinkOra10.png%BR%%BR% ---+++ Working with SQL Database Objects 1 Linked objects are also visible through the Database -> SQL Database Object tab, just as if they were local Virtuoso data. %BR%%BR%VirtLinkOra11.png%BR%%BR% 1 Simply drill down to the Catalog you set while linking -- %BR%%BR%VirtLinkOra12.png%BR%%BR% 1 As you might expect, clicking on any of the Action links will reveal the table definition, indexes, triggers, constraints, or privileges. For example, clicking Definition for Oracle.HR.EMPLOYEES -- %BR%%BR%VirtLinkOra13.png%BR%%BR% ---++ Related * [[VOSSQL2RDF][Mapping SQL Data to Linked Data Views]] * [[VirtOracleEntityFrameworkUsage][Using Microsoft Entity Frameworks to Access Oracle Schema Objects with Virtuoso]] CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite
Title
  • VirtOracleLinkingObjects
attachment
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
  • External Image
has creator
is described using
atom:source
atom:updated
  • 2015-07-28T21:05:38Z
atom:title
  • VirtOracleLinkingObjects
links to
atom:author
label
  • VirtOracleLinkingObjects
topic
atom:published
  • 2010-02-01T13:21:35Z
type
is topic of
is made of
is link of
is creator of of
is atom:contains of
is atom:entry of
is links to of
is container of of
is http://vocab.deri.ie/void#inDataset of
Faceted Search & Find service v1.17_git63 as of Apr 23 2021


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:       RDF       ODATA       Microdata      About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Jun 3 2021, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2021 OpenLink Software