Search Results for "sql query"

Qvu Data Service is a free, open source, ad-hoc query, reporting and api data service design tool that allows users to create and save query and report design documents in a user-friendly, web-based UI. Qvu Data Service provides REST API endpoints for users and applications to execute saved documents and return results in tabular, json or png formatted resuls. Qvu Data Service provides role-based datasource, table column and document group access control and supports both Basic and OIDC...

Automatic Report Generator is a mini-ETL API which allows to retrieve data through an SQL query towards a structured file, would it be a CSV, XLSX, or XML. This API also supports BIRT reports, and, in this case, its respective template is required. The project is available on Maven: https://mvnrepository.com/artifact/net.sf.automatic-report-generator Version 3: https://mvnrepository.com/artifact/net.sf.ennahdi.automatic-report-generator Checkout the documentation for both version 2 and version 3: https://sourceforge.net/p/automatic-report-generator/wiki/Home/

****Refer to the improved version of the same application @ https://sourceforge.net/projects/query2report/ **** Light weight reporter, LWR, is a simple web based reporting building and publishing application. LWR transforms bunch SQL queries to charts and displays in a report. Each report has one or more elements arranged in rows and columns. Each element has title, SQL Query, database connection pointing to database from where data is retrieved and type of graph/table renderer. The application uses google charts (default) or jfree charts to build the charting components. ...

This tool is designed to join multiple CSV files into one CSV file with possibility to sort, group and filter data. Based on CSV/Text ODBC Driver it supports almost all futures of the SQL. Works offline. Does not require Microsoft Access, SQL Server and other heavy tools. See wiki for details.

QDepo - A desktop application for retrieving and exporting data from relational database systems to spreadsheet files, also formerly known as "TPDA - Query Repository Tool". The graphical user interface is based on wxPerl or PerlTk. The main feature of the application is the SQL query repository management. The repository consists from a collection of XML files that ca easily be moved or copied to other computers. The supported formats are Excel (.xls), ODF and CSV. The Database management system support includes CUBRID (new), Firebird, MySQL, PostgreSQL and SQLite.

"qryff" is a command that runs on the IBM iSeries (or AS400). It allows you to run SQL queries on the OS400 database from the command line or a CL program. You can output information to the screen, print, or a file. You can also update, delete, insert, and whatever else the iSeries query engine supports. Technically, it is simply an interface to the operating system's "Start Query Management Query (STRQMQRY)" command.

Ifw2Rep is a report generator, web based, allows you to create dinamic reports with a sql query. Build with IFW2 framework and JasperReport