%VOSWARNING% %META:TOPICPARENT{name="VirtLinkRemoteTables"}% ---+ Linking Firebird Database Objects into Virtuoso ---++ Steps 1 Start the Virtuoso Web User Interface %BR%%BR%%BR%%BR% 1 Select the "Conductor" link in the Left Frame and Login as the "dba" user. %BR%%BR%%BR%%BR% 1 Select the "Databases" -> "External Data Source" -> "Data Sources" tab menu items %BR%%BR%%BR%%BR% 1 Select the "Connect" button for the "fire" Firebird DSN. %BR%%BR%%BR%%BR% 1 On successful connection Select the "Link Objects" button to obtain a list of available tables %BR%%BR%%BR%%BR% 1 Select all the tables that are part of the "employee" catalog. %BR%%BR%%BR%%BR% 1 Change the Catalog for each table to be "employee" using the "Set All" button. %BR%%BR%%BR%%BR% 1 All the catalog names are changed to be "employee". %BR%%BR%%BR%%BR% 1 Select the "Link" button to link the selected tables into Virtuoso %BR%%BR%%BR%%BR% 1 On completion of the Link process the tables will be displayed in the "External Linked Objects" tab. %BR%%BR%%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%%BR%%BR% 1 Select Execute to see data from the remotely linked table. %BR%%BR%%BR%%BR% 1 The tables can also be viewed as part of the Virtuoso "SQL Schema Objects" under the "employee" catalog name. %BR%%BR%%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