8.11.2.Linking ODBC to ODBC Bridge tables
into OpenLink Virtuoso
Start the Virtuoso Web User Interface
Select the "Conductor" link in the Left Frame and Login as the
Select the "Databases" -> "External Data Source" -> "Data
Sources" tab menu items
Select the "Connect" button for the "odbcma" ODBC to ODBC Bridge
On successful connection Select the "Link Objects" button to
obtain a list of available tables
Select all the tables that are part of the "Northwind"
Change the Catalog for each table to be "NWIND" using the "Set
All the catalog names are changed to be "NWIND".
Select the "Link" button to link the selected tables into
On completion of the Link process the tables will be displayed
in the "External Linked Objects" tab.
The linked tables can be queried by clicking on the hyperlink in
the "Local Name" column of the "External Linked Objects" tab above,
which loads the Virtuoso "Interactive SQL" interface with the
required SQL "Select" for retrieving the remote table data. We
shall use the "NWIND.odbcma.Customers" table to demonstrate
Then click the "Execute" button to run the query and retrieve
the results from the remote table.
The tables can also be viewed as part of the Virtuoso "SQL
Schema Objects" under the "NWIND" catalog name.
The Link process is now complete enabling the tables to be
queried as if part of the Virtuoso Schema.