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.
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.
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.
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.
