Not logged in : Login

About: VirtFirebirdLinkingObjects     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : associated with source document(s)
QRcode icon

has container
Date Created
described by
Date Modified
  • 673d2508fe1cd2d5843d8c7b773c0882
  • %VOSWARNING% %META:TOPICPARENT{name="VirtLinkRemoteTables"}% ---+ Linking Firebird Database Objects into Virtuoso ---++ Steps 1 Start the Virtuoso Web User Interface %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_01.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%/VirtFireEDALink_02.png" style="wikiautogen"/>%BR%%BR% 1 Select the "Databases" -> "External Data Source" -> "Data Sources" tab menu items %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_03.png" style="wikiautogen"/>%BR%%BR% 1 Select the "Connect" button for the "fire" Firebird DSN. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_04.png" style="wikiautogen"/>%BR%%BR% 1 On successful connection Select the "Link Objects" button to obtain a list of available tables %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_05.png" style="wikiautogen"/>%BR%%BR% 1 Select all the tables that are part of the "employee" catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_06.png" style="wikiautogen"/>%BR%%BR% 1 Change the Catalog for each table to be "employee" using the "Set All" button. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_07.png" style="wikiautogen"/>%BR%%BR% 1 All the catalog names are changed to be "employee". %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_08.png" style="wikiautogen"/>%BR%%BR% 1 Select the "Link" button to link the selected tables into Virtuoso %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_09.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%/VirtFireEDALink_10.png" style="wikiautogen"/>%BR%%BR% 1 At this point you can test the remotely linked tables by clicking on the link that accompanies each table. e.g. This will display the Interactive ISQL interface which will have been already populated with a suitable SQL statement. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_11.png" style="wikiautogen"/>%BR%%BR% 1 Select <b>Execute</b> to see data from the remotely linked table. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_12.png" style="wikiautogen"/>%BR%%BR% 1 The tables can also be viewed as part of the Virtuoso "SQL Schema Objects" under the "employee" catalog name. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFireEDALink_13.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]] * [[VirtFirebirdEntityFrameworkUsage][Using Microsoft Entity Frameworks to Access Firebird Schema Objects with Virtuoso]] CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite
  • VirtFirebirdLinkingObjects
  • 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
  • 2015-07-10T18:20:32Z
  • VirtFirebirdLinkingObjects
links to
  • VirtFirebirdLinkingObjects
  • 2010-02-01T13:19:17Z
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 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