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

= ODBC Explorer: A Sample HTML5 Program =

The ODBC Explorer is a simple iSQL-like sample HTML5 program which allows connection to any browser-local ODBC DSN (Data Source Name). 

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

== Setup ==

# Prerequisite: [[InstallConfigODBCHTML5Bridge|Install and configure the HTML5 WebDB-to-ODBC Bridge]].
# You can 
#* [[http://demo.openlinksw.com/ODBCexplorer/ODBCexplorer.html|run the ODBC Explorer immediately, by loading it from our hosted copy]]; or
#* [[http://demo.openlinksw.com/ODBCexplorer.zip|download a zip file containing all source files]], allowing local use or hosting on your own Web server.
# Make sure you have an ODBC DSN configured, or configure one now.  In the example below, we'll connect to the publicly-accessible demo instance of Virtuoso -- 
#* <b>host</b> <code>demo.openlinksw.com</code>
#* <b>port</b> <code>1111</code>
#* <b>username</b> <code>demo</code>
#* <b>password</b> <code>demo</code>

== Usage ==

# Load the ODBC Explorer sample program in your web browser.
# Choose your desired ODBC DSN from the drop down list box, enter username and password (if needed), and click the **connect** button.
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp1DSN.png" style="wikiautogen"/>%BR%%BR%
# Upon successful connection, a list of available <nop>DbCatalogs (as in the 3-part identification of database objects -- {{{DbCatalog.Owner.Table}}}) will be listed in the left frame.  
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp2DbCatalogs.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%/ODBCexp3Demodemo.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%/ODBCexp4CountriesStructure.png" style="wikiautogen"/>%BR%%BR%
#* Indexes
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp5CountriesIndexes.png" style="wikiautogen"/>%BR%%BR%
#* Foreign Keys
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp6CountriesFKeys.png" style="wikiautogen"/>%BR%%BR%
#* References (i.e., the Foreign Key inverse)
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp7CountriesRefs.png" style="wikiautogen"/>%BR%%BR%
# When you drill into an object, the "Execute SQL" tab will be pre-populated with a default query --
{{{
SELECT * FROM &lt;object&gt;
}}}
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp8CountriesExecSQL.png" style="wikiautogen"/>%BR%%BR%
# You can edit this, or just click on the "Run SQL" button to execute. 
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexp9CountriesSelStar.png" style="wikiautogen"/>%BR%%BR%
# SPARQL queries can also be executed with clickable anchor links generated for URIs.
%BR%%BR%<img src="%ATTACHURLPATH%/ODBCexpAspasql.png" style="wikiautogen"/>%BR%%BR%

== Related Links ==

* [[InstallConfigODBCHTML5Bridge|HTML5 ODBC Bridge Installation and Configuration]]
* [[http://dev.w3.org/html5/webdatabase/|Web SQL Database API Spec]]
* [[http://virtuoso.openlinksw.com/|OpenLink Virtuoso Website]]
* [[http://iodbc.org/|Platform-Independent iODBC Project Home Page]]
* [[http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtFOAFSLLODBCLogin| Using WebID for Virtuoso ODBC login]]