%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 -- #* host demo.openlinksw.com #* port 1111 #* username demo #* password demo == 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%%BR%%BR% # Upon successful connection, a list of available DbCatalogs (as in the 3-part identification of database objects -- {{{DbCatalog.Owner.Table}}}) will be listed in the left frame. %BR%%BR%%BR%%BR% # Drill down into a DbCatalog (e.g., {{{Demo}}}) to see the Owner(s) (e.g., {{{demo}}}), and Object(s) therein. %BR%%BR%%BR%%BR% # Double-click an Object (e.g., {{{Countries}}}) to get a quick and easy look at its #* Structure %BR%%BR%%BR%%BR% #* Indexes %BR%%BR%%BR%%BR% #* Foreign Keys %BR%%BR%%BR%%BR% #* References (i.e., the Foreign Key inverse) %BR%%BR%%BR%%BR% # When you drill into an object, the "Execute SQL" tab will be pre-populated with a default query -- {{{ SELECT * FROM <object> }}} %BR%%BR%%BR%%BR% # You can edit this, or just click on the "Run SQL" button to execute. %BR%%BR%%BR%%BR% # SPARQL queries can also be executed with clickable anchor links generated for URIs. %BR%%BR%%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]]