• Topic
  • Discussion
  • ODS.VirtOODBCLinkingObjects(Last) -- DAVWikiAdmin? , 2017-06-29 07:34:19 Edit WebDAV System Administrator 2017-06-29 07:34:19

    Linking ODBC-accessible Database Objects (Tables, Views, and Stored Procedures) into Virtuoso


    • Virtuoso Universal Server, Commercial Edition
      Virtuoso Universal Server Release 6.x or later is recommended, optimally the latest version available.

    • ODBC Driver for RDBMS or other Data Source
      The Virtuoso Server uses an ODBC Driver for the RDBMS or other Data Source to link in the external Schema Objects (Tables, Views, and Stored Procedures). The Microsoft-supplied, Windows-bundled ODBC Driver for Microsoft Access will be used in this document, and a functional ODBC Data Source Name (DSN) of odbcma will be assumed to exist on the machine hosting the Virtuoso Server. Any ODBC compliant driver should work.

    • RDBMS or other Data Source
      A DBMS hosting the required Schema Objects (Tables, Views, and Stored Procedures) needs to be available. This may be on any host which is TCP/IP accessible from the Virtuoso Server host. In this document, the Microsoft Access Northwind sample database will be used to demonstrate the process.


    1. Start the Virtuoso Web User Interface.

    2. Select the Conductor link in the left frame and login as the dba user.

    3. Select the Databases -> External Data Source -> Data Sources tab menu items.

    4. Select the Connect button for the odbcma ODBC to ODBC Bridge DSN.

    5. On succesful connection, select the Link Objects button to obtain a list of available tables.

    6. Select all the tables that are part of the Northwind catalog.

    7. Change the Catalog for each table to be NWIND using the Set All button.

    8. All the catalog names are changed to be NWIND.

    9. Select the Link button to link the selected tables into Virtuoso.

    10. On completion of the link process, the tables will be displayed in the External Linked Objects tab.

    11. The linked tables can be queried by clicking on the hyperlink in the Local Name column of the External Linked Objects tab above. This 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 this.

    12. Click the Execute button to run the query and retrieve the results from the remote table.

    13. 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 local to the Virtuoso instance.


    • Mapping SQL Data to Linked Data Views?
    • Using Microsoft Entity Frameworks to Access Remote ODBC-accessible Schema Objects (Tables, Views, and Stored Procedures) with Virtuoso, via an ODBC-to-ODBC Bridge?

    CategoryDocumentation CategoryVirtuoso CategoryEntityFrameworks? CategoryDotNET? CategoryODBC CategoryODBCODBCBridge