Hands-on With the JDBC Driver in GraphDB: Bridging Relational Queries to the Graph World

This webinar is recorded and available on YouTube.

RDF and Knowledge Graphs as a semantic technology provide numerous benefits, one of which is the fact that it can act as a data warehouse. This is due to the technology’s schema-less approach which allows the integration of multiple heterogeneous datasets. Examples could include the integration of a corporate finance database such as PitchBook and that of a less sector-focused database such as Wikidata. 

However, the ecosystem of applications that rely on communication with Relational Databases remains large. Some of the most popular Business Intelligence & Analytics tools (e.g. Power BI and Tableau) and ETL software packages require SQL access to a database and cannot use SPARQL, making the usage of knowledge graphs limited.

The webinar will provide a brief overview of the GraphDB JDBC Driver and present features such as SQL-to-SPARQL transformation and query optimization. On the server-side, we will demonstrate how to set up SQL views. On the client-side, we will demonstrate how to download and configure the JDBC Driver. Finally, we will give a quick demonstration of how to use the driver with Microsoft’s Power BI and Tableau.  

In this webinar you will learn:

  • How to map SPARQL queries to SQL views
  • How GraphDB optimizes SQL queries by pushing complexity down to SPARQL
  • How to configure Tableau to consume data over the GraphDB JDBC driver
  • How to configure Microsoft Power BI to consume data over ODBC driver

Who is this webinar for:

  • Analysts and Consultants
  • Data Scientists and Engineers 
  • Experts in Business Analytical Tools who want to benefit from knowledge graphs

Expected duration:

  • 45 minutes presentation
  • 15 minutes Q&A session

About The Speaker

Tomas Kovachev

Tomas Kovachev

Junior Software Developer

Tomas Kovachev is a Junior Software Developer at Ontotext, where he engages in both back and front-end development around GraphDB and a Curation tool project. He has a BSc in Accounting and Finance from University of Reading. Tomas has a Finance background as he worked as an analyst for an Advisory Boutique and also a Financial Brokerage.