SQL Query & Visual Reporting

InetSoft's SQL capabilities are flexible enough to empower skilled designers while self-service users simply point and click. Beyond building queries, InetSoft's data mashup engine seamlessly integrates disparate data sources. And data output can be quickly visualized within the same web app that delivers the dashboards and reports.

SQL data source business intelligence

Hand Write or Visually Compose SQL Queries

Designers and analysts have the freedom to choose how to write SQL queries in the web app. SQL-fluent users might prefer to hand write SQL aided with meta-data to have maximum flexibility. Other power users would simply compose queries visually. This approach removes the need for exact knowledge of particular database's SQL syntax.

While the default data access mode is live, the resulting data blocks can be set up as automatically updated caches. A cache relieves the load on a source database from visual analyses and interactive reporting.

visual sql queries

Data Mashup and Visual Reporting

InetSoft's data mashup engine, which is part of the web query app, allows designers to bring together disparate databases and other data sources. Queries and data mashups with any level of complexity will normally be refined in an iterative fashion.

InetSoft's web app also integrates data visualization so that a designer can flexibly inspect many aspects of the query results. Designers then seamlessly create dashboards and reports in the same environment.

sql query and mashup

Secured and Governed Self-Service

Designers can empower end users with powerful self-service while maintaining control. InetSoft's data model is built with security control at the data cell level. Many levels of runtime controls allow administrators to prevent run-away queries.

The underlying high performance query cache allows queries to be offloaded and run at designated times. Real time dashboards and reports usage then operates against the cache and generates no load on the database.

sql self-service data query model

More Resources About SQL Dashboards

Creating Stored Procedures - Stored procedures are compiled and stored in a database. There are a few major differences between a stored procedure and a SQL query: A stored procedure is invoked as a function call instead of a SQL query...

Features of an SQL Server Dashboard Tool - An effective SQL Server dashboard tool should possess a set of essential features to provide users with meaningful insights and facilitate data-driven decision-making. Here are key features required for an SQL Server dashboard tool...

Free-form Queries - The SQL can be modified in the text area under the SQL String tab. The view can be changed back to the structured SQL view by selecting the Main Query tab. If the 'Parse SQL' checkbox is selected, the Data Modeler automatically parses the SQL string and reconstructs the graphical view of the query. For very complicated SQL statements that are slow to parse, you may wish to disable parsing by deselecting 'Parse SQL...

SQL Predicates and Simple Expressions - This section lists various supported expressions that can be used in advanced logic and data manipulations at the data modeling and mashup level...