Can this be integrated with a web reporting application so that non technical persons can leverage the drag and drop feature without learning sql queries?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Firstly, yes it can be integrated into a web reporting application.
Already a tool named "Pentaho" has done it long back using SQLeo parent project.
Its a swing application which needs to be embedded into an applet so that it can run in web app, check this post https://sourceforge.net/p/sqleo/discussion/general/thread/df4cd046/ for how to do it.
Secondly,if non-technical people doesn't know relational database concepts like schema,tables,joins if they just drag&drop and click execute they may not understand what is the displayed result.
But if non-technical people at least knows some basics about database and query concepts(just simple where,order clause,joins etc), then it will be a good tool for them as they don't need to bother about writing big SQL queries with proper syntax without learning SQL query syntax.
Mainly this drag and drop feature for queries is very useful for avoiding manually writing large SQL queries and quickly drag&drop than typing the query syntax without bothering about generated SQL syntax and also its good for visualizing the tables relationships with other tables to understand the business well.
Hope it helps!
Cheers
Anudeep
Last edit: Anu 2012-06-28
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can this be integrated with a web reporting application so that non technical persons can leverage the drag and drop feature without learning sql queries?
Firstly, yes it can be integrated into a web reporting application.
Already a tool named "Pentaho" has done it long back using SQLeo parent project.
Its a swing application which needs to be embedded into an applet so that it can run in web app, check this post https://sourceforge.net/p/sqleo/discussion/general/thread/df4cd046/ for how to do it.
Secondly,if non-technical people doesn't know relational database concepts like schema,tables,joins if they just drag&drop and click execute they may not understand what is the displayed result.
But if non-technical people at least knows some basics about database and query concepts(just simple where,order clause,joins etc), then it will be a good tool for them as they don't need to bother about writing big SQL queries with proper syntax without learning SQL query syntax.
Mainly this drag and drop feature for queries is very useful for avoiding manually writing large SQL queries and quickly drag&drop than typing the query syntax without bothering about generated SQL syntax and also its good for visualizing the tables relationships with other tables to understand the business well.
Hope it helps!
Cheers
Anudeep
Last edit: Anu 2012-06-28