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