User-friendly sql query, report design and data service api

Select a Datasource

Configure Filter Criteria

Select Desired Columns

Select a configured datasource - Qvu supports Oracle, MySQL, Microsoft SQL Server and PostgreSQL datasources. Multiple datasources from multiple database engines can be created as desired.

Select Desired Columns

Configure Filter Criteria

Select Desired Columns

Choose the columns you wish to pull from the database - user can apply aggregate functions, sort position and display name as desired. User can also enter custom SQL expression if desired.

Configure Filter Criteria

Configure the desired filter criteria using current column selections. User can also enter a custom SQL expression if desired. If filter comparison value is left empty user will be prompted to enter value at run time.

Run the Query

Select and Run Saved Query Document

Configure Filter Criteria

Click the run icon to run the query - the user can export the results to excel if desired.

Save the Query

Select and Run Saved Query Document

Save the query design as a re-runnable JSON document that can be executed interactively or via REST api call. REST api call can return results in tabular or JSON format.

Select and Run Saved Query Document

Select and load a saved query document then click the run icon to run. Document can also be run from provided REST api.

Build and Run WYSIWYG Reports

Design, build and run reports using the WYSIWYG Report Designer

Deliver PDF Reports

Build and Run WYSIWYG Reports

Deliver PDF formatted reports interactively or via the scheduler.