OpenLink HTML5 WebDB-to-XMLA Bridge
The OpenLink HTML5 WebDB-to-XMLA Bridge extension that provides a binding from the HTML5 Web SQL Database API to tabular XMLA (XML for Analysis) data sources.
XMLA is an HTTP-based protocol enabling data access against tabular (RDBMS) and multi-dimensional (OLAP and ROLAP) data sources.
This extension only deals with tabular data sources that are directly accessible via XMLA, or indirectly accessible via bridges to ODBC (and beyond).
When OpenLink Virtuoso is the target DBMS, users and developers enjoy several additional benefits:
- Virtual/Federated RDBMS access — A single ODBC connection to Virtuoso enables access to, and distributed joins across, all ODBC- or JDBC-accessible data sources
- RDF and Graph Database access — A single ODBC connection to Virtuoso enables SPARQL access to local and/or remote RDF-based Linked Data via SPASQL (SQL and SPARQL query language hybrid)
- Extra fine grained security via client-side X.509 certificates for identity verification courtesy of built-in support for the new HTTP Linked Data-based WebID Protocol.
How do I use it?
Simply install and configure an OpenLink XMLA Provider. Then start using the new Web Database APIs for data access from your HTML5 application as documented by the HTML5 team.
We've provided a Simple Test HTML5 document that uses this API for SQL based RDBMS data access.
The HTML5 WebDB-to-XMLA Bridge currently supports connect strings for these XMLA Providers --
- OpenLink UDA Multi-Tier
- OpenLink UDA Single-Tier
- DSN: leave blank
Note: The Virtuoso XMLA Provider currently only supports read-only connections, hence the Readonly Test Sync Database calls and Readonly Test Async Database calls tests have to be used when running the XMLAsample1.html test page. Thus before executing Virtuoso readonly tests, the following tables need to be created and data inserted:
CREATE TABLE TEST (id INTEGER PRIMARY KEY IDENTITY, string VARCHAR(20), number DOUBLE PRECISION, nuller VARCHAR(20), blober LONG VARBINARY);
INSERT INTO TEST (string, number, nuller, blober) VALUES ('str0', 11111.22, NULL, 0x01020304050607);
INSERT INTO TEST (string, number, nuller, blober) VALUES ('str1', 22222.33, NULL, 0x02030405060808);
Virtuoso versions 6.1.3 and later will support DML (write operations), although XMLA connections will be read-only by default as a security precaution. Running the following command as the DBA user will enable write operations --
How do I install the HTML5 XPI?
Download the HTML5 XMLA XPI
How do I obtain XMLA Providers?
This page is part of the LegacyCollector website.
Disclaimer: All material on this site is property of their respective owners and available under
open licenses to the best of our knowledge. If you are an author and would like anything removed,
then please write an e-mail to legacy [at] collector dot org.