Tuesday, January 6, 2009

Data Façade simplfies CRUD implementations

Did you ever had a need to quickly put together an application, to front end a database, providing secured web based CRUD (Create, Read,Update & Delete) capability? Usually these efforts take hundreds of developer hours. Due to lack of funding and/or time, some settle for less flexible options such as Microsoft Access based solutions or spreadsheets. Others keep on postponing implementations loosing operational efficiency.

While there are several frameworks such as "Ruby on Rails", "GoogleKrank" which can cut down the development effort, those technologies still require significant level of coding, configuration effort and a learning curve.

Data Façade (http://www.datafacade.com/) is a ready to run, out of the box solution that can be used to Web enable your databases within minutes.All you do is setup a data source, pick the table(s) and columns to be exposed and their visual aspects, all thru an easy to use Web interface and you'll have an application ready to use.

Due to the nature of Data Façade, it is considered an On-Demand Delivery (ODD) framework, instead of a Conventional Development framework as there is no development involved in most cases. It produces a fully data driven web application on the fly. The hot configurable Web User Interface layer with rich feature set provides a Façade for data sources simplifying CRUD (Create, Read, Update and Delete) functionality. Data Façade also provides a java based extension framework to customize the behavioral aspects such as actions and events.

Following are the key features of the framework.

1. Platform independent Java based solution

2. Provides full featured CRUD capability, including search, sort,filter, data grouping, ordering, look-ups, tool tips and validation.

3. Multiple data source support

4. Web Based - near real time configuration/deployment process

5. Ability to expose table content with parent-child relationships including data from heterogeneous data sources.

6. Field level customization, including Visuals, Data Integrity,Validation and Tool tips.

7. Superior extendability thru custom Java actions.

8. Ability to integrate with existing NTLM, Proxy based and/or Database based user authentication mechanisms. Security module can be further extended thru custom API

9. General customization of look and feel via style-sheets

10. Component level Role Based Security.

11. Basic reporting capability.

It can be downloaded as a self contained zip wile with apache Tomcat and JVM, so all you have to do is download, extract and run the start up script. For those who already having tomcat instance running,you can just download the Web Application and Setup Application which can get you going within few mouse clicks.

Please visit http://www.datafacade.com/ for more details.

2 comments:

  1. I downloaded Data Facade (http://www.datafacade.com/download.html) & started up the tomcat instance. When I try to access web console using http://localhost:8080/WebDB it gives me following error.
    Tomcat seems to have started correctly as I can access other web contexts (eg: http://localhost:8080/tomcat-docs/index.html).

    java.lang.NullPointerException
    at com.bgs.db.ConnectionManager.registerDataSource(ConnectionManager.java:142)
    at com.bgs.db.ConnectionManager.init(ConnectionManager.java:52)
    at com.bgs.db.ConnectionManager.getInstance(ConnectionManager.java:44)
    at com.bgs.db.Config.init(Config.java:41)
    at com.bgs.db.Config.init(Config.java:18)
    at com.bgs.db.Config.getInstance(Config.java:13)
    at login_jsp._jspService(login_jsp.java:54)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)

    ReplyDelete
  2. Did you download the full verstion (including tomcat and jdk, or just the WebDB.war?
    If it's just the WebDB.war you'll have to download the start DataFacadeSetup.zip as well and unzip it in to the bin folder.
    Basically you nead the LiQfy folder directly in the startup folder (i.e. bin directory)

    Please let me know if this worked?

    ReplyDelete