%META:TOPICPARENT{name="InstallConfigXMLAHTML5Bridge"}%

= XMLA Explorer -- Sample HTML5 Program =

The XMLA Explorer is a simple iSQL-like sample HTML5 program which allows connection to any browser accessible XMLA web service endpoint. 

Once connected, a list of available data sources is displayed, and users can easily explore the database schema and/or execute queries against them.

You can 
* [[http://demo.openlinksw.com/XMLAexplorer/XMLAexplorer.html|run the XMLA Explorer immediately, by loading it from our hosted copy]]; or %BR%
* [[http://s3.amazonaws.com/opldownload/XMLAexplorer/XMLAexplorer.zip|download a zip file containing all source files]], allowing local use or hosting on your own Web server.

== Prerequisites ==

# [[InstallConfigXMLAHTML5Bridge|Install and Configure the OpenLink HTML5 WebDB-to-XMLA Bridge]].%BR%
# Make sure you have an XMLA endpoint configured, or configure one now.  In the example below, we'll connect to the XMLA endpoint of the publicly-accessible Virtuoso demo instance /XMLA endpoint -- 
#* <b>host</b> <code>demo.openlinksw.com</code>
#* <b>username</b> <code>vdb</code>
#* <b>password</b> <code>vdb</code>

== Usage ==

# Load the XMLA Explorer sample program in your web browser.
# Choose the default "Local_instance" XMLA data source from the "DSN" drop down list box, enter username and password (if needed), and click the **connect** button.
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp1DSN.png" style="wikiautogen"/>%BR%%BR%
# Upon successful connection, a list of available <nop>DbCatalogs (as in the 3-part identification of database objects -- <nop>DbCatalog.Owner.Table) will be listed in the left frame.  
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp2DbCatalogs.png" style="wikiautogen"/>%BR%%BR%
# Drill down into a <nop>DbCatalog (e.g., Demo) to see the Owner(s) (e.g., demo), and Object(s) therein.
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp3Demodemo.png" style="wikiautogen"/>%BR%%BR%
# Double-click an Object (e.g., Countries) to get a quick and easy look at its 
#* Structure
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp4CountriesStructure.png" style="wikiautogen"/>%BR%%BR%
#* Indexes
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp5CountriesIndexes.png" style="wikiautogen"/>%BR%%BR%
#* Foreign Keys
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp6CountriesFKeys.png" style="wikiautogen"/>%BR%%BR%
#* References (i.e., the Foreign Key inverse)
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp7CountriesRefs.png" style="wikiautogen"/>%BR%%BR%
# When you drill into an object, the "Execute SQL" tab will be pre-populated with a <code>SELECT * FROM &lt;object&gt;</code> query.
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp8CountriesExecSQL.png" style="wikiautogen"/>%BR%%BR%
# You can edit this, or just click on the "Run SQL" button to execute. 
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexp9CountriesSelStar.png" style="wikiautogen"/>%BR%%BR%
# SPARQL queries can also be executed with clickable anchor links generated for URIs.
%BR%%BR%<img src="%ATTACHURLPATH%/XMLAexpAspasql.png" style="wikiautogen"/>%BR%%BR%

== Related Links ==

* [[InstallConfigXMLAHTML5Bridge|HTML5 XMLA Bridge Installation and Configuration]]
* [[http://dev.w3.org/html5/webdatabase/|Web SQL Database API Spec]]
* [[http://virtuoso.openlinksw.com/|OpenLink Virtuoso Website]]