Connecting JDBC Data Sources to Virtuoso

Published in

OpenLink Virtuoso Weblog

3 min readMar 15, 2019

Overview

Virtuoso’s Virtual Database Layer enables users to create Virtual Tables to ODBC-Compliant data sources that would otherwise be siloed.

Virtuoso’s Data Virtualization Architecture

The use of an ODBC-JDBC Bridge driver extends the ODBC-compliant functionality of this feature, to JDBC Data Sources.

Objective

This article demonstrates how to link tables from JDBC data sources, to Virtuoso’s Virtual Database Layer using the Conductor interface.

Requirements

Virtuoso Universal Server (Commercial Edition, Free Trial)
A working JDBC Connection to your Data Source.
A working 64-bit ODBC-JDBC bridge DSN ( Windows, macOS, Linux)

Attaching Your Data Source

Log into the conductor interface at domain:port/conductor, and navigate to the Data Sources tab by entering domain:port/conductor/vdb_con_dsn.vspx in your address bar, or by clicking on Database ->External Data Sources -> Data Sources

Locate your working ODBC-JDBC bridge driver DSN and click Connect

2. Enter the login credentials for your JDBC data source, and click Connect.

3. A successful attachment will result in returning to the initial Data Sources selection page, in addition to Link Objects and Change Credentials hyperlinks appearing for your data source.

4. Click on Link Objects

Linking Tables to Virtuoso

5. Select the tables that you want to link to the Virtual Database Layer, and click Link .

6. Click Link to create Virtual Tables of the selected tables from your JDBC data source. The table qualifier mappings for the virtual tables can be edited by changing the test in the Catalog, Owner(Schema), and Link as column fields.

7. Once completed, the created Virtual tables will appear in the table under the External Linked Objects tab.

Testing Your Attached Table Connections

8. Click on one of the hyperlinks in the Local Name column to open an Interactive SQL (iSQL) HTTP interface. A SELECT query will be populated in the text

9. Click on Execute and the data from your JDBC Data source will populate the virtual table and be displayed in the query execution results