%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. employee.fire.COUNTRY.%BR%%BR%
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