. "VirtFirebirdLinkingObjects" . . . . . . . "2017-06-13T05:48:37.587302"^^ . . . . "2017-06-13T05:48:37.587302"^^ . . . . . . . "%VOSWARNING%\n%META:TOPICPARENT{name=\"VirtLinkRemoteTables\"}%\n\n---+ Linking Firebird Database Objects into Virtuoso\n\n---++ Steps\n\n 1 Start the Virtuoso Web User Interface\n%BR%%BR%%BR%%BR%\n 1 Select the \"Conductor\" link in the Left Frame and Login as the \"dba\" user.\n%BR%%BR%%BR%%BR%\n 1 Select the \"Databases\" -> \"External Data Source\" -> \"Data Sources\" tab menu items\n%BR%%BR%%BR%%BR%\n 1 Select the \"Connect\" button for the \"fire\" Firebird DSN.\n%BR%%BR%%BR%%BR%\n 1 On successful connection Select the \"Link Objects\" button to obtain a list of available tables\n%BR%%BR%%BR%%BR%\n 1 Select all the tables that are part of the \"employee\" catalog.\n%BR%%BR%%BR%%BR%\n 1 Change the Catalog for each table to be \"employee\" using the \"Set All\" button.\n%BR%%BR%%BR%%BR%\n 1 All the catalog names are changed to be \"employee\".\n%BR%%BR%%BR%%BR%\n 1 Select the \"Link\" button to link the selected tables into Virtuoso\n%BR%%BR%%BR%%BR%\n 1 On completion of the Link process the tables will be displayed in the \"External Linked Objects\" tab.\n%BR%%BR%%BR%%BR%\n 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%\nThis will display the Interactive ISQL interface which will have been already populated with a suitable SQL statement.\n%BR%%BR%%BR%%BR%\n 1 Select Execute to see data from the remotely linked table.\n%BR%%BR%%BR%%BR%\n 1 The tables can also be viewed as part of the Virtuoso \"SQL Schema Objects\" under the \"employee\" catalog name.\n%BR%%BR%%BR%%BR%\n\nThe Link process is now complete enabling the tables to be queried as if part of the Virtuoso Schema.\n\n---++ Related\n\n * [[VOSSQL2RDF][Mapping SQL Data to Linked Data Views]]\n * [[VirtFirebirdEntityFrameworkUsage][Using Microsoft Entity Frameworks to Access Firebird Schema Objects with Virtuoso]]\n\n CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite \n" . . . . . "2017-06-13T05:48:37Z" . "VirtFirebirdLinkingObjects" . . . . . . . "VirtFirebirdLinkingObjects" . . . "fbcbf391430f06f94ea56c5385fcdd10" . . . . "2017-06-13T05:48:37Z" . . .