Data Visualization Tools for Relational Databases

Panopticon's visual analysis tools are ideal fits with data stored in traditional row-oriented databases like Oracle, DB2 and Microsoft SQL Server.Relational databases (also called "row-oriented databases" or "row stores") are the most common type of DBMS and are part of almost every organization's IT infrastructure. Panopticon visual analytics tools can connect to virtually all standard relational databases, including DB2, Microsoft SQL Server, Oracle, Sybase ASE, and MySQL.

Build SQL queries into your dashboards

Panopticon's ability to incorporate complex SQL queries into your dashboards means that you can call up information stored in your RDBMS and visualize it in many different ways. You can utilize the heirarchy found in the structure of your relational data or alter it on-the-fly as needed to help you identify outliers and patterns in your data.

Fast data connections to the most popular relational databases

Panopticon EX, our enterprise application designed for fast deployment, comes with data connectors for the most popular databases built into the system. This vastly simplifies initial installation of the system and helps your people start using visual analytics tools with their data in a matter of minutes. EX comes equipped with data connectors for:

• DB2
• Microsoft Access
• Microsoft SQL Server
• MySQL
• Oracle
• Sybase ASE

Visualize data from Excel and CSV files

You can also connect to Microsoft Excel and CSV files with Panopticon in seconds. You can also combine data from a flat file like Excel with data from a row-oriented database like MySQL as well as with data from real-time streaming feeds, CEP engines or column-oriented databases. You use simple Excel-like formulas to combine data in a Panopticon dashboard. Even single information visualizations like Treemaps can include data pulled from multiple sources.

Available in all Panopticon products

All of our products — Panopticon EX, the Developer Developer SDK and our Rapid Development Kit — can connect directly to row-oriented databases or "row stores".

Share