8.10.3.Linking ODBC to JDBC Bridge tables into OpenLink Virtuoso

  1. Start the Virtuoso Web User Interface

    Figure8.492.Start

    Start

  2. Select the "Conductor" link in the Left Frame and Login as the "dba" user.

    Figure8.493.Conductor

    Conductor

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

    Figure8.494.Databases

    Databases

  4. Select the "Connect" button for the "jdbcma" ODBC to JDBC Bridge DSN.

    Figure8.495.Connect

    Connect

  5. On successful connection Select the "Link Objects" button to obtain a list of available tables

    Figure8.496.Link Objects

    Link Objects

  6. Select all the tables that are part of the "JDBC" catalog.

    Figure8.497.Select tables

    Select tables

  7. Select all the "JDBC" Catalog tables to be linked into the database and select "Link" button.

    Figure8.498."Link" button

    "Link" button

  8. Change the Catalog for each table to be "JDBC" using the "Set All" button.

    Figure8.499."Link" button

    "Link" button

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

    Figure8.500."Link" button

    "Link" button

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

    Figure8.501.Completion

    Completion

  11. 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 "JDBC.jdbcma.Artist" table to demonstrate this.

    Figure8.502.Completion

    Completion

  12. Then click the "Execute" button to run the query and retrieve the results from the remote table.

    Figure8.503.Completion

    Completion

  13. The tables can also be viewed as part of the Virtuoso "SQL Schema Objects" under the "JDBC" catalog name.

    Figure8.504.view tables

    view tables

    The Link process is now complete enabling the tables to be queried as if part of the Virtuoso Schema.