AJAX Database Connectivity is the Data Access Component of OAT (
OpenLink AJAX
Toolkit). It's basically an
XML
for Analysis(XMLA) client that enables the development and deployment of database independent Rich Internet Applications (RIAs). Thus, you can now develop database centric AJAX applications without lock-in at the Operating System, Database Connectivity mechanism (ODBC, JDBC, OLEDB, ADO.NET), or back-end Database levels.
XMLA has been around for a long time. Its fundamental goal was to provide Web Applications with Tabular and Multi-dimensional data access before it fell off the radar (a story too long to tell in this post).
AJAX Database connectivity only requires your target DBMS to be XMLA (direct), ODBC, JDBC, OLEDB, or ADO.NET accessible.
I have attached a Query By Example (QBE) screencast movie enclosure to this post (should you be reading this post Web 1.0 style). The demo shows how Paradox-, Quattro Pro-, Access-, and MS Query-like user friendly querying is achieved using AJAX DatabaseConnect Connectivity
About this entry:
Author: Kingsley Uyi Idehen
Published: 05/26/2006 17:59 GMT-0500
Modified: 06/22/2006 08:56 GMT-0500
Tags: ajax , web2.0 , web20 , xml , jdbc , sql , odbc , howto , screencast , javascript , oat , openlink , .net , ado_dot_net , ado , dynamic_languages , oledb , xmla , qbe , msquery , ms_access , ms_query
Categories: Demos , Data Access , SQL , Semantic Web , Content Syndication , XML
Comment Status: 0
Comments
Enclosure:
Permalink:
http://www.openlinksw.com/dataspace/kidehen@openlinksw.com/weblog/kidehen@openlinksw.com%27s%20BLOG%20%5B127%5D/982