|
1KEY AGILE has dynamic query engine with expression builder and model creator. It provides the facility to use simple graphical interface to build SQL statements and create views in a database. It has graphical panes that displays your SQL statements visually and a text pane that displays the text of your SQL statement. You can work in either the graphical or text panes.
1KEY Query Expert provides the facility to u se simple graphical interface to build SQL statements and create views in a database. It includes graphical panes that display your SQL statement visually and a text pane that displays the text of your SQL statement. You can work in either the graphical or text panes.
Key Features include
- Visual Interface to design queries
- Creation of links with simple drag & drop functionality
- Automatic SQL Statement Generation
- Localization - option of specifying own parameters
- SQL parsing - enter the SQL statement, and the diagram and grid gets populated
Visual interface to design queries & Create Links with drag and drop
You can easily specify which fields you want in your query by selecting them with a checkbox next to field name. 1KEY Query Expert will create link between tables with relationships in the database. You can also create your own links by dragging a field from one table to another field. Link options and table options are showcased above
SQL Pane : Automatic SQL Statement generation
1KEY Query Expert provides with results of the executed Select Query.
Results Pane: Data Output in 1KEY Query Expert
1KEY Query Expert provides with results of the executed Select Query
For further details sales@maia-intelligence.com
|
