Weekly Summary 2021-02-12

[Carolinei]

Accessing Virtuoso using PyODBC on macOS or Linux

What is this about?

A simple guide comprising predictable steps for connecting Python programs to a Virtuoso DBMS instance using ODBC via the PyODBC framework. This implies easy access to the massive LOD Cloud Knowledge Graph, too!

This approach also works with any of our ODBC Drivers for other DBMS platforms! Naturally, it even works with our ODBC-to-ODBC and ODBC-to-JDBC Bridge Drivers.

We don’t need to write DBMS-specific code, circa 2021!

Related Tips & How-To Guides

• How to generate a Knowledge Graph using existing Government Open Data via our Virtuoso Universal Server.

• Canada is taking “Zero-Copy” Data Integration seriously, so what does “Zero-Copy” mean?

• Canada to develop new Data Governance standard to eliminate copies from new applications.

• Here’s what happens when you use an HTML document as a Structured Data Source for a SPARQL query.

• Live example of a Multilingual Knowledge Graph that leverages the deep powers of Structured Data deployed using Linked Data principles.

• Using Single-Tier ODBC-to-JDBC Bridge Drivers to provide QlikView and QlikSense with ODBC connectivity to Athena data, through the Athena JDBC Driver.

• How can you access Mongo database data from Oracle Server?

• Adding DBpediaID hyperlinks as SuperKeys per entity in Analytics dashboards

• Post about SQL, SPARQL, and Graph Analytics, with live examples.

• “Black Box” AI and ML are the biggest dangers to society as we know it. Using RDF, an Ontology, and Rules for Reasoning & Inference (i.e., open standards), is a superior alternative to the “Black Box” madness pushed by hypesters!

• Here is how you can access and query the Linked Open Data Cloud (a/k/a the LOD Cloud).

• Using Virtuoso ODBC and JDBC Drivers (Connectors) to interact with the LOD Cloud Knowledge Graph, using SQL and/or SPARQL.

• OpenLink Virtuoso LOD Cloud connectivity license offers you the ability to access & query the LOD Cloud Knowledge Graph through any deployed Virtuoso ODBC, JDBC, OLEDB, or ADONET client driver or service provider.

Related Links

• LOD Connectivity License for ODBC and JDBC apps to the LOD Cloud Knowledge Graph
• Exploit the powerful Enterprise Knowledge Graph technology provided by our Virtuoso Platform, by taking advantage of our current collection of Special Offers
• Download Virtuoso for On-Premise installation and use
• OpenLink Virtuoso Pay-As-You-Go (PAGO) from the AWS Cloud
  • Virtuoso 8.3.3319 (PAGO) Edition for the AWS Cloud
  • Virtuoso 8.3.3319 (BYOL) Edition for the AWS Cloud
• OpenLink Virtuoso Pay-As-You-Go (PAGO) from the Microsoft Azure Cloud
  • Virtuoso 8.3.3319 (PAGO Edition) for the Microsoft Azure Cloud
  • Virtuoso 8.3.3319 (BYOL Edition) for the Microsoft Azure Cloud
  • Detailed usage guides for Aure
    • Azure OpenLink Virtuoso Ubuntu PAGO VM — with FREE 30 Day Evaluation
    • Azure OpenLink Virtuoso Ubuntu BYOL VM
• Universal Data Access Drivers — Entry-level offers on high-performance drivers/providers/connectors for ODBC, JDBC, ADO.NET, and OLE DB
  • Download Free Trials of our Secure and High-Performance ODBC & JDBC Data Access Drivers (or Connectors) for Oracle, SQL Server, DB2, MySQL, PostgreSQL, Sybase, Informix, Ingres, and 3rd Party ODBC or JDBC Data Sources
• Free OpenLink Structured Data Sniffer (OSDS) Browser Extension for Google Chrome, Microsoft Edge, Mozilla Firefox, Opera, and Vivaldi (with a build planned for Apple Safari)
  • Find out more on the Chrome Browser Extensions Store

Posts from Prior Weeks

• Weekly Summary 2021-02-05
• Weekly Summary 2021-01-29
• Weekly Summary 2021-01-22
• Weekly Summary 2021-01-15
• Weekly Summary 2021-01-07
• Archived listing of weekly summaries from January 2020 to December, 2020