Visualize Database Data

Create Vivid Charts from SQL

Charts & graphs from SQL query results
Real-time updates when data changes
Multiple charts simultaneously from complex queries
Granular customization of chart appearance

Support for background images
Chart overlays to combine chart types
Exporting charts as image files
Save / copy / print charts

SQL Charting Tools

A colorful, eye-catching chart is much more vivid and communicates meaning more effectively than a table of numeric data. DatabaseSpy provides a wide variety of tools for generating charts and graphs to display SQL query results. To create an accurate and vivid graphical representation of numerical data you can choose among line, bar, pie, and area charts with myriad advanced formatting options.

Create charts for any of the following SQL databases:

Firebird 2.5, 3, 4
IBM DB2 for iSeries^® v6.1, 7.1, 7.2, 7.3, 7.4
IBM DB2^® 8, 9.1, 9.5, 9.7, 10.1, 10.5, 11.5, 11.5.7
Informix^® 11.70, 12.10, 14.10
MariaDB 10, 10.3, 10.4, 10.5, 10.6.5, 10.9.2, 10.11, 11.2, 11.4
Microsoft Access™ 2003, 2007, 2010, 2013, 2019
Microsoft^® Azure SQL
Microsoft^® SQL Server^® 2005-2022
MySQL^® 5, 5.1, 5.5, 5.6, 5.7, 8, 8.0.25, 8.0.28, 8.2, 8.3, 8.4
Oracle^® 9i, 10g, 11g, 12c, 18, 19
PostgreSQL 8, 9, 10, 11, 12, 13, 14, 15, 16
Progress OpenEdge 11.6
SQLite 3.x
Sybase^® ASE 15, 16
Teradata 16

With DatabaseSpy, you can create attractive and informative charts to represent data in your database without the need for dedicated chart creation software.

The following chart types are supported:

Pie charts (2D & 3D)
Bar charts (2D & 3D)
Stacked bar charts (2D & 3D)
Area charts
Stacked area charts (with transparency)
Category and value line graphs
Candlestick charts
Gauge charts

Numerous customization options are available for each chart type, including chart titles, foreground and background colors, definition of axis ranges and labels, control of fonts, text colors, fonts and sizes, and more. Intuitive dialogs let you specify every element of a chart, even the tilt angle for 3D pie charts.

Visualize Database Data

You can generate DatabaseSpy charts based on relational data, or on calculations performed in SQL statements. For instance, you could calculate total sales for each sales region and compare them in a bar chart. Two gauge chart styles are available for illustrating individual calculated values.

A link in the Altova DatabaseSpy SQL Editor Results window toolbar opens the Chart Selection dialog, where you can specify which column of your Results table should be used for the X-axis. You can also change the order of value columns, or even leave a results column uncharted.

Saving & Exporting Charts

When your chart is complete, it's easy to print it, copy it to the clipboard to paste directly in another application, or save it as an image file. When you save to a file, you can select the exact image size in pixels to suit your final reporting application. Charts generated using DatabaseSpy are easy to custimize for business intelligence reports in HTML, Microsoft Word, RTF, or PDF documents, or you can save charts in your choice of .png, .bmp, .gif, or .jpg image formats.

Advanced Database Reporting with Charts

For a more complete database reporting solution, Altova StyleVision is an award-winning tool for designing compelling reports and forms based on XML, SQL database, and XBRL inputs. With a few simple steps, you can access data in SQL databases and create visually compelling reports with charts in HTML, PDF, RTF, Word, and plain text, all in a single design. Then, automatically regenerate the report with updated data any time it’s needed.

Language:
EN
DE
ES
JA
FR